Database - Introduction to SQL
Exercise :: Introduction to SQL - General Questions
| 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. |
Answer: Option D
Explanation:
|
| 22. |
SQL query and modification commands make up a(n) ________ . |
Answer: Option B
Explanation:
|
| 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. |
Answer: Option D
Explanation:
|
| 24. |
The Microsoft Access wildcards are ____ and ____ . |
| A. |
asterisk (*); percent sign (%) | | B. |
percent sign (%); underscore (_) | | C. |
underscore(_); question mark (?) | | D. |
question mark (?); asterisk (*) |
Answer: Option D
Explanation:
|
| 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'); |
Answer: Option D
Explanation:
|
