Tests

SQL Test

Search Questions:

________ is an operation that displays rows which meet a condition.

Restriction 89.0%

Extraction 0.0%

Projection 6.0%

Intersection 0.0%

Union 3.0%

Minus 0.0%

None of the above 0.0%

_________ is the operation that displays certain columns from the table.

Restriction 0.0%

Intersection 3.0%

Join 0.0%

Union 0.0%

Projection 81.0%

Selection 11.0%

Extraction 0.0%

SubQuery 3.0%

< and > are examples of _________ type of operators.

Logical 81.0%

Arithmetic 0.0%

Assignment 0.0%

Ternary 0.0%

Relational 0.0%

Numeric 0.0%

Comparison 18.0%

None of the above 0.0%

A company has the following departments: Marketing , Designing , Production , Packing What will be the result of the following query? select * from table where department < 'Marketing';

The query will return " Designing , Packing " 0.0%

The query will return " Designing , production ,Packing " 0.0%

The query will return "Packing" 0.0%

Strings cannot be compared using < operator 0.0%

The query will return " Designing " 100.0%

A construction company is currently executing three projects- hotel construction, residential construction and business towers. The construction company employs both Civil Engineers and Structural ...

one to many, one to one 0.0%

one to one, one to many 38.0%

many to one, many to many 61.0%

many to one, many to one 0.0%

A production house has two sales outlets. Both outlets are maintaining their data separately in schemas A and B respectively. The Management wants to see the sale of both outlets in one report. Bot...

Select * from A.Sales join B.Sales 0.0%

Select * from A.Sales union all B.Sales 100.0%

Select * from A.Sales, B.Sales 0.0%

None of the above 0.0%

A production house needs a report about the sale where total sale of the day is more than $20,000. Which query should be used?

select * from orders where sum(amount) > 20000 0.0%

select orderdate, sum(amount) from orders where sum(amount) > 20000 order by OrderDate 0.0%

select orderdate, sum(amount) from orders group by orderdate having sum(amount) > 20000 100.0%

select orderdate, sum(amount) from orders group by OrderDate where sum(amount) > 20000 0.0%

A table has following values for its department field: marketing, production, production, sales, NULL, NULL, Marketing, Null What will the following query return: Select distinct(department) fro...

marketing, production, sales 0.0%

marketing, production, sales, NULL 81.0%

marketing, production, sales, NULL, NULL 0.0%

marketing, production, sales, NULL, Marketing 18.0%

marketing, production, sales, NULL, NULL, Marketing 0.0%

A table Students has a column called name which stores the names of the students. What will be the correct query to display the names of the students in reverse order?

Select name from students reverse; 0.0%

Select name from students reverse name; 0.0%

Select name from students order by name descending; 0.0%

Select name from students order by name reverse; 0.0%

Select name from students order by name desc; 100.0%

Select desc name from students; 0.0%

Select reverse name from students; 0.0%

An association of several entities in a Entity-Relation model is called?

Tuple 0.0%

Record 0.0%

Relationship 100.0%

Field 0.0%

An RDBMS performs the following steps: 1)It calculates the results of the group functions of each group 2)It groups those rows together based on the group by clause 3)It orders the groups based on ...

4,3,5,1,2 0.0%

4,5,3,2,1 0.0%

5,2,1,4,3 83.0%

5,2,3,4,1 8.0%

2,3,1,4,5 0.0%

2,3,1,5,4 0.0%

1,2,3,4,5 8.0%

3,2,1,4,5 0.0%

Are both the statements correct? (a)where deptno in(2,4,5) (b)where deptno=2 or deptno=4 or deptno=5

True 100.0%

False 0.0%

Choose the appropriate query for the Products table where data should be displayed primarily in ascending order of the ProductGroup column. Secondary sorting should be in descending order of the Cu...

Select * from Products order by CurrentStock,ProductGroup 0.0%

Select * from Products order by CurrentStock DESC,ProductGroup 0.0%

