MCQ of Database Management System (DBMS) – Set 6
This is new Objective Questions with Answer on the Category of DBMS (Database Management System). In this Question set you will get 10 Multiple Choice Questions (MCQ Questions) with Answer related to Database Management System (DBMS). Four options are given to the each question and only one options is the correct one. Select your option and check with given correct answer. Correct answer are given the below of this questions set.
Multiple Choice Questions of Database Management System (DBMS)
6-1. The minimal set of super key is called
A. Primary key
B. Secondary key
C. Candidate key
D. Foreign key
6-2. A relation that has no partial dependencies is in which normal form
A. First
B. Second
C. Third
D. BCNF
6-3. A functional dependency between two or more non-key attributes is called
A. Transitive dependency
B. Partial transitive dependency
C. Functional dependency
D. Partial functional dependency
6-4. A logical description of some portion of database that is required by a user to perform task is called as
A. System View
B. User View
C. Logical View
D. Data View
6-5. ______________ is a classical approach to database design?
A. Left – Right approach
B. Right – Left approach
C. Top – Down approach
D. Bottom – Up approach
6-6. _____________ refers to the correctness and completeness of the data in a database?
A. Data security
B. Data integrity
C. Data constraint
D. Data independence
6-7. A table that displays data redundancies yields ____________ anomalies
A. Insertion
B. Deletion
C. Update
D. All of the above
6-8. A lock that allows concurrent transactions to access different rows of the same table is known as a
A. Field-level lock
B. Row-level lock
C. Table-level lock
D. Database-level lock
6-9. A type of query that is placed within a WHERE or HAVING clause of another query is called
A. Super query
B. Sub query
C. Master query
D. Multi-query
6-10. A transaction completes its execution is said to be
A. Saved
B. Loaded
C. Rolled
D. Committed
Click Here for Answers
Its nice collection
sir it is very helpful for me in my exam
try tro upload these type of question
thank you sir
very nice . Thank You sir
The collection is very good preparatory material for students who wants to write exam
These are nice sets of questions indeed. Thank you and more power!
These are nice sets of questions indeed. Thank you and more power!
I want and needed Java Multiple Choice Questions And Answer . please I am requested you .
great efforts
thanks bro
This helps greatly!!
#satisfied
it is very helpful but sir it is not copy to the ms office
Hi sir, material is good but one thing i need to inform you that 8th question is row-level not field-level. I searched in one more website. if you add some more words to question it is right.
please see the below question
The ____ lock allows concurrent transactions to access the same row as long as they require the use of different fields within that row.
a) Table-level
b) Page-level
c) Row-level
d) Field-level
View Answer
Answer: d
Explanation: Lock is limited to the attributes of the relation.
A lock that allows concurrent transactions to access different rows of the same table is known as a
a) Database-level lock
b) Table-level lock
c) Page-level lock
d) Row-level lock
View Answer
Answer: d
Explanation: Locks are used to maintain database consistency.
Good collection đź‘Ť very helpful McQ
Hi
It is really easy, and nice to navigate
Very impressive