Deck 1: Database Management System DBMS: Part A

Question 1

Given the functional dependencies X ?W; X?Y; Y?Z and Z?PQ Which of the following doesn't hold well?

A)X?Z
B)W?Z
C)X?WY
D)None of the above

Answer 1

W?Z

Question 2

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

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

Answer 2

Foreign key

Question 3

A primary key when combined with a foreign key create

A)Parent child relationship between the tables that connect them.
B)Network model between the tables that connect them.
C)Many-to-many relationship between the tables that connect them.
D)None of the above.

Answer 3

Parent child relationship between the tables that connect them.

Question 4

The set of permitted value for each attribute is called its

A)Attribute set
B)Attentive range
C)Domain
D)Group

Question 5

The airline reservation system, the enables are date, flight number, place of departure, destination, type of plane & seats available. The primary key is

A)Flight number
B)Flight number + place of departure
C)Flight number+ date
D)Flight number + destination

Question 6

A functional dependency of the form X?Y is trivial if

A)YC= X
B)Y C X
C)X C =Y
D)X C Y and Y C X

Question 7

In transactions, in ACID property A stands for

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

Question 8

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

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

Question 9

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

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 10

In two-phase locking protocol.

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 11

Transaction timestamp is:

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

Question 12

The granularity of a database item can be chosen to be

A)A whole file
B)A database record
C)The whole database
D)All of the above.

Question 13

If the complete execution of the transaction(s) takes the database from one consistent state to the other then that property of transaction is called:

A)Isolation
B)Durability
C)Consistency preservation
D)None of the above

Question 14

Which of the following is not the state that the transaction undergoes?

A)Failed
B)Active
C)Partially committed
D)Non active

Question 15

Timestamp can be generated by:

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

Question 16

Which of the following is the formal process for deciding which attributes should be grouped together in a relation?

A)Normalization
B)Performance Tuning
C)Optimization
D)None of the above

Question 17

Who developed normalization process?

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

Question 18

Who developed the BCNF?

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

Question 19

What is the expansion of BCNF?

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

Question 20

Which of the following is true?

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 21

How many inference rules are there for functional dependencies?

A)4
B)5In t
C)6
D)7

Question 22

Which property ensures that each functional dependency is represented in some individual relations resulting after decomposition?

A)Dependency preservation property
B)Fully Functional dependency
C)Lossless Join
D)None of the above

Question 23

Every relation in BCNF is also in

A)3NF
B)2NF
C)1NF
D)None of the above

Question 24

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

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

Question 25

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

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

Question 26

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

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

Question 27

The following are components of a database except ________ .

A)user data
B)Metadata
C)Reports
D)Indexes

Question 28

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

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

Question 29

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

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

Question 30

The following are functions of a DBMS except ________ .

A)creating and processing forms
B)creating databases
C)processing data
D)administrating databases

Question 31

Helping people keep track of things is the purpose of a(n) ________ .

A)Database
B)Table
C)Instance
D)Relationship

Question 32

A DBMS that combines a DBMS and an application generator is ________ .

A)Microsoft's SQL Server
B)Microsoft's Access
C)IBM's DB2
D)Oracle Corporation's Oracle

Question 33

Which of the following is related to information?

A)Data
B)Communication
C)Knowledge
D)All of these.

Question 34

Data is:

A)A piece of fact
B)Metadata
C)Information
D)None of these.

Question 35

Which of the following is element of the database?

A)Data
B)Constraints and schema
C)Relationships
D)All of these.

Question 36

What represent a correspondence between the various data elements?

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

Question 37

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

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

Question 38

In a file-oriented system there is:

A)Data inconsistency
B)Duplication of data
C)Data independence
D)Al of these.

Question 39

In a database system there is:

A)Increased productivity
B)Improved security
C)Economy of scale
D)All of these.

Question 40

VDL is used to specify:

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

Question 41

The DML provides following functional access to the database:

A)Retrieve data and/or records
B)Add (or insert) records
C)Delete records from database files
D)All of these

Question 42

4GL has the following components inbuilt in it:

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