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?
Data types
Primary keys
Default values
All of the above.
Answer: Option
Explanation:
No answer description is available. Let's discuss.

22.
SQL query and modification commands make up a(n) ________ .
DDL
DML
HTML
XML
Answer: Option
Explanation:
No answer description is available. Let's discuss.

23.
When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
LIKE only.
IN only.
NOT IN only.
Both IN and NOT IN.
Answer: Option
Explanation:
No answer description is available. Let's discuss.

24.
The Microsoft Access wildcards are ____ and ____ .
asterisk (*); percent sign (%)
percent sign (%); underscore (_)
underscore(_); question mark (?)
question mark (?); asterisk (*)
Answer: Option
Explanation:
No answer description is available. Let's discuss.

25.
Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');
SELECT NAME IN CUSTOMER WHERE STATE = 'VA';
SELECT NAME IN CUSTOMER WHERE STATE = 'V';
SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');
Answer: Option
Explanation:
No answer description is available. Let's discuss.