Database - Programming Language (MCQ) questions
Dear Readers, Welcome to Database multiple choice questions and answers with
explanation. These objective type Database questions are very important for campus placement test and job interviews.
Specially developed for the Database freshers and professionals, these model questions are asked in the online technical test and interview of many IT companies.
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
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!
|
|
