Question 11 : When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
1. NOT IN only.
2. LIKE only.
3. IN only.
4. Both IN and NOT IN.
View Answer   Discuss with Members

Question 12 : Which of the following do you need to consider when you make a table in SQL?
1. Data types
2. Primary keys
3. Default values
4. All of the above.
View Answer   Discuss with Members

Question 13 : The HAVING clause does which of the following?
1. Acts EXACTLY like a WHERE clause.
2. Acts like a WHERE clause but is used for columns rather than groups.
3. Acts like a WHERE clause but is used for groups rather than rows.
4. Acts like a WHERE clause but is used for rows rather than columns.
View Answer   Discuss with Members

Question 14 : In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
1. all columns of the table are to be returned.
2. all records meeting the full criteria are to be returned.
3. all records with even partial criteria met are to be returned.
4. None of the above is correct.
View Answer   Discuss with Members

Question 15 : The result of a SQL SELECT statement is a ________ .
1. file
2. report
3. table
4. form
View Answer   Discuss with Members

Question 16 : A subquery in an SQL SELECT statement is enclosed in:
1. parenthesis -- (...).
2. brackets -- [...].
3. CAPITAL LETTERS.
4. braces -- {...}.
View Answer   Discuss with Members

Question 17 : The SQL keyword(s) ________ is used with wildcards.
1. NOT IN only
2. LIKE only
3. IN only
4. IN and NOT IN
View Answer   Discuss with Members

Question 18 : The command to eliminate a table from a database is:
1. DROP TABLE CUSTOMER;
2. DELETE TABLE CUSTOMER;
3. REMOVE TABLE CUSTOMER;
4. UPDATE TABLE CUSTOMER;
View Answer   Discuss with Members

Question 19 : The wildcard in a WHERE clause is useful when?
1. An exact match is necessary in a CREATE statement.
2. An exact match is necessary in a SELECT statement.
3. An exact match is not possible in a SELECT statement.
4. An exact match is not possible in a CREATE statement.
View Answer   Discuss with Members

Question 20 : Which of the following is the original purpose of SQL?
1. To define the data structures
2. To specify the syntax and semantics of SQL data definition language
3. To specify the syntax and semantics of SQL manipulation language
4. All of the above.
View Answer   Discuss with Members