Very important DBMS MCQ Questions .
Table of Contents
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 is created by data from the result of an SQL ‘Select’ statement is called _________
A. View
B. Synonym
C. Sequence
D. Transaction
7. 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 the 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.
11. A DBMS makes the
a) physical database available for different logical views.
b) logical database available for different analytical views.
c) physical database available for different analytical views.
d) logical database available for different physical views.
Answer: A
12. To eliminate duplicate rows in a query, the ________ qualifier is used in the SQL Select command
- A) alter
- B) distinct
- C) check
- D) specific
Answer-B
13. In Access SQL, the ____ is used as a wildcard to represent any individual character.
- _
- %
- &
- @
Answer = 1. Underscore
if you have any questions regarding the database management system then comment your questions
Thank you