1. SQL stands for Standard Query Language.
a. True
b. False
2. Semicolon at the end of each SQL statement will terminate the SQL statement.
a. True
b. False
3. SQL is not case sensitive.
a. True
b. False
4. The condition in a WHERE clause can refer to only one value.
a. True
b. False
5. SQL stands Structured Query Language?
a. True
b. false
6. SQL is a programming language
a. True
b. False
7. DDL stands for Data Derivation Language.
a. True
b. False
8. SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.
a. True
b. False
9. The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.
a. True
b. False
10. Primary keys can be the same in two different records.
a. True
b. False
11. The result of every SQL query is a table.
a. True
b. False
12. In SQL, the SELECT statement is used to retrieve data from a database.
a. True
b. False
13. ORDER BY can be combined with the SELECT statements.
a. True
b. False
14. ORDER BY can not be combined with the select statements.
a. True
b. False
15. Create and Alter is DDL command.
a. True
b. False
16. Data manipulation language (DML) commands are used to define a database including creating, altering and dropping tables and establishing constraints.
a. True
b. False
17. Insert, Update and Delete is DML command.
a. True
b. False
18. Insert command is used to add a new record to a table.
a. True
b. False
19. UPDATE command is used to delete a record.
a. True
b. False
20. Update command is used to make changes to existing data in a table.
a. True
b. False
21. Where clause is used to select specific rows in a table.
a. True
b. False
22.  The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.
a. True
b. False
23. SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN
a. True
b. False
24. SUM, AVG, MIN, and MAX can only be used with numeric columns.
a. True
b. False
25. COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.
a. True
b. False
26. The ADD command is used to enter one row of data or to add multiple rows as a result of a query.
a. True
b. False
27. CHAR data types can be used to store numbers that will not be used in calculations.
a. True
b. False
28. The keyword LIKE can be used in a WHERE clause to refer to a range of values.
a. True
b. False
29. SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions.
a. True
b. False
30. To establish a range of values, < and > can be used.
a. True
b. False
31. The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.
a. True
b. False
32. The result of a SELECT statement can contain duplicate rows. Â
a. True
b. False
33. The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.
a. True
b. False
34.  We can insert two records with same roll number in a table if roll is assigned as primary key.
a. True
b. False
35. We can use DROP statement to remove a database or table permanently from the system.
a. True
b. False
36. You can use the SQL CREATE TABLE command to insert rows into a table.
a. True
b. False
37. In a SELECT statement, the WHERE clause is mandatory.
a. True
b. False
38. ORDER BY keyword is used to sort the result set in ascending or descending order.
a. True
b. False
39. When sorting with an ORDER BY clause, the default order is ascending, however this can be overridden using the keyword DESC.
a. True
b. False
40. The WHERE clause in SQL is used to filter records.
a. True
b. False
41. The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.
a. True
b. False
42. The SQL keyword Group By is used to collect those rows that have the same value in a specified column.
a. True
b. False
43. The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.
a. True
b. False
44. A WHERE and a HAVING clause cannot be included in the same query.
a. True
b. False
45. You use the WHERE clause on groups and the HAVING clause on rows.
a. True
b. False
46. You can use the GROUP BY clause and the ORDER BY clause in the same SELECT statement.
a. True
b. False
47. When you connect simple conditions using the AND operator, only one of the simple conditions must be true for the compound condition to be true.
a. True
b. False
48. The SQL built-in function SUM, totals values in numeric columns.
a. True
b. False
49. There is no difference between the COUNT function and the SUM function.
a. True
b. False
50. A compound condition includes either or both of the AND and OR operators.
a. True
b. False