MCQ 1 To duplicate a controls formatting you can use ________________.

(A) Manager (B) Wizard (C) Painter (D) Control

MCQ 2 In table design view, what are the first column of buttons used for?

(A) Indicate Primary Key (B) Indicate Current Row (C) Both of above (D) None of above

MCQ 3 Which of the following statement is true?

(A) Foreign key fields don’t allow duplicate values (B) In primary key field you can enter duplicate value (C) In an indexed field you may or may not enter duplicate value depending upon setting (D) All statements are true

MCQ 4 A composite key is

(A) Required when a table does not have any unique fields in it (B) The primary key with AutoNumber as the field type (C) Made up of two or more fields to uniquely identify records (D) Is a foreign key that uniquely identifies records

MCQ 5 Which of the following is not a database application?

(A) dBase (B) Flash (C) FoxPro (D) Access

MCQ 6 The report footer section is most useful for displaying

(A) Grand totals (B) Column headings (C) Subtotals (D) Page numbers

MCQ 7 What term is used to refer to a specific record in your music database; for instance; information stored about a specific album?

(A) Relation (B) Instance (C) Table (D) Column

MCQ 8 The database schema is written in

(A) DML (Data Manipulation Language) (B) DDL (Data Definition Language) (C) DCL (Data Control Language) (D) None of the above

MCQ 9 Transaction processing is associated with everything below except

(A) producing detail, summary, or exception reports (B) recording a business activity (C) confirming an action or triggering a response (D) maintaining data

MCQ 10 The method of access which uses key transformation is known as

(A) direct (B) hash (C) random (D) sequential

MCQ 11 Which of the following is an advantage of view?

(A) Data security (B) Derived columns (C) Hiding of complex queries (D) All of the above

MCQ 12 Which of the operations constitute a basic set of operations for manipulating relational data?

(A) Predicate calculus (B) Relational calculus (C) Relational algebra (D) None of the above

MCQ 13 A primary key is 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 14 A data manipulation command the combines the records from one or more tables is called

(A) SELECT (B) PROJECT (C) JOIN (D) PRODUCT

MCQ 15 In E-R diagram generalisation is represented by

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

MCQ 16 Which of the following is not Constraint in SQL?

(A) Primary Key (B) Not Null (C) Check (D) Union

MCQ 17 Which of the following is a sql AGGREGATE Function

(A) LEFT (B) AVG (C) JOIN (D) LEN

MCQ 18 The COUNT function in SQL returns the number of ______________.

(A) Values (B) Distinct values (C) Columns (D) Group by

MCQ 19 What is the full form of sql?

(A) Simple Query Language (B) Structured Query Language (C) Structured Query List (D) None of these

MCQ 20 A table joined with itself is called

(A) Join (B) Self Join (C) Outer Join (D) Equi Join

MCQ 21 SET concept is used in

(A) Network Model (B) Hierarchical Model (C) Relational Model (D) None of the these

MCQ 22 ___________ produces the relation that has attributes of R1 and R2

(A) Cartesian product (B) Difference (C) Intersection (D) Product

MCQ 23 Cartesian product in relational algebra is

(A) A Unary operator (B) A Binary operator (C) A Ternary operator (D) Not defined

MCQ 24 The subset of a super key is a candidate key under what condition?

(A) No proper subset is a super key (B) All subsets are super keys (C) Subset is a super key (D) Each subset is a super key

MCQ 25 The entity relationship set is represented in E-R diagram as

(A) Double diamonds (B) Undivided rectangles (C) Dashed lines (D) Diamond