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.


Correct Answer:  D. All of the above.

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

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


Correct Answer:  B. DML

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.


Correct Answer:  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 (*)


Correct Answer:  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’);


Correct Answer:  D. SELECT NAME FROM CUSTOMER WHERE STATE IN (‘VA’);

Comments

No comments yet. Why don’t you start the discussion?

Leave a Reply

Your email address will not be published. Required fields are marked *

2 × three =