Multiple Choice Questions
Set 4
1: SQL is a …
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
- Database Models MCQs in DBMS
- Relational Database Model MCQs in DBMS
- SQL (Structured Query Language) MCQs in DBMS
- Database Design MCQs in DBMS
- Database Management System Architecture MCQs in DBMS
- Storage and File Structure MCQs in DBMS
- Query Processing and Optimization MCQs in DBMS
- Database Transaction Management MCQs in DBMS
- Database Security and Authorization MCQs in DBMS
- Backup and Recovery MCQs in DBMS
- Distributed Databases MCQs in DBMS
- SET 1: database design mcqs (database design mcqs )
- SET 2: database mcqs with answers pdf (database mcqs with answers pdf )
- SET 3: modern database management 12th edition mcqs (modern database management 12th edition mcqs)
- SET 4: database systems mcqs (database systems mcqs)
- SET 5: dbms mcqs (dbms mcqs )
- SET 6: dbms mcqs with answers (dbms mcqs with answers)
- SET 7: solved mcqs of dbms (solved mcqs of dbms)
- SET 8: dbms mcqs with answers pdf(dbms mcqs with answers pdf)
- SET 9: relational database management system mcqs(relational database management system mcqs)
- SET 10: solved mcqs of database management system(solved mcqs of database management system)
- SET 11: basic database mcqs pdf (basic database mcqs pdf)
- SET 12: relational database management system mcqs (relational database management system mcqs )
- SET 13: database mcqs online test (database mcqs online test)
- SET 14: database interview questions mcqs (database interview questions mcqs)
- SET 15: database developer mcqs (database developer mcqs)
- SET 16: database Repeated mcqs (database Repeated mcqs)
- SET 17: Database mcqs PPSC (Database mcqs PPSC)
- SET 18: Database mcqs FPSC (Database mcqs FPSC)
- SET 19: DBMS mcqs FPSC (DBMS mcqs FPSC)
New Arrival