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

Exam 1: Database Management System DBMS: Part A

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

(Multiple Choice)

4.7/5

(36)

Question 21

The following are components of a database except ________ .

(Multiple Choice)

4.9/5

(45)

Question 22

Every relation in BCNF is also in

(Multiple Choice)

4.8/5

(42)

Question 23

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

(Multiple Choice)

4.9/5

(37)

Question 24

How many inference rules are there for functional dependencies?

(Multiple Choice)

4.9/5

(33)

Question 25

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

(Multiple Choice)

4.9/5

(39)

Question 26

The DML provides following functional access to the database:

(Multiple Choice)

4.8/5

(33)

Question 27

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

(Multiple Choice)

4.9/5

(39)

Question 28

Which of the following is element of the database?

(Multiple Choice)

4.8/5

(32)

Question 29

The set of permitted value for each attribute is called its

(Multiple Choice)

4.7/5

(31)

Question 30

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

(Multiple Choice)

4.9/5

(33)

Question 31

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

(Multiple Choice)

4.9/5

(38)

Question 32

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

(Multiple Choice)

4.8/5

(43)

Question 33

The following are functions of a DBMS except ________ .

(Multiple Choice)

4.8/5

(44)

Question 34

In a database system there is:

(Multiple Choice)

4.7/5

(31)

Question 35

The granularity of a database item can be chosen to be

(Multiple Choice)

4.8/5

(41)

Question 36

Data is:

(Multiple Choice)

4.9/5

(39)

Question 37

Which of the following is related to information?

(Multiple Choice)

4.9/5

(34)

Question 38

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:

(Multiple Choice)

4.8/5

(33)

Question 39

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

(Multiple Choice)

4.8/5

(31)

Question 40

Showing 21 - 40 of 42

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

The following are components of a database except ________ .

Every relation in BCNF is also in

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

How many inference rules are there for functional dependencies?

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

The DML provides following functional access to the database:

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

Which of the following is element of the database?

The set of permitted value for each attribute is called its

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

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

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

The following are functions of a DBMS except ________ .

In a database system there is:

The granularity of a database item can be chosen to be

Data is:

Which of the following is related to information?

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:

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

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