(A) Only A
(B) Only B
(C) Only B and C
(D) Only A and B
Tag: DBMS Mcq
Identify the operation which is NOT one of the parts of the five basic set operations in relational algebra?
(A) Join
(B) Union
(C) Cartesian Product
(D) Set Difference
Consider two sets A and B. A contains 2 elements and B contains 3. How many elements do their cartesian product?
(A) 6
(B) 9
(C) 5
(D) 4
Identify the factor which enforces a relation in 3NF?
(A) Every non-key attribute is fully functionally dependent on primary key
(B) Every non-key attribute is partially dependent on super key
(C) The domain of attribute must include only atomic values
(D) Every non-key attribute is non-transitively dependent on primary key
A candidate key that does not have a null value and is selected to uniquely identify all other attribute values in any given row is called a __.
(A) superkey
(B) candidate key
(C) primary key
(D) secondary key
Which of the following functions are NOT performed by a database administrator?
(A) Planning, designing and implementing database systems
(B) Establishing standards and procedures for database systems
(C) Communicating with database users
(D) Allocation of storage locations and data structures
A description on a particular collection of data using the given data model?
(A) Database
(B) Relation
(C) Schema
(D) None
Controlling redundancy in a database management system DOES NOT help to?
(A) avoid duplication
(B) avoid unnecessary wastage of storage space
(C) avoid unauthorised access to data
(D) avoid inconsistency among data