MCQ 1 Which of the following gives a logical structure of the database graphically?

(A) Entity-relationship diagram (B) Entity diagram (C) Database diagram (D) Architectural representation

MCQ 2 Query can be use to select data from

(A) Single Table (B) Multiple Tables (C) Both A and B (D) None of the these

MCQ 3 Which tool is used to generate printout of a table's structure?

(A) Analyzer (B) Designer (C) Documenter (D) Generator

MCQ 4 Which do you click to display the table’s primary key and indexes in a separate window?

(A) indexes button (B) primary key button (C) view datasheet button (D) view design button

MCQ 5 Which query do you use for "Which employees earn more than Rs.5000 a month"?

(A) Search query (B) Cross tab query (C) Select query (D) Update query

MCQ 6 What is the result of the query "Select * from customer where c_id>10 and c_id<100".

(A) Display all customers with c_id from 10 to 100 (B) Display all customers with c_id above 10 (C) Display all customers with c_id below 100 (D) Display all customers with c_id from 11 to 99

MCQ 7 After creating the table which of the following is correct?

(A) Fields cannot be added (B) Fields cannot be deleted (C) Fields can added but only once (D) Fields can added and deleted as needed

MCQ 8 Primary key is

(A) Uniquely identifies each record (B) Cannot be repeated (C) AutoNumber is example of Primary key (D) All of the above

MCQ 9 The basic elements of a form or a report are called

(A) Controls (B) Objects (C) Windows (D) Properties

MCQ 10 In a table to insert User's Voice, Data field should be

(A) OLE Object (B) SoundField (C) VoiceField (D) Memo

MCQ 11 We indicate roles in E-R diagrams by labeling the lines that connect ________________ to ______________.

(A) diamond , diamond (B) rectangle, diamond (C) rectangle, rectangle (D) diamond, rectangle

MCQ 12 You can automatically include all of the field in a table in a query by ______________ a strike that appear list box in query design view.

(A) Clicking (B) Right clicking (C) Double clicking (D) None of the above

MCQ 13 What does the show check box in query design window indicate?

(A) It indicates whether the field is to be used or not (B) It indicates whether the field is to be displayed in query result or not (C) It indicates whether the field names to be displayed in query result or not (D) None of above

MCQ 14 Which of the following database object hold data?

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

MCQ 15 A __________ enables you to view data from a table based on a specific criterion.

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

MCQ 16 It is a sign or symbol that specifies, operator, and values that produce a result is an __________________.

(A) operator (B) query (C) expression (D) varaible

MCQ 17 What is the maximum length a text field can be?

(A) 120 (B) 255 (C) 265 (D) 75

MCQ 18 If you write criteria values vertically (one in a row) it will mean.

(A) OR conditions (B) AND conditions (C) NOT condition (D) None of above

MCQ 19 Every table in relational database contain a field or combination of fields that can uniquely identify each records, it is called.

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

MCQ 20 How many relations may exist between tables in databases?

(A) 4 (B) 3 (C) 2 (D) 1

MCQ 21 Which is not a view for displaying a report object?

(A) Datasheet view (B) Design view (C) Print preview (D) Layout preview

MCQ 22 What is an intersection of a row and a column?

(A) Form (B) Cursor (C) Cell (D) Record

MCQ 23 Collection of related records in a database is known as

(A) File (B) Bench (C) Table (D) Relationship

MCQ 24 A database can be best described as

(A) Organized collection of data (B) Useful presentation of data (C) Graphical representation of data (D) All of the above

MCQ 25 Which of the following may not be a database?

(A) Attributes (B) Tuples (C) Relationship (D) Columns