MCQS Database Systems- for GAT Subject CS- Set 6

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

Multiple Choice Questions

Set 6


1 .Which SQL statement is not used for Database updates.


2.The_________ statement is the most important statement in the language and is used to express a query.


3.There are _______ types of subquery.

1.ONE                        2. THREE       3.FIVE                       4.SEVEN

4. the columns of the result table come from more than one table, ________must be used.

  1. AND               2. &&                         3. JOIN      4.NONE

5.DBMS based on ______ .

1.Data                       2.user                        3.SQL             4. ALL

6.The SQL programming language was first developed in the _______ .

1. 1970 1975      3. 1980      4. 1982

7.The standard specifies ______different data types for data in an SQL database.

  1. TWO                      2.FOUR         3.SIX   4.EIGHT

8.Although SQL was originally an ________ concept.

1.HP               2.DELL                       3.IBM                        4.NONE

9.A vertical bar ( | ) indicates a choice among _______ .

1.same                      2. Alternatives                   3.both

10.In practice, the DDL statements are used to create the database structure.

1.DML                       2.DDL                        3.SQL             4.BNF



31.All non-numeric data values must be enclosed in _______.

  1. Double quotes                2. Single quotes     3.square brackets  4. curly braces


32.Which one is not an comparison operator for SQL.

  1. =                      2.  >                3.  !>              4.&&


33.ANDs are evaluated before _____.

  1. OR 2.  NOT                      3. BOTH a & b                     4. NONE


34.An expression is evaluated_______ .

  1. left to right   2.  Right to  left                   3. Depend on operators used


35.Which clause must always be the last clause of the SELECT statement.

1.WHERE                  2. ORDER BY                       3. COUNT                 4. GROUP BY

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)