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

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

MCQ 2 Which of the following can be an example of a database?

(A) Address book of all the suppliers of a company (B) Salary sheet of all the employees of a company (C) Records of daily sales transactions of a company (D) All of the above

MCQ 3 The expression builder is an access tool that controls an expression ______________ for entering an expression.

(A) Table (B) Box (C) Cell (D) Palette

MCQ 4 Which of the following is NOT a type of Microsoft Access database object?

(A) Table (B) Form (C) Worksheets (D) Modules

MCQ 5 A _____________ name must be unique within a database.

(A) Table (B) Field (C) Record (D) Character

MCQ 6 This option allows you to build a new table by entering data directly into the datasheet.

(A) datasheet view (B) design view (C) link table (D) None of the above

MCQ 7 Which of the given is not a database model.

(A) Network database model (B) Relational database model (C) Object Oriented database model (D) None of the above

MCQ 8 The ___________ button on the tool box display data from a related table.

(A) Sub form sub report (B) Relationships (C) Select objects (D) More controls

MCQ 9 Which of the following database object produces the final result to present?

(A) Forms (B) Reports (C) Queries (D) Tables

MCQ 10 It is an association established between common fields of two tables.

(A) line (B) relationship (C) primary key (D) records

MCQ 11 When entering field name, how many characters you can type in maximum?

(A) 60 (B) 64 (C) 68 (D) Any number of character

MCQ 12 What are the columns in a Microsoft Access table called?

(A) Rows (B) Records (C) Fields (D) Columns

MCQ 13 Which of the following creates a drop down list of values to choose from a list?

(A) OLE Object (B) Hyperlink (C) Memo (D) Lookup Wizard

MCQ 14 The key uniquely identifies each record in a table.

(A) Primary key (B) Key word (C) Filed name (D) All of the above

MCQ 15 A part of database that stores only one type of data is

(A) Report (B) Field (C) Query (D) Record

MCQ 16 Which of the following store command to retrieve data from database?

(A) Forms (B) Reports (C) Queries (D) Tables

MCQ 17 Each record is constituted by a number of individual data items which are called

(A) Fields (B) Data Types (C) Relations (D) Tables

MCQ 18 An MS Access database object that is used to enter, view or edit records

(A) Table (B) Form (C) Query (D) Report

MCQ 19 If I create 'Student' field in 'Fees' table to store 'student_id' of 'Students' table, then this 'Student' field in 'Fees' table is called

(A) Foreign key (B) Native key (C) Composite key (D) Primary key

MCQ 20 A primary key in any table has the properties

(A) Not Null (B) No Duplicates (C) Both of above (D) None of above

MCQ 21 Which of the following is not a logical database structure?

(A) Chain (B) Network (C) Tree (D) Relational

MCQ 22 What determines a table’s sort order?

(A) AutoNumber field (B) Index field (C) Field order (D) Primary key

MCQ 23 Which is the valid data type in Access?

(A) Number (B) Text (C) Currency (D) All of the above

MCQ 24 Which criteria return only those addresses beginning with the letter "A"?

(A) address = "A" (B) address = "A*" (C) address = "A?" (D) address = "A#"

MCQ 25 Which criteria do not return the position "Officer" as a match?

(A) position = "*ff*" (B) position = "O??icer" (C) position = "?ff*" (D) position = "O#r"