Select * from Products order by ProductGroup,CurrentStock 0.0%

Select * from Products order by ProductGroup,CurrentStock DESC 100.0%

None of the above 0.0%

Consider the following tables: Books BookId BookName AuthorId SubjectId PopularityRating (the popularity of the book on a scale of 1 to 10) Language (such as French, English, German etc) Subjec...

select subject,count(*) from books,subjects where books.subjectid=subjects.subjectid group by books.subjectid 83.0%

select count(*),subject from books,subjects where books.subject.id=subjects.subject.id group by subjects.subject 16.0%

select subject,count(*) from books,subjects where books.Authorid=subjects.Authorid group by books.subjectid,subjects.subject 0.0%

select subject,count(*) from books,subjects where books.BookId=subjects.BookId group by books.subjectid,subjects.subject 0.0%

Consider the following tables: Books ------ BookId BookName AuthorId SubjectId PopularityRating (the popularity of the book on a scale of 1 to 10) Language (such as French, Eng...

select subject,count(*) as Books from books,subjects where books.popularityrating > 7 group by subjects.subject 0.0%

select subject,count(*) as Books from books,subjects where books.authorid=subjects.authorid and books.popularityrating > 7 group by subjects.subject 0.0%

select subject,count(*) as Books from books,subjects where books.subjectid=subjects.subjectid and books.popularityrating = 7 group by subjects.subject 8.0%

select subject,count(*) as Books from books,subjects where books.subjectid=subjects.subjectid and books.popularityrating > 7 group by subjects.subject 91.0%

select AuthorName from Authors where AuthorId in (select AuthorId from Books group by AuthorId having count(*)>1) 50.0%

select AuthorName from Authors, Books where Authors.AuthorId=Books.AuthorId and count(BookId)>1 0.0%

select AuthorName from Authors, Books where Authors.AuthorId=Books.AuthorId group by AuthorName having count(*)>1 44.0%

select AuthorName from Authors where AuthorId in (select AuthorId from Books having count(BookId)>1) 5.0%

select authorname from authors where authorid in (select authorid from books where popularityrating<5) 100.0%

select authorname from authors where authorid in (select authorid from books where popularityrating<=5) 0.0%

select authorname from authors where authorid in (select BookId from books where popularityrating<5) 0.0%

select authorname from authors where authorid in (select authorid from books where popularityrating in (0,5)) 0.0%

select bookname from books where language='German' and popularityrating = (select popularityrating from books where language='French') 0.0%

select bookname from books where language='German' and popularityrating > (select popularityrating from books where language='French') 0.0%

select bookname from books where language='French' and popularityrating > (select max(popularityrating) from books where language='German') 0.0%

select bookname from books where language='German' and popularityrating > (select max(popularityrating) from books where language='French') 100.0%

select bookname from books where language='French' and popularityrating = (select max(popularityrating) from books where language='French') 90.0%

select bookname from books where language='French' and popularityrating = (select max(popularityrating) from books Having language='French') 0.0%

select bookname,max(popularityrating) from books where language='French' and max(popularityrating) 0.0%

select bookname,max(popularityrating) from books where language='French' having max(popularityrating) 10.0%

Consider the following two tables: 1. customers( customer_id, customer_name) 2. branch ( branch_id, branch_name ) What will be the output if the following query is executed: Select *, bran...

It will return the fields customer_id, customer_name, branch_name with a cartesian join 11.0%

It will return the fields customer_id, customer_name, branch_id, branch_name with a cartesian join 0.0%

It will return the fields customer_id, customer_name, branch_id, branch_name, branch_name with a cartesian join 88.0%

It will return an empty set since the two tables do not have any common field name 0.0%

It will return an error since * should be for queries involving one table only 0.0%

Consider the query: SELECT name FROM Student WHERE name LIKE '_a%'; Which names will be displayed?

Names starting with "a" 0.0%

Names containing "a" as the second letter 100.0%

Names starting with "a" or "A" 0.0%

Names containing "a" as any letter except the first 0.0%

Data validation can be implemented at the data definition stage through:

Check constraints with specified values 29.0%

Referential constraints, by creating foreign keys for another table 37.0%

Default value of column 4.0%

Not Null constraint 29.0%

Evaluate the following SQL statement: SELECT e.employee_id, (.15* e.salary) + (.5 * e.commission_pct) + (s.sales_amount * (.35 * e.bonus)) AS CALC_VALUE FROM employees e, sales s WHERE e.employee_...

The value displayed in the CALC_VALUE column will be lower 0.0%

The value displayed in the CALC_VALUE column will be higher 0.0%

There will be no difference in the value displayed in the CALC_VALUE column 100.0%

An error will be reported 0.0%

Every Boyce-Codd Normal Form(BCNF)is in:

First Normal Form 0.0%

Second Normal Form 0.0%

Third Normal Form 88.0%

None of the above 11.0%

Examine the code given below: SELECT employee_id FROM employees WHERE commission_pct=.5 OR salary > 23000 Which of the following statements is correct with regard to this code?

It returns employees whose salary is 50% more than $23,000 0.0%

It returns employees who have 50% commission rate or salary greater than $23,000 100.0%

It returns employees whose salary is 50% less than $23,000 0.0%

None of the above 0.0%

Examine the data in the EMPLOYEES table given below: LAST_NAME DEPARTMENT_ID SALARY ALLEN 10 3000 MILLER 20 1500 KING ...

SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id); 26.0%

SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id); 0.0%

SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id); 36.0%

SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id); 36.0%

SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY)); 0.0%

Examine the description of the STUDENTS table: STD_ID NUMBER (4) COURSE_ID VARCHAR2 (10) START_DATE DATE END_DATE DATE The aggregate functions valid on the ST...

SUM(start_date) 0.0%

AVG(start_date) 0.0%

COUNT(start_date) 53.0%

AVG(start_date, end_date) 0.0%

MIN(start_date) 46.0%

Examine the query:- select (2/2/4) from tab1; where tab1 is a table with one row. This would give a result of:

4 0.0%

2 0.0%

1 0.0%

.5 0.0%

.25 50.0%

0 50.0%

8 0.0%

24 0.0%

Examine the two SQL statements given below: SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC What is tru...

The two statements produce identical results 100.0%

The second statement returns an error 0.0%

There is no need to specify DESC because the results are sorted in descending order by default 0.0%

For which SQL operation is Alter Table used?

To add a column 0.0%

To add an integrity constraint 0.0%

To modify storage characteristics 0.0%

To enable/disable or drop an integrity constraint 0.0%

all of the above 100.0%

How can data be accessed by users who do not have direct access to the tables?

By creating views 88.0%

By creating triggers 0.0%

By creating stored procedures 11.0%

None of the above 0.0%

How many foreign key constraints can a table have?

1 0.0%

2 0.0%

3 0.0%

4 0.0%

5 0.0%

6 0.0%

None of the above 100.0%

Identify the incorrect statement/s regarding constraints.

A primary key constraint can be disabled 8.0%

Information about the constraints on a table can be retrieved from the data dictionary 0.0%

Information about the columns on which the constraints have been applied can be retrieved from the data dictionary 0.0%

There can be only one unique key in a table 50.0%

If a column has null values then the not null constraint cannot be applied to that column 8.0%

There can be more than one primary key 33.0%

If E1 and E2 are relational algebra expressions, then which of the following is NOT a relational algebra expression?

E1 U E2 0.0%

E1 / E2 100.0%

E1 - E2 0.0%

E1 x E2 0.0%

If entity x is existence-dependent on entity y then what is x said to be?

Dominant entity 0.0%

Subordinate entity 100.0%

Primary entity 0.0%

Secondary entity 0.0%

In which sequence are queries and sub-queries executed by the SQL Engine?

primary query -> sub query -> sub sub query and so on 0.0%

