MCQ on MS Access Questions and Answers for Bank Exams and Interview

Mcq Questions and Answers of MS Access

Q.31. If the closure of an attribute set is the entire relation then the attribute set is a 

(A) super key

(B) candidate key

(C) primary key

(D) not a key

Q.32. DROP is a………statement in SQL.

(A) Query

(B) Embedded SQL

(C) DDL

(D) DCL

Q.33. If two relations R and S are joined, then the non-matching tuples of both R and S are ignored in 

(A) left outer join

(B) right router joins

(C) full outer join

(D) inner join

Q.34. The keyword to eliminate duplicate rows from the query result in SQL is 

(A) DISTINCT

(B) NO DUPLICATE

(C) UNIQUE

(D) None of the above

Q.35. In 2NF

(A) No functional dependencies (FDs) exist

(B) No multivalued dependencies (MVDs) exist

(C) No partial FDs exist

(D) No partial MVDs exist

Q.36.Which one is correct statement?

(1) Change in access methods.

(2) Adding new entities in database

(3) splitting and existing record into two or more records

(4) Splitting an existing record into two or more records

(5) Changing storage medium

(A) 1 and 2

(B) 5 Only

(C) 1 and 4

(D) 2 and 3

Q.37. In and E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect:

(A) Operationally, if Y is deleted, so is X

(B) existence is dependent on Y.

(C) Operationally, if X is deleted, so is Y

(D) Operationally, if X is deleted, & remains the same

Q.38. Relational Algebra is 

(A) Data Definition Language

(B)  Meta Language

(C) Procedural query Language

(D) None of the above

Q.39. Relational Algebra is 

(A) Data Definition Language

(B) Meta Language

(C) Procedural query Language

(D) None of the above

Q.40. RDBMS means: 

(A) Relation Data Base Management system

(B) Reliable Data Base Management system

(C) Relational Document Base Management System

(D) None of these

You can ask me anything regarding microsoft access questions and answers if you face any problem.