21. Which of the following do you need to consider when you make a table in SQL?
A. Data types
B. Primary keys
C. Default values
D. All of the above.
22. SQL query and modification commands make up a(n) ________ .
A. DDL
B. DML
C. HTML
D. XML
23. When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
A. LIKE only.
B. IN only.
C. NOT IN only.
D. Both IN and NOT IN.
24. The Microsoft Access wildcards are ____ and ____ .
A. asterisk (*); percent sign (%)
B. percent sign (%); underscore (_)
C. underscore(_); question mark (?)
D. question mark (?); asterisk (*)
25. Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = ‘VA’;
A. SELECT NAME IN CUSTOMER WHERE STATE IN (‘VA’);
B. SELECT NAME IN CUSTOMER WHERE STATE = ‘VA’;
C. SELECT NAME IN CUSTOMER WHERE STATE = ‘V’;
D. SELECT NAME FROM CUSTOMER WHERE STATE IN (‘VA’);