sub sub query -> sub query -> prime query 80.0%

the whole query is interpreted at one time 0.0%

there is no fixed sequence of interpretation, the query parser takes a decision on the fly 20.0%

In which type of database is SQL used?

Hierarchical 0.0%

Network 0.0%

Relational 100.0%

Object oriented 0.0%

All of above 0.0%

Point out the incorrect statement regarding group functions:

Group functions act on a group of rows 0.0%

Group functions return one result for all the rows operated upon 0.0%

Group functions ignore the null values 25.0%

Stdev and variance are examples of group functions 41.0%

One cannot combine group and single value functions in a query 25.0%

Sum is not a group function 8.0%

Select all the appropriate options.

A table is a multiset of rows 29.0%

A table is a two-dimensional array of rows and columns 29.0%

A table is always dependent on other tables 5.0%

A third normal form table is a table free of redundant data 23.0%

A table must have a primary key 11.0%

The concept of data independence is similar to the concept of ________

Data type 33.0%

Abstract data type 66.0%

Consolidation 0.0%

Isolation 0.0%

The Employee table uses alphanumeric characters for their Employee ID field, which contains 7 digits prefixed with 3 characters. The alphanumeric characters refer to the department code. You want t...

CONCAT() 0.0%

SUBSTR() 16.0%

UPPER() 83.0%

LOWER() 0.0%

REPLACE() 0.0%

The level of abstraction which describes only part of the entire database is called?

Conceptual level 100.0%

View level 0.0%

Procedural level 0.0%

None of the above 0.0%

The level of data abstraction which describes how the data is actually stored is?

Physical level 75.0%

Conceptual level 0.0%

Storage level 25.0%

File level 0.0%

The names of those departments where there are more than 100 employees have to be displayed. Given two relations, employees and departments, what query should be used? Employee --------- Empno Empl...

Select departname from department where deptno in (select deptno from employee group by deptno having count(*) > 100); 100.0%

Select departname from department where deptno in (select count(*) from employee group by deptno where count(*) > 100); 0.0%

Select departname from department where count(deptno) > 100; 0.0%

Select departname from department where deptno in (select count(*) from employee where count(*) > 100); 0.0%

The overall logical structure of a database can be expressed graphically by:

Data Flow Chart 0.0%

Flow Chart 0.0%

Directed Chart 0.0%

Entity-Relationship Diagram 100.0%

None of the above 0.0%

The purpose of the domain is to constrain the set of valid values. True or false?

True 100.0%

False 0.0%

The simplest query must include at least________ and _________.

A select clause 55.0%

A where clause 0.0%

A from clause 44.0%

A group by clause 0.0%

A having clause 0.0%

An order by clause 0.0%

The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER (12) SEMESTER_END DATE GPA NUMBER (4) Which of the following statements finds the highest Grade Point Ave...

SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL 0.0%

