Database - Programming Language (MCQ) questions

1)   In the table given below T1, T2 and T3 are the transactions.The correct serialization of the below schedules is
- Published on 19 Oct 15

computer-science-33.png
a. T2 -> T3 -> T1
b. T3 -> T2 -> T1
c. T1 -> T2 -> T3
d. T1 -> T3 -> T2
Answer  Explanation 

ANSWER: T1 -> T3 -> T2

Explanation:
No explanation is available for this question!


2)   Which of the following is an Open Source DBMS?
- Published on 19 Oct 15

a. MySQL
b. Microsoft SQL Server
c. Microsoft Access
d. Oracle
Answer  Explanation 

ANSWER: MySQL

Explanation:
No explanation is available for this question!


3)   When a primary key is define in the table, DBMS automatically creates a ____ on a primary key column.
- Published on 19 Oct 15

a. Unique index
b. Sequence
c. Trigger
d. Synonym
Answer  Explanation 

ANSWER: Unique index

Explanation:
No explanation is available for this question!


4)   Match the following

A) Composite attribute ------ i) Attribute whose value is calculated from other attributes
B) Multivalued Attribute ---- ii) Attribute that can be further subdivided to yield additional attributes
C) Derived Attribute -------- iii) Attribute that can have more values

- Published on 19 Oct 15

a. A-i, B-ii, C-iii
b. A-ii, B-i, C-iii
c. A-ii, B-iii, C-i
d. A-iii, B-ii, C-i
Answer  Explanation 

ANSWER: A-ii, B-iii, C-i

Explanation:
No explanation is available for this question!


5)   Which normal form is the partial dependency removed?
- Published on 19 Oct 15

a. First
b. Second
c. Third
d. BCNF
Answer  Explanation 

ANSWER: Second

Explanation:
No explanation is available for this question!


6)   What is the responsibility of the buffer manager?

- Published on 19 Oct 15

a. Fetching data from disk storage into main memory, and deciding what data to cache in main memory.
b. Allocation of space on disk storage and the data structures used to represent information stored on disk.
c. Storing details such as how many users, which user has which permissions etc.
d. None of the above
Answer  Explanation 

ANSWER: Fetching data from disk storage into main memory, and deciding what data to cache in main memory.

Explanation:
No explanation is available for this question!


7)   The problem caused by independent multivalued dependencies is eliminated in which of the normal form?
- Published on 19 Oct 15

a. 3NF
b. BCNF
c. 4NF
d. 5NF
Answer  Explanation 

ANSWER: 4NF

Explanation:
No explanation is available for this question!


8)   Which is not the relational algebra operator?
- Published on 19 Oct 15

a. Set difference
b. Cartesian product
c. Rename
d. Join
Answer  Explanation 

ANSWER: Set difference

Explanation:
No explanation is available for this question!


9)   An attribute or combination of attributes in one table whose values must either match the primary key in another table or be null is called __________.

- Published on 19 Oct 15

a. Secondary Key
b. Super key
c. Candidate Key
d. Foreign Key
Answer  Explanation 

ANSWER: Foreign Key

Explanation:
No explanation is available for this question!


10)   A transaction state changes from active to______, after the transaction has been rolled back and the database restored to its state prior to the start of the transaction.
- Published on 19 Oct 15

a. Partially committed
b. Committed
c. Aborted
d. Failed
Answer  Explanation 

ANSWER: Aborted

Explanation:
No explanation is available for this question!


1 2 3 4 5 6 7 8 9 10