MCQ 1 Which of the field has width 8 bytes?

(A) Memo (B) Number (C) Date/Time (D) Hyperlink

MCQ 2 What is the size of Yes, No field?

(A) 1 bit (B) 1 byte (C) 1 character (D) 1 GB

MCQ 3 Which key is uniquely identifies each record?

(A) Primary Key (B) Secondary Key (C) Unique Key (D) Candicate Key

MCQ 4 When you create or open the MS Access database file, command center of access file that appears

(A) Database Window (B) Query Window (C) Design View Window (D) Switchboard

MCQ 5 If your entering all fields required for a table, if you realize that the third field is not needed, how will you remove?

(A) You need to delete the whole table, there is no method to remove a particular field only. (B) Delete all the fields from third downwards and reenter the required fields again. (C) Select the third column in datasheet view then Delete it. (D) Select the third row in table design view then Delete it.

MCQ 6 Which field type will you select when creating a new table if you require to enter long text in that field?

(A) Text (B) Memo (C) Currency (D) Hyperlink

MCQ 7 To create queries in Access, what steps you do.

(A) You can drag and drop fields on query builders (B) you can type the SQL command in SQL view (C) You can use query wizard or design view (D) All of the above

MCQ 8 What is a form in MS Access?

(A) It is a printed page where users will write their data to fill it up (B) It is an input screen designed to make the viewing and entering data easier (C) This is an important part of database used by analysts to draw conclusions (D) All of the above

MCQ 9 It is a database object to view, change, and analyze data in different ways.

(A) query (B) form (C) report (D) relationship

MCQ 10 Both conditions display on the same row in the design grid when _________________ operator is in use.

(A) OR (B) IN (C) AND (D) LIKE

MCQ 11 Which of the following is not a field type in Access?

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

MCQ 12 A search value can be an exact value or it can be.

(A) Logical operator (B) Relationship (C) Wild card character (D) Comparison operation

MCQ 13 Which of the following is not a database object in MS Access?

(A) Tables (B) Query (C) Report (D) Relationship

MCQ 14 Which of the following expresses correct order?

(A) Characters, Fields, Records, Tables, Files, Databases (B) Characters, Fields, Records, Tables, Database, Files (C) Databases, Tables, Files, Records, Field, Character (D) Files, Databases, Tables, Records, Fields, Characters

MCQ 15 The complete information about an entity in a database is called

(A) Data (B) Information (C) Field (D) Record

MCQ 16 In a datasheet, what does each row represent?

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

MCQ 17 In databases, Locking level is also called as

(A) Granularity (B) S lock (C) X lock (D) Dead lock

MCQ 18 To create primary key for a table when in design view

(A) Type PRIMARY in field type box when creating required field (B) Mark the Primary check box in field name of required field (C) Click the Primary Key button in Design ribbon when the cursor is in required field (D) None of the above

MCQ 19 What is the full form of SQL?

(A) Sophisticated Question List (B) Structured Question List (C) Structured Query Language (D) Small Query Length

MCQ 20 Which of the following is not a view for interacting with a form object?

(A) Datasheet view (B) Design view (C) Form view (D) Layout view

MCQ 21 A ____________ is a unit of information in a _____________.

(A) record, field (B) field, record (C) data source, field (D) record, data source

MCQ 22 Which type of field is incremented automatically?

(A) Auto Elevate (B) AutoNumber (C) Auto Increment (D) Auto Value

MCQ 23 Which data type is better to use for storing phone number in the following format - 111-2-1234567?

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

MCQ 24 What is the purpose of indexing?

(A) To reduce table size (B) To speedup data search (C) Both A and B (D) None of the above

MCQ 25 What do you call a primary key field included in another table?

(A) Foreign key (B) Parent key (C) Child key (D) Index