MCQ 1 Database Management Systems are featured with

(A) The facility to easy editing, spelling check, auto pagination, lay out and printing reports (B) The ability to store large amount of data to facilitate easy update, sort and retrieval (C) The ability to calculate efficiently with the help of built-in functions and analyze (D) All of the above

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

(A) Data presented in table in Microsoft Word Document (B) Data entered in Microsoft Excel Spreadsheet (C) A presentation created in Microsoft Power Point (D) A Telephone Diary

MCQ 3 What do you call a collection of records matching parameters of a query?

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

MCQ 4 Which query do you use to answer the question "What is the average salary of the employees"?

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

MCQ 5 A ________________ consists of a sequence of query and/or update statements.

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

MCQ 6 _______________ rollback requires the system to maintain additional information about the state of all the running transactions.

(A) Total (B) Partial (C) Time (D) Commit

MCQ 7 What does Rollback do?

(A) Undoes the transactions (B) Clears all transactions (C) Redoes the transactions before commit (D) No action

MCQ 8 A database object in MS Access that stores a question about the data in database?

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

MCQ 9 If you need to edit a relationship, you can do.

(A) Right click the relationship line and choose Edit Relationship (B) Double click the relationship line (C) Both of above (D) None of above

MCQ 10 In an E-R diagram an entity set is represent by a

(A) rectangle (B) ellipse (C) diamond box (D) circle

MCQ 11 The relational model feature is that there

(A) is no need for primary key data. (B) is much more data independence than some other database models. (C) are explicit relationships among records. (D) are tables with many dimensions.

MCQ 12 Which of the following is correct.

(A) A SQL query automatically eliminates duplicates. (B) A SQL permits attribute names to be repeated in the same relation. (C) A SQL query will not work if there are no indexes on the relations (D) None of the these

MCQ 13 Which of the following is a valid SQL type?

(A) CHARACTER (B) NUMERIC (C) FLOAT (D) All of the above

MCQ 14 Which of the following operations need the participating relations to be union compatible?

(A) UNION (B) INTERSECTION (C) DIFFERENCE (D) All of the above

MCQ 15 It is better to use files than a DBMS when there are

(A) Stringent real-time requirements. (B) Multiple users wish to access the data. (C) Complex relationships among data. (D) All of the above

MCQ 16 Which of the following operation is used if we are interested in only certain columns of a table?

(A) PROJECTION (B) SELECTION (C) UNION (D) JOIN

MCQ 17 The conceptual model is

(A) dependent on hardware (B) dependent on software (C) dependent on both hardware and software (D) independent of both hardware and software

MCQ 18 Which one of the following statements is false?

(A) The data dictionary is normally maintained by the database administrator. (B) Data elements in the database can be modified by changing the data dictionary. (C) The data dictionary contains the name and description of each data element. (D) A data dictionary is a tool used exclusively by the database administrator.

MCQ 19 In the architecture of a database system external level is the

(A) physical level (B) logical level (C) conceptual level (D) view level

MCQ 20 In an E-R diagram attributes are represented by

(A) rectangle (B) square (C) ellipse (D) triangle

MCQ 21 Related fields in a database are grouped to form a

(A) data file (B) data record (C) menu (D) bank

MCQ 22 An entity set that does not have sufficient attributes to form a primary key is a

(A) strong entity set (B) weak entity set (C) simple entity set (D) primary entity set

MCQ 23 The deadlock state can be changed back to stable state by using _______________ statement.

(A) Commit (B) Rollback (C) Savepoint (D) Deadlock

MCQ 24 The Rectangles divided into two parts represents

(A) Entity set (B) Relationship set (C) Attributes of a relationship set (D) Primary 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