MCQ 1 The file organisation that provides very fast access to any arbitrary record of a file is

(A) Ordered file (B) Unordered file (C) Hashed file (D) B-tree

MCQ 2 Which of the following is a comparison operator in SQL?

(A) = (B) LIKE (C) BETWEEN (D) All of the above

MCQ 3 Which of the following is another name for the weak entity?

(A) Child (B) Owner (C) Dominant (D) All of the above

MCQ 4 NULL is

(A) the same as 0 for integer (B) the same as blank for character (C) the same as 0 for integer and blank for character (D) not a value

MCQ 5 The natural join is equal to

(A) Cartesian Product (B) Combination of Union and Cartesian product (C) Combination of selection and Cartesian product (D) Combination of projection and Cartesian product

MCQ 6 In E-R Diagram relationship type is represented by

(A) Ellipse (B) Dashed ellipse (C) Rectangle (D) Diamond

MCQ 7 _________________ is a virtual table that draws its data from the result of an SQL SELECT statement.

(A) View (B) Synonym (C) Sequence (D) Transaction

MCQ 8 What is a candidate key?

(A) Alias for primary key (B) Used to identify a column (C) Used to uniquely identify a row (D) Alias for foreign key

MCQ 9 ________________ function divides one numeric expression by another and returns the remainder.

(A) POWER (B) MOD (C) ROUND (D) REMAINDER

MCQ 10 Which of these commands will delete a table called AAAA if you have appropriate authority.

(A) DROP AAAA (B) DELETE AAAA WHERE confirm = 'Yes' (C) DROP AAAA WHERE confirm = 'Yes' (D) DROP TABLE AAAA

MCQ 11 The language which has recently become the defacto standard for interfacing application programs with relational database system is

(A) Oracle (B) SQL (C) Dbase (D) 4GL

MCQ 12 Architecture of the database can be viewed as

(A) two levels (B) four levels (C) three levels (D) one level

MCQ 13 in sql query, "AS" clause is used for

(A) Selection operation (B) Rename operation (C) Join operation (D) Projection operation

MCQ 14 The language used in application programs to request data from the DBMS is referred to as the

(A) DML (Data Manipulation Language) (B) DDL (Data Definition Language) (C) DCL (Data Control Language) (D) SDL (Structured definition Language)

MCQ 15 The situation where the lock waits only for a specified amount of time for another lock to be released is

(A) Lock timeout (B) Wait-wound (C) Timeout (D) Wait

MCQ 16 A relational database developer refers to a record as

(A) criteria (B) a relation (C) a tuple (D) an attribute

MCQ 17 Count function in SQL returns the number of

(A) values (B) distinct values (C) groups (D) columns

MCQ 18 The way a particular application views the data from the database that the application uses is a

(A) module (B) relational model (C) schema (D) subschema

MCQ 19 What are the ways of dealing with deadlock?

(A) Deadlock prevention (B) Deadlock recovery (C) Deadlock detection (D) All of the mentioned

MCQ 20 The database environment has all of the following components except:

(A) users (B) separate files (C) database (D) database administrator

MCQ 21 What is a relationship called when it is maintained between two entities?

(A) Unary (B) Binary (C) Ternary (D) Quaternary

MCQ 22 Which of the following is a legal expression in SQL?

(A) SELECT NULL FROM EMPLOYEE; (B) SELECT NAME FROM EMPLOYEE; (C) SELECT NAME FROM EMPLOYEE WHERE SALARY = NULL; (D) None of the above

MCQ 23 Which of the following is a record based logical model?

(A) Network Model (B) Object-oriented model (C) E-R Model (D) None of the these

MCQ 24 A data dictionary is a special file that contains:

(A) The name of all fields in all files (B) The width of all fields in all files (C) The data type of all fields in all files (D) All of the above

MCQ 25 Cross Product is a

(A) Unary Operator (B) Ternary Operator (C) Binary Operator (D) Not an operator