SELECT (gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL 0.0%

SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL GROUP BY semester_end 20.0%

SELECT MAX(gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student_grades 0.0%

SELECT MAX(gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL 80.0%

There are two tables A and B. You are retreiving data from both tables where all rows from B table and only matching rows from A table should be displayed. Which type of join you will apply between...

Inner join 0.0%

Left outer join 0.0%

Right outer join 100.0%

Self join 0.0%

View the following Create statement: 1 Create table Pers 2 (EmpNo Number(4) not null, 3 EName Char not null, 4 Join_dt Date not null, 5 Pay Number) Which line contains an error?

1 0.0%

2 20.0%

3 0.0%

4 0.0%

5 80.0%

What are the columns of a table called in a relational model?

Attributes 100.0%

Rows 0.0%

Tuples 0.0%

Constraints 0.0%

Keys 0.0%

Indexes 0.0%

Sets 0.0%

Elements 0.0%

What are the programs that execute automatically whenever DML operations are performed on tables called?

Triggers 100.0%

Procedures 0.0%

Functions 0.0%

None of the above 0.0%

What clause should be used to display the rows of a table in ascending order of a particular column?

Where 0.0%

Order By 100.0%

Group By 0.0%

Having 0.0%

First Group By and then Having 0.0%

Like 0.0%

Between 0.0%

What does MOD() function do?

Returns the remainder after division 100.0%

Modifies the column definition 0.0%

Modifies the definition of a table 0.0%

None of the above 0.0%

What does the term DDL stand for?

Data Description Language 0.0%

Dynamic Data Language 0.0%

Data Definition Language 100.0%

Data Derived Language 0.0%

Descriptive Data Language 0.0%

What is a cluster?

Group of users 0.0%

Group of indexes 0.0%

Method of storing tables that are intimately related and often joined together into the same area of the disk 0.0%

Compressed datafile 0.0%

Segment of a partitioned table 0.0%

Group of constraints 0.0%

Group of databases 100.0%

Group of roles 0.0%

What is a rollback of transactions normally used for?

Recover from the transaction failure 40.0%

Update the transaction 0.0%

Retrieve old records 60.0%

None of the above 0.0%

What is the collection of information stored in a database at a particular moment called?

Schema 0.0%

Instance 0.0%

Table 0.0%

Cluster 0.0%

View 100.0%

Index 0.0%

None of the above 0.0%

What is the correct order of clauses in the select statement? 1 select 2 order by 3 where 4 having 5 group by

1,2,3,4,5 0.0%

1,3,5,4,2 100.0%

1,3,5,2,4 0.0%

1,3,2,5,4 0.0%

1,3,2,4,5 0.0%

1,5,2,3,4 0.0%

1,4,2,3,5 0.0%

1,4,3,2,5 0.0%

What is the error in the following query if the Students table contains several records? select name from students where name = (select name from students order by name);

= should be replaced by in operator 57.0%

Order by clause in the subquery should be preceded with a group by clause 0.0%

Order by clause in the subquery can be used only if the where and group by clauses have been applied 0.0%

Group by clause should be applied to the outer query 28.0%

An order by clause is not allowed in a subquery 14.0%

There is no error 0.0%

What is the order of precedence among the following operators? 1 IN 2 NOT 3 AND 4 OR

1,2,3,4 0.0%

2,3,4,1 100.0%

1,2,4,3 0.0%

1,4,3,2 0.0%

4,3,2,1 0.0%

4,1,2,3 0.0%

4,2,1,3 0.0%

3,2,1,4 0.0%

What is wrong with the following query: select * from Orders where OrderID = (select OrderID from OrderItems where ItemQty > 50)

In the sub query, '*' should be used instead of 'OrderID' 0.0%

The sub query can return more than one row, so, '=' should be replaced with 'in' 100.0%

The sub query should not be in parenthesis 0.0%

None of the above 0.0%

What items, other than column names can be included in the select clause?

Arithmetic expressions 66.0%

Column aliases 16.0%

Concatenated columns 16.0%

None of the above 0.0%

What will happen if you query the emp table as shown below: select empno, DISTINCT ename, Salary from emp;

EMPNO, unique value of ENAME and then SALARY are displayed 0.0%

EMPNO, unique value ENAME and unique value of SALARY are displayed 0.0%

DISTINCT is not a valid keyword in SQL 0.0%

No values will be displayed because the statement will return an error 100.0%

When a table is dropped using a simple DROP statement, SQL performs some more operations simultaneously, select all the valid operations?

Removes all rows from the table 40.0%

Drops all the table's indexes 60.0%

Removes all dependent views 0.0%

Removes all dependent procedures 0.0%

Where should sub queries be used?

To define the set of rows to be inserted in a table 0.0%

To define the set of rows to be included in a view 0.0%

To define one or more values to be assigned to existing rows 0.0%

To provide values for conditions in the Where clause 0.0%

To define a table to be operated on by a containing query 0.0%

All of the above are correct 100.0%

None of the above is correct 0.0%

Which are not DCL operations?

Insert 18.0%

Grant 6.0%

Delete 18.0%

Update 18.0%

Revoke 0.0%

Commit 18.0%

Rollback 18.0%

Which character function should be used to return a specified portion of a character string?

CONCAT 0.0%

LENGTH 0.0%

SUBSTR 100.0%

INITCAP 0.0%

Which component of an RDBMS validates the syntax of the user's query?

Query Parser 100.0%

The Database Manager 0.0%

Query Optimization 0.0%

Database Administrator 0.0%

Which logical operator can reverse the result?

AND 0.0%

OR 0.0%

NOT 100.0%

ANY 0.0%

Which of the following are aggregate functions in SQL?

Avg 44.0%

Select 0.0%

Order By 0.0%

Sum 55.0%

Union 0.0%

Group by 0.0%

Having 0.0%

Which of the following can be used to uniquely identify a row?

Primary Key 0.0%

Unique Key 80.0%

Foreign Key 20.0%

All of the above 0.0%

Which of the following constraints cannot be applied at the table level?

Primary key 0.0%

Foreign key 0.0%

Not null 50.0%

Check 0.0%

Unique 50.0%

Which of the following date function(s) are invalid in Oracle SQL?

NEXT_DAY 0.0%

NEXT_MONTH 100.0%

MONTHS_BETWEEN 0.0%

DAYS_BETWEEN 0.0%

Which of the following field names are correct?

EmpNo 30.0%

25Block 10.0%

#AccountID 20.0%

_CustomerName 30.0%

Product.Name 10.0%

Which of the following is not a DDL command?

Drop 0.0%

Create 0.0%

Alter 0.0%

Revoke 20.0%

Explain plan 20.0%

Insert 20.0%

Update 20.0%

Delete 20.0%

Which of the following is not a DML command?

Set transaction 17.0%

Explain plan 11.0%

Update 0.0%

Grant 17.0%

Insert 0.0%

Create 17.0%

Alter 17.0%

Revoke 17.0%

Which of the following is not a feature of SQL?

SQL is a non-procedural language 0.0%

SQL processes sets of records rather than a single record at a time 100.0%

SQL can be used by a range of users including DBA's, application programmers, management personnel and many other types of end users 0.0%

Procedures and functions can be written with SQL 0.0%

SQL provides commands for a variety of tasks including querying data and inserting, updating and deleting data 0.0%

SQL can retrieve data from more than one table 0.0%

Which of the following is not a numeric group function?

Avg 0.0%

Count 0.0%

Highest 100.0%

Max 0.0%

Stdev 0.0%

Sum 0.0%

Which of the following is not a relational operation?

Restriction 0.0%

Extraction 100.0%

Projection 0.0%

Intersection 0.0%

Union 0.0%

Which of the following is not a set operator?

Union 0.0%

Union all 0.0%

Intersect 0.0%

Minus 0.0%

Minus all 100.0%

Which of the following is not a single value function?

Round 0.0%

Floor 0.0%

Avg 100.0%

Sqrt 0.0%

Tan 0.0%

Which of the following is not a SQL operator?

Between..and.. 0.0%

Like 0.0%

In 0.0%

Is null 0.0%

Having 100.0%

Not in 0.0%

Which of the following is not a type of constraint?

Primary key 0.0%

Unique 0.0%

Check 0.0%

Distinct 100.0%

Default 0.0%

Which of the following is not the benefits of views?

Restricting access to database 33.0%

Allowing users to make simple queries to retrieve the results from complicated queries 0.0%

Providing data independence for adhoc users and application programs 0.0%

Faster retrieval of records 66.0%

Views allow the same data to be seen by different users in different ways 0.0%

Which of the following statement is correct regarding table creation?

Tables once created cannot be modified to add columns 0.0%

Constraints can only be given while table creation 0.0%

One can easily create a table from a given table 100.0%

When a table is created from another table, all the constraints are copied as well 0.0%

The width of the columns cannot be modified 0.0%

Columns cannot be removed from a table 0.0%

Which of the following statements are incorrect regarding definition of simple and complex views?

A simple view is one which derives data from only one table 0.0%

A simple view is one which contains no functions or groups of data 10.0%

A complex view is one which derives data from many tables 0.0%

A complex view is one which may contain functions 10.0%

A complex view cannot contain groups of data 40.0%

A complex view is a combination of more than one simple view 10.0%

A table can either have a simple or complex view, not both 30.0%

Which of the following statements are not true regarding the primary key?

There can only be one primary key in a table 0.0%

An index is automatically generated upon creation of a primary key 0.0%

A primary key can accept null values 33.0%

A primary key can be composite 0.0%

A primary key constraint can be either at the column level or at the table level 33.0%

There can be more than one primary key in a table 33.0%

Which of the following statements are true?

With DDL you can create and remove tables, schemas, domains, indexes and views 100.0%

Select, Insert and Update are DCL commands 0.0%

Grant and Revoke are DML commands 0.0%

Commit and Rollback are DCL commands 0.0%

Which of the following statements are wrong about primary keys?

The primary key field must contain unique values 0.0%

The primary key field can contain null values 30.0%

A primary key is the column or set of columns that makes every row in the table unique 0.0%

A primary key can be created with a maximum of three columns 30.0%

Each table can have more than one primary keys 30.0%

Unique key is another name for primary key 10.0%

Which of the following statements is true? (a)The Insert statement creates new rows (b)The Update statement modifies the table structure

only (a) is true 100.0%

only (b) is true 0.0%

both (a) and (b) are true 0.0%

both (a) and (b) are false 0.0%

Which of the following statements regarding views are incorrect?

A view is like a window through which data on tables can be viewed or changed 28.0%

A view is derived from another table 0.0%

A view cannot be derived from another view 28.0%

A view is stored as a select statement only 0.0%

A view has no data of its own 0.0%

A view is another name for a table 42.0%

Which one of the following correctly selects rows from the table myTable that have null in column column1?

SELECT * FROM myTable WHERE column1 is null 100.0%

SELECT * FROM myTable WHERE column1 = null 0.0%

SELECT * FROM myTable WHERE column1 EQUALS null 0.0%

SELECT * FROM myTable WHERE column1 NOT null 0.0%

SELECT * FROM myTable WHERE column1 CONTAINS null 0.0%

Which operator will be evaluated first in the following statement: select (age + 3 * 4 / 2 - 8) from emp

+ 0.0%

- 0.0%

/ 0.0%

* 100.0%

Which query will display data from the Pers table relating to Analysts, Clerks and Salesmen who joined between 1/1/2005 and 1/2/2005 ?

select * from Pers where joining_date from '1/1/2005' to '1/2/2005', job='Analyst' or 'Clerk' or 'Salesman' 0.0%

select * from Pers where joining_date between '1/1/2005' to '1/2/2005', job='Analyst' or job='Clerk' or job='Salesman' 0.0%

select * from Pers where joining_date between '1/1/2005' and '1/2/2005' and (job='Analyst' or 'Clerk' or 'Salesman') 25.0%

None of the above 75.0%

Which statement is correct for FIRST NORMAL FORM?

Includes only tables that do not have composite primary keys 0.0%

Must have data stored in a two-dimensional table with no repeating groups 100.0%

Every non-key column is nontransitively dependent upon its primary key 0.0%

None of the above 0.0%

Which statements are true for views?

The definition of a view is stored in data dictionary 50.0%

Views provide a more secure way of retrieving data 50.0%

Views are actually Tables and store data in the same manner as Tables 0.0%

With regard to statement (a) and statement (b), Which of the following option is correct. (a)The FLOOR function returns the smallest integer greater or equal to the argument. (b)The CEIL function ...

(a) is true 0.0%

(b) is true 0.0%

both (a) and (b) are true 0.0%

both (a) and (b) are false 100.0%