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:

No answer description available for this question. Let us discuss.

22. 

SQL query and modification commands make up a(n) ________ .

A. DDL
B. DML
C. HTML
D. XML

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.

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:

No answer description available for this question. Let us discuss.

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:

No answer description available for this question. Let us discuss.

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:

No answer description available for this question. Let us discuss.