General Questions

Question 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

Question 22 :

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


A). DDL
B). DML
C). HTML
D). XML
Answer : Option B

Question 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

Question 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

Question 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