database mcq DB-MCQS 4

By: Prof. Fazal Rehman Shamil
Last modified on September 23rd, 2020

Multiple Choice Questions

Set 4

1:    SQL is a …    

a. Non-Procedural Language

b- Procedural Language

Answer - Click Here:
A

2:     Oracle Corporation started in

a. 1950

b-1970

c-1990

d-1980

Answer - Click Here:
B

3:     SQL is the …… and, so far, only standard database language to gain wide acceptance.

a fourth   b-second     c-third       d- first

Answer - Click Here:
D

4:       SQL is used in other standards and even influences the development of other standards as a ……. tool.

a. addition

b- definitional

c-deletion

d- explanation

Answer - Click Here:
B

5:         SQL allows the table produced as the result of the ……..statement to contain duplicate rows

a-DELETE

b-ADD

c- SELECT

Answer - Click Here:
C

6:        An SQL statement consists of ……

a- functions 

b- reserved words

c-counting

d- alphabats

7:          The use of parentheses is always recommended in order to….  any possible ambiguities.

a-  increase

b- Overcome

c- compare

Answer - Click Here:
B

8:           COUNT – returns the ……. in a specified column

a- Product

b-sum

c- number of values

d- average

Answer - Click Here:
C

9:           SUM – returns the …… of the values in a specified column

a- sum

b-number

c-average

d-smallest

Answer - Click Here:
A

10:          AVG – returns the …….. of the values in a specified column

a- smallest

b- average

c-sum

d- number

Answer - Click Here:
B

More MCQs Of Database Systems

  1. SET 1: database design mcqs (database design mcqs )
  2. SET 2: database mcqs with answers pdf (database mcqs with answers pdf )
  3. SET 3: modern database management 12th edition mcqs (modern database management 12th edition mcqs)
  4. SET 4: database systems mcqs (database systems mcqs)
  5. SET 5: dbms mcqs (dbms mcqs )
  6. SET 6: dbms mcqs with answers (dbms mcqs with answers)
  7. SET 7: solved mcqs of dbms (solved mcqs of dbms)
  8. SET 8: dbms mcqs with answers pdf(dbms mcqs with answers pdf)
  9. SET 9: relational database management system mcqs(relational database management system mcqs)
  10. SET 10: solved mcqs of database management system(solved mcqs of database management system)
  11. SET 11: basic database mcqs pdf (basic database mcqs pdf)
  12. SET 12: relational database management system mcqs (relational database management system mcqs )
  13. SET 13: database mcqs online test (database mcqs online test)
  14. SET 14: database interview questions mcqs (database interview questions mcqs)
  15. SET 15: database developer mcqs (database developer mcqs)
  16. SET 16: database Repeated mcqs (database Repeated mcqs)
  17. SET 17: Database mcqs PPSC (Database mcqs PPSC)
  18. SET 18: Database mcqs FPSC (Database mcqs FPSC)
  19. SET 19: DBMS mcqs FPSC (DBMS mcqs FPSC)

Computer Science Repeated MCQs Book Download

Prof. Fazal Rehman Shamil
Latest posts by Prof. Fazal Rehman Shamil (see all)