Multiple Choice Questions

Set 4

1:    SQL is a …    

a. Non-Procedural Language

b- Procedural Language

2:     Oracle Corporation started in

a. 1950

b-1970

c-1990

d-1980

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

a– fourth   b-second     c-third       d- first

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

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

a-DELETE

b-ADD

c- SELECT

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

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

a- Product

b-sum

c- number of values

d- average

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

a- sum

b-number

c-average

d-smallest

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

a- smallest

b- average

c-sum

d- number

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)