Discussion
Home ‣ Database ‣ Introduction to SQL Comments
- Question
The Microsoft Access wildcards are ____ and ____ .
Options- A. asterisk (*); percent sign (%)
- B. percent sign (%); underscore (_)
- C. underscore(_); question mark (?)
- D. question mark (?); asterisk (*)
- Correct Answer
- question mark (?); asterisk (*)
- 1. SQL data definition commands make up a(n) ________ .
Options- A. DDL
- B. DML
- C. HTML
- D. XML Discuss
- 2. A subquery in an SQL SELECT statement is enclosed in:
Options- A. braces -- {...}.
- B. CAPITAL LETTERS.
- C. parenthesis -- (...) .
- D. brackets -- [...]. Discuss
- 3. SQL query and modification commands make up a(n) ________ .
Options- A. DDL
- B. DML
- C. HTML
- D. XML Discuss
- 4. To define what columns should be displayed in an SQL SELECT statement:
Options- A. use FROM to name the source table(s) and list the columns to be shown after SELECT.
- B. use USING to name the source table(s) and list the columns to be shown after SELECT.
- C. use SELECT to name the source table(s) and list the columns to be shown after USING.
- D. use USING to name the source table(s) and list the columns to be shown after WHERE. Discuss
- 5. A subquery in an SQL SELECT statement:
Options- A. can only be used with two tables.
- B. can always be duplicated by a join.
- C. has a distinct form that cannot be duplicated by a join.
- D. cannot have its results sorted using ORDER BY. Discuss
- 6. ON UPDATE CASCADE ensures which of the following?
Options- A. Normalization
- B. Data Integrity
- C. Materialized Views
- D. All of the above. Discuss
- 7. The wildcard in a WHERE clause is useful when?
Options- A. An exact match is necessary in a SELECT statement.
- B. An exact match is not possible in a SELECT statement.
- C. An exact match is necessary in a CREATE statement.
- D. An exact match is not possible in a CREATE statement. Discuss
- 8. The SQL -92 wildcards are ____ and ____ .
Options- A. asterisk (*); percent sign (%)
- B. percent sign (%); underscore (_)
- C. underscore(_); question mark (?)
- D. question mark (?); asterisk (*) Discuss
- 9. Which of the following are the five built-in functions provided by SQL?
Options- A. COUNT, SUM, AVG, MAX, MIN
- B. SUM, AVG, MIN, MAX, MULT
- C. SUM, AVG, MULT, DIV, MIN
- D. SUM, AVG, MIN, MAX, NAME Discuss
- 10. Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
Options- 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'); Discuss
Introduction to SQL problems
Search Results
Correct Answer: DDL
Correct Answer: parenthesis -- (...) .
Correct Answer: DML
Correct Answer: use FROM to name the source table(s) and list the columns to be shown after SELECT.
Correct Answer: has a distinct form that cannot be duplicated by a join.
Correct Answer: Data Integrity
Correct Answer: An exact match is not possible in a SELECT statement.
Correct Answer: percent sign (%); underscore (_)
Correct Answer: COUNT, SUM, AVG, MAX, MIN
Correct Answer: SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.