Multiple Choice Questions
Set 6
1 .Which SQL statement is not used for Database updates.
1.INSERT Â Â Â Â Â 2. UPDATE 3. DELETE Â Â Â 4.SELECT
2.The_________ statement is the most important statement in the language and is used to express a query.
1.INSERT Â Â Â Â Â 2. UPDATE 3. DELETE Â Â Â 4.SELECT
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.
- 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.
- 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 _______.
- Double quotes               2. Single quotes    3.square brackets 4. curly braces
32.Which one is not an comparison operator for SQL.
- =                     2. >               3. !>             4.&&
33.ANDs are evaluated before _____.
- OR 2. NOT                     3. BOTH a & b                    4. NONE
34.An expression is evaluated_______ .
- 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
- 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)