Q.1 Which of the following is not a valid SQL type?
(A) FLOAT
(B) NUMERIC
(C) DECIMAL
(D) CHARACTER
Answer: C
Q.2 Which of the following is not a DDL command?
(A) TRUNCATE
(B) ALTER
(C) CREATE
(D) UPDATE
Answer: D
Q.3 Which statement is used to delete all rows in a table without having the action logged?
(A) DELETE
(B) REMOVE
(C) DROP
(D) TRUNCATE
Answer: D
Q.4 SQL Views are also known as
(A) Simple Tables
(B) Virtual Tables
(C) Complex Tables
(D) Actual Tables
Answer: B
Q.5 Which of the following is not Constraint in SQL?
(A) Primary Key
(B) Not Null
(C) Check
(D) Union
Answer: D
Q.6 Which operator is used to compare a value to a specified list of values?
(A) ANY
(B) BETWEEN
(C) ALL
(D) IN
Answer: D
Q.7 Which of the following is also called an INNER JOIN?
(A) SELF JOIN
(B) EQUI JOIN
(C) NON-EQUI JOIN
(D) None of the above
Answer: B
Q.8 Which of the following is true about the HAVING clause?
(A) Similar to the WHERE clause but is used for columns rather than groups.
(B) Similar to WHERE clause but is used for rows rather than columns.
(C) Similar to WHERE clause but is used for groups rather than rows.
(D) Acts exactly like a WHERE clause.
Answer: C
Q.9 Which command makes the updates performed by the transaction permanent in the database?
(A) ROLLBACK
(B) COMMIT
(C) TRUNCATE
(D) DELETE
Answer: B
Q.10 Which operator is used to compare the NULL values in SQL?
(A) Equal
(B) IN
(C) IS
(D) None of the above
Answer: C