Question 1

Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?

Accepted Answer

A) IDMS 
B) DB2 
C) dBase-II 
D) R:base 
A) IDMS 
B) DB2 
C) dBase-II 
D) R:base B

Question 2

Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.

Accepted Answer

A) It will result in a deadlock situation. 
B) It will immediately be granted. 
C) It will immediately be reject 
A) It will result in a deadlock situation. 
B) It will immediately be granted. 
C) It will immediately be reject B

Question 3

Who developed the BCNF?

Accepted Answer

A) Boyd and Cromwell 
B) Date and Codd 
C) Date and White 
D) Boyce and Codd 
A) Boyd and Cromwell 
B) Date and Codd 
C) Date and White 
D) Boyce and Codd D

Question 4

Which of the following is characteristic of the data in a database?

Accepted Answer

A) Independent 
B) Secure 
C) Shared 
D) All of these. 
A) Independent 
B) Secure 
C) Shared 
D) All of these.

Question 5

Transaction timestamp is:

Accepted Answer

A) Not unique for each transaction 
B) Larger for older transaction 
C) Unique identifier assigned to each transaction. 
D) None of the above. 
A) Not unique for each transaction 
B) Larger for older transaction 
C) Unique identifier assigned to each transaction. 
D) None of the above.

Question 6

A table that contains one or more repeating groups is in which normal form?

Accepted Answer

A) 1NF 
B) 2NF 
C) 3NF 
D) Unnormalized Form 
A) 1NF 
B) 2NF 
C) 3NF 
D) Unnormalized Form

Question 7

The DBMS acts as an interface between what two components of an enterprise-class database system?

Accepted Answer

A) Database application and the database 
B) Data and the database 
C) The user and the database application 
D) Database application and SQL 
A) Database application and the database 
B) Data and the database 
C) The user and the database application 
D) Database application and SQL

Question 8

What is the expansion of BCNF?

Accepted Answer

A) Boyd-Cromwell Normal Form 
B) Boyce-Codd Normal Form 
C) Boyd-Codd Normal Form 
D) All of the above 
A) Boyd-Cromwell Normal Form 
B) Boyce-Codd Normal Form 
C) Boyd-Codd Normal Form 
D) All of the above

Question 9

What represent a correspondence between the various data elements?

Accepted Answer

A) Data 
B) Constraints 
C) Relationships 
D) Schema 
A) Data 
B) Constraints 
C) Relationships 
D) Schema

Question 10

In transactions, in ACID property A stands for

Accepted Answer

A) Atomicity 
B) Acidity 
C) Alphabetically 
D) None of the above. 
A) Atomicity 
B) Acidity 
C) Alphabetically 
D) None of the above.

Question 11

In two-phase locking protocol.

Accepted Answer

A) All unlocking operations precede the first lock operation. 
B) All locking operations precede the first unlock operation. 
C) Locking and unlocking takes place simultaneously. 
D) None of the above. 
A) All unlocking operations precede the first lock operation. 
B) All locking operations precede the first unlock operation. 
C) Locking and unlocking takes place simultaneously. 
D) None of the above.

Question 12

An on-line commercial site such as Amazon.com is an example of a(n) ________ .

Accepted Answer

A) single-user database application 
B) multiuser database application 
C) e-commerce database application 
D) data mining database application 
A) single-user database application 
B) multiuser database application 
C) e-commerce database application 
D) data mining database application

Question 13

Which of the following is true?

Accepted Answer

A) Normalized data is the best representation of data. 
B) Data stored non-redundantly will be accessed faster than data stored many times. 
C) Normalized tables are the best way to store data. 
D) All of the above 
A) Normalized data is the best representation of data. 
B) Data stored non-redundantly will be accessed faster than data stored many times. 
C) Normalized tables are the best way to store data. 
D) All of the above

Question 14

Who developed normalization process?

Accepted Answer

A) C.J. Date 
B) E.F. Codd 
C) Donald Chamberlain 
D) Collin White 
A) C.J. Date 
B) E.F. Codd 
C) Donald Chamberlain 
D) Collin White

Question 15

VDL is used to specify:

Accepted Answer

A) Internal schema 
B) External schema 
C) Conceptual schema 
D) None of these. 
A) Internal schema 
B) External schema 
C) Conceptual schema 
D) None of these.

Question 16

4GL has the following components inbuilt in it:

Accepted Answer

A) Query languages 
B) Report generators 
C) Spreadsheets 
D) All of these. 
A) Query languages 
B) Report generators 
C) Spreadsheets 
D) All of these.

Question 17

A schedule S of n transactions is serializable if it is equivalent to some

Accepted Answer

A) Serial schedule of the same n transactions. 
B) Non-serial schedule of the same n transactions. 
C) Serial schedule of different n transactions. 
D) Non-serial schedule of different n transactions. 
A) Serial schedule of the same n transactions. 
B) Non-serial schedule of the same n transactions. 
C) Serial schedule of different n transactions. 
D) Non-serial schedule of different n transactions.

Question 18

Timestamp can be generated by:

Accepted Answer

A) Counter 
B) Current date/time 
C) None of the above 
D) Both (a) and (b) 
A) Counter 
B) Current date/time 
C) None of the above 
D) Both (a) and (b)

Question 19

Because it contains a description of its own structure, a database is considered to be ________ .

Accepted Answer

A) Described 
B) metadata compatible 
C) self-describing 
D) an application program 
A) Described 
B) metadata compatible 
C) self-describing 
D) an application program

Question 20

An attribute of one table matching the primary key of another table, is called as

Accepted Answer

A) Foreign key 
B) Secondary key 
C) Candidate key 
D) Composite key 
A) Foreign key 
B) Secondary key 
C) Candidate key 
D) Composite key

Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?

Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.

Who developed the BCNF?

Which of the following is characteristic of the data in a database?

Transaction timestamp is:

A table that contains one or more repeating groups is in which normal form?

The DBMS acts as an interface between what two components of an enterprise-class database system?

What is the expansion of BCNF?

What represent a correspondence between the various data elements?

In transactions, in ACID property A stands for

In two-phase locking protocol.

An on-line commercial site such as Amazon.com is an example of a(n) ________ .

Which of the following is true?

Who developed normalization process?

VDL is used to specify:

4GL has the following components inbuilt in it:

A schedule S of n transactions is serializable if it is equivalent to some

Timestamp can be generated by:

Because it contains a description of its own structure, a database is considered to be ________ .

An attribute of one table matching the primary key of another table, is called as

Database Management System DBMS: Part B

Database Management and Data Mining

Database Management System: Relational Model and Operations

Oracle Backup, Distributed Databases, and SQL Commands

Filters

Exam 1: Database Management System DBMS: Part A

Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?

Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.

Who developed the BCNF?

Which of the following is characteristic of the data in a database?

Transaction timestamp is:

A table that contains one or more repeating groups is in which normal form?

The DBMS acts as an interface between what two components of an enterprise-class database system?

What is the expansion of BCNF?

What represent a correspondence between the various data elements?

In transactions, in ACID property A stands for

In two-phase locking protocol.

An on-line commercial site such as Amazon.com is an example of a(n) ________ .

Which of the following is true?

Who developed normalization process?

VDL is used to specify:

4GL has the following components inbuilt in it:

A schedule S of n transactions is serializable if it is equivalent to some

Timestamp can be generated by:

Because it contains a description of its own structure, a database is considered to be ________ .

An attribute of one table matching the primary key of another table, is called as

Database Management System DBMS: Part B

Database Management and Data Mining

Database Management System: Relational Model and Operations

Oracle Backup, Distributed Databases, and SQL Commands

Filters