MCQ 1 Which of the following is not a type of relationship that can be applied in access database.

(A) One to One Relationship (B) One to Many Relationship (C) Many to Many Relationship (D) All of the above can be applied

MCQ 2 How to achieve AND effect when you are entering criteria in a query design window.

(A) Write criteria values vertically one in a row (B) Write criteria values horizontally (C) Write criteria values in same field separated with AND (D) Write criteria values in same field separated with OR

MCQ 3 How to create a relationship between two tables in database.

(A) Drag the primary key of a table into foreign key of another table (B) Drag the foreign key of a table into the primary key of another table (C) Drag any field from parent table and drop on child table (D) Any of above can be done to create relationship

MCQ 4 The task of arranging data in order is called

(A) Searching (B) Sorting (C) Ordering (D) Shorting

MCQ 5 Validation Rule in a field will

(A) Checks the value entered when user leaves the field (B) Displays the value in specified format when user leaves the field (C) Defines the appearance for the text (D) There is no option of Validation Rule

MCQ 6 For a weak entity set to be meaningful, it must be associated with another entity set, called the?

(A) Identifying set (B) Owner set (C) Neighbour set (D) Strong entity set

MCQ 7 Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?

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

MCQ 8 Which of the following makes the transaction permanent in the database?

(A) View (B) Commit (C) Rollback (D) Flashback

MCQ 9 A deadlock exists in the system if and only if the wait-for graph contains a ___________

(A) Cycle (B) Direction (C) Bi-direction (D) Rotation

MCQ 10 Selecting the victim to be rollbacked to the previous state is determined by the minimum cost. The factors determining cost of rollback is

(A) How long the transaction has computed, and how much longer the transaction will compute before it completes its designated task (B) How many data items the transaction has used (C) How many more data items the transaction needs for it to complete (D) How many more data items the transaction needs for it to complete

MCQ 11 Which one of the following attribute can be taken as a primary key?

(A) Name (B) Street (C) Id (D) Department

MCQ 12 You have field Gender of type Byte Number. How to limit its value to 0 and 1 only?

(A) By setting required to 'Yes' (B) By using default value (C) By defining validation rule (D) By using format

MCQ 13 In table design view, which key can be used to switch between the field names and properties panels?

(A) F3 (B) F4 (C) F5 (D) F6

MCQ 14 Microsoft Access is an

(A) Relational Database Management System (RDBMS) (B) Object-Oriented Database Management System (OODBMS) (C) Object Oriented Relational Database Management System (ORDBMS) (D) Network Database Model

MCQ 15 DCL (Data Control Language) provides commands to perform actions like.

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

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

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

MCQ 17 Which object is used to create a form?

(A) Tables and Queries (B) Tables only (C) Tables and reports (D) Queries and reports

MCQ 18 Which tool do you use to create a query object?

(A) Database wizard (B) Simple filter wizard (C) Simple query wizard (D) Table query wizard

MCQ 19 How to make a date field DOB store the dates format like "2002/10/17".

(A) By setting the input mask property to "yyyy/mm/dd" (B) By setting the format property to "yyyy/mm/dd" (C) By entering dates in yyyy, mm, dd order (D) None of the above

MCQ 20 Which control types is most often associated with a bound control?

(A) Command button (B) Label (C) Text box (D) List box

MCQ 21 A database language concerned with the definition of the whole database structure and schema is ___________.

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

MCQ 22 HSAM stands for ___________.

(A) Hierarchic Sequential Access Method (B) Hierarchic Standard Access Method (C) Hierarchic Sequential and Method (D) Hierarchic Standard and Method

MCQ 23 Which of the following is the DBMS type

(A) Flat File System (B) Hierarchical DBMS (C) Relational DMBS (D) All of the Above

MCQ 24 Relationship can be establish between two tables by

(A) Drag Primary key of a table into Foreign key of another table (B) Drag Foreign key of a table into Primary key of another table (C) Drag any key of a table into any key of another table (D) All of the above

MCQ 25 If you were collecting and storing information about your music collection, an album would be considered a(n) _______________.

(A) Relation (B) Entity (C) Instance (D) Attribute