database mcq DB-MCQS 4

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 (Available for Professional Discussions)
1. Message on Facebook page for discussions,
2. Video lectures on Youtube
3. Email is only for Advertisement/business enquiries.