MCQ 1 Consider attributes ID, CITY and NAME. Which one of this can be considered as a super key?

(A) NAME (B) ID (C) CITY (D) CITY, ID

MCQ 2 The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called _____________.

(A) Referential relation (B) Referencing relation (C) Referenced relation (D) Referred relation

MCQ 3 In order to undo the work of transaction after last commit which one should be used?

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

MCQ 4 Transaction processing is associated with everything below except

(A) Conforming an action or triggering a response (B) Producing detail summary or exception report (C) Recording a business activity (D) Maintaining a data

MCQ 5 Which of the following is used to get back all the transactions back after rollback?

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

MCQ 6 In case of entity integrity, the primary key maybe

(A) Not Null (B) Null (C) Both Null & Not Null. (D) Any value

MCQ 7 In case of any shut down during transaction before commit which of the following statement is done automatically?

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

MCQ 8 The deadlock in a set of a transaction can be determined by

(A) Read-only graph (B) Wait graph (C) Wait-for graph (D) All of the mentioned

MCQ 9 An entity set that does not have sufficient attributes to form a primary key is termed a _____________.

(A) Strong entity set (B) Variant set (C) Weak entity set (D) Variable set

MCQ 10 After right click the field selector button, which do you choose to delete a field in design view?

(A) Delete field (B) Delete rows (C) Remove field (D) Remove rows

MCQ 11 How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data

(A) Query Wizard (B) Look up Wizard (C) Look up Wizard (D) Report Wizard

MCQ 12 Which is not a view to display a table in Access?

(A) Datasheet View (B) Design View (C) Pivot Table & Pivot Chart View (D) None of above

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

(A) Change the structure of tables (B) Insert, Update or Delete records and data values (C) Authorizing access and other control over database (D) None of above

MCQ 14 What do you mean by one to many relationship between Student and Class table?

(A) One student can have many classes (B) One class may have many student (C) Many classes may have many students (D) Many students may have many classes

MCQ 15 An organized collection of logically related data is known as

(A) Data (B) Meta data (C) Database (D) Information

MCQ 16 Which of the following is invalid field name?

(A) Student.Address (B) Student'sAddress (C) Student_Address (D) Student Address

MCQ 17 A system is in a ___________________ state if there exists a set of transactions such that every transaction in the set is waiting for another transaction in the set.

(A) Idle (B) Waiting (C) Deadlock (D) Ready

MCQ 18 Relational calculus is a

(A) Procedural language. (B) Non- Procedural language. (C) Data definition language. (D) High-level language.

MCQ 19 DML is provided for

(A) Description of the logical structure of a database (B) The addition of new structures in the database system (C) Manipulation & processing of the database (D) Definition of a physical structure of the database system

MCQ 20 Which one of the following cannot be taken as a primary key?

(A) Id (B) Register number (C) Dept_id (D) Street

MCQ 21 The DBMS language component which can be embedded in a program is

(A) The data definition language (DDL) (B) The data manipulation language (DML) (C) The database administrator (DBA) (D) A query language

MCQ 22 The method in which records are physically stored in a specified order according to a key field in each record is

(A) hash (B) direct (C) sequential (D) All of the above

MCQ 23 An advantage of the database management approach is

(A) data is dependent on programs. (B) data redundancy increases. (C) data is integrated and can be accessed by multiple programs. (D) None of the above

MCQ 24 Which leads you through the process of creating a table?

(A) Wizard (B) Assistant (C) Relation (D) Coach

MCQ 25 In a datasheet, what does each column represent?

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