DBMS MCQ Questions and Answer Set-5

Very important DBMS MCQ Questions .

1.   Which data manipulation command is used to combines the records from one or more tables?

A. SELECT

B. PROJECT

C. JOIN

D. PRODUCT

2.   SQL permits attribute names to be repeated in the same relation. (True or False)

A. FALSE

B. TRUE

3.   Which of the following operations requires the relations to be union compatible?

A. UNION

B. INTERSECTION

C. DIFFERENCE

D. ALL OF THESE

4.   Which of the following is a legal expression in SQL?

A. SELECT NULL FROM SALES;

B. SELECT NAME FROM SALES;

C. SELECT * FROM SALES WHEN PRICE = NULL;

D. SELECT # FROM SALES;

5.   The COUNT function in SQL returns the number of ______________

A. Values

B. Distinct values

C. Group By

D. Columns

6.   The virtual table that its created by data from the result of an SQL ‘Select’ statement is called _________

A. View

B. Synonym

C. Sequence

D. Transaction

  •  What is the other name of INNER JOIN?

    a) Equi Join
    b) In Join
    c) Out Join
    d) All of the above

8.    List the types of Inner join?

a) Out, In, Equi
b) Left, In, Cross
c) Equi, Natural

d) None of the above

9-What is the purpose of index in SQL server?

a) It leads to enhance the query performance.
b) It leads to provide an index to a record.
c) It leads to perform fast searches.
d) None of the above
e) All of the above.

10. Does index take space in Disk?

a) It stores in memory as and when required.
b) Yes, Indexes are stored on the disk.
c) Indexes are never stored on the disk.
d) Index takes no space.

if you have any questions regarding database management system then comment your questions

Thank you

Leave a Reply

Your email address will not be published. Required fields are marked *