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

Mcq Questions and Answers of MS Access

Q.21. In SQL the statement select*from R, S is equivalent to

(A) Select * from R natural join S

(B) Select * from R cross join S

(C) Select * from R union join S

(D) Select * from R inner join S

Show Answer

Q.22. Which of the following is not a consequence of concurrent operations?

(A) Lost update problem

(B) Update anomaly

(C) unrepeatable read.

(D) Dirty read

Show Answer

Q.23.As per equivalence rules for query transformation, selection operation distributes over.

(A) Union

(B) Intersection

(C) Set difference

(D) All of the above

Show Answer

Q.24. The metadata is created by the 

(A) DML compiler

(B) DML pre-processor

(C) DDL interpreter

(D) Query interpreter

Show Answer

Q.25. When an E-R diagram is mapped to tables, the representation is redundant for 

(A) Weak entity sets

(B) Weak relationship

(C) strong entity sets

(D) strong relationship

Show Answer

Q.26. When R CS = f, then the cost of computing R><S is 

(A) the same as R × S

(B) greater the R × S

(C) less than R × S

(D) Cannot say anything

Show Answer

Q.27. In SQL the word ‘natural’ can be used with

(A) inner join

(B) full outer join

(C) right outer join

(D) all of the above

Show Answer

Q.28. The default level of consistency in SQL is 

(A) repeatable read

(B) read committed

(C) read uncommitted

(D) serializable

Show Answer

Q.29. if a transaction T has obtained an exclusive lock on item Q, then T can

(A) read Q

(B) write Q

(C) both read and write Q

(D) write Q but not read Q

Show Answer

Q.30. Shadow paging has 

(A) no redo

(B) no undo

(C) redo but no undo

(D) neither redo nor undo

Show Answer

You can ask me anything regarding microsoft access questions and answers if you face any problem. Visit on next page for more practice of ms access questions and answers.