MCQ 1 In an application created using the database wizard, the main menu is presented as a:

(A) form, called a switchboard (B) report, called a menu (C) table, called a switchboard (D) query, called a menu

MCQ 2 Which data type is better to use for storing the price of an item?

(A) Text (B) AutoNumber (C) Number (D) Currency

MCQ 3 Which of the following is not an aggregate function?

(A) Avg (B) Min (C) Sum (D) With

MCQ 4 Default size of n in a column which is defined as VARCHAR(n)?

(A) 0 (B) 1 (C) 256 (D) None of these

MCQ 5 Difference between a primary key and a unique key?

(A) Primary key cannot be a date variable whereas unique key can be (B) Primary key can take null values but unique key cannot null values (C) You can have only one primary key whereas you can have multiple unique keys (D) None of the above

MCQ 6 Which of the following is true for TRUNCATE in SQL?

(A) It is usually slower than DELETE command (B) There is no comparison between DELETE & TRUNCATE (C) It is usually faster than DELETE command (D) None of these

MCQ 7 All aggregate functions except __________ ignore null values in their input collection.

(A) Sum (B) Count(attribute) (C) Count(*) (D) Avg

MCQ 8 Which of the group functions ignonre null values?

(A) MAX (B) COUNT (C) SUM (D) All of the above

MCQ 9 Which data type can store unstructured data in a column?

(A) CHAR (B) RAW (C) NUMERIC (D) VARCHAR

MCQ 10 The SQL used by front-end application programs to request data from the DBMS is called ______________

(A) DML (B) DDL (C) VDL (D) SDL

MCQ 11 Which SQL statement is used to extract data from a database?

(A) SELECT (B) GET (C) INSERT (D) EXTRACT

MCQ 12 A relational database consists of a collection of

(A) Keys (B) Records (C) Fields (D) Table

MCQ 13 __________ is an Aggregate function in SQL.

(A) SELECT (B) AVG (C) MODIFY (D) CREATE

MCQ 14 ____________ data type can store unstructured data

(A) RAW (B) CHAR (C) NUMERIC (D) VARCHAR

MCQ 15 To delete a particular column in a relation the command used is

(A) UPDATE (B) DROP (C) ALTER (D) DELETE

MCQ 16 A primary key, if combined with a foreign key, creates

(A) Parent-Child relationship between the tables that connect them (B) Many to many relationships between the tables that connect them (C) Network model between the tables that connect them (D) None of the above

MCQ 17 1

(A) (B) (C) Network model between the tables that connect them (D) None of the above

MCQ 18 In E-R Diagram derived attribute is represented by

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

MCQ 19 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 20 A subschema expresses

(A) the logical view (B) the physical view (C) the external view (D) all of the above

MCQ 21 In the relational model, cardinality is termed as:

(A) A number of tuples. (B) A number of attributes. (C) A number of tables. (D) A number of constraints.

MCQ 22 The view of total database content is

(A) Conceptual view (B) Internal view (C) External view (D) Physical View

MCQ 23 An attribute in a relation is a foreign key if the ____________ from one relation is used as an attribute in that relation.

(A) Candidate key (B) Primary key (C) Super key (D) Sub key

MCQ 24 Which database level is closest to the users?

(A) External (B) Internal (C) Physical (D) Conceptual

MCQ 25 Hierarchical model is also called

(A) Tree structure (B) Plex Structure (C) Normalise Structure (D) Table Structure