Introduction to SQL problems
- 1. A view is which of the following?
Options- A. A virtual table that can be accessed via SQL commands
- B. A virtual table that cannot be accessed via SQL commands
- C. A base table that can be accessed via SQL commands
- D. A base table that cannot be accessed via SQL commands Discuss
Correct Answer: A virtual table that can be accessed via SQL commands
- 2. In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
Options- A. all columns of the table are to be returned.
- B. all records meeting the full criteria are to be returned.
- C. all records with even partial criteria met are to be returned.
- D. None of the above is correct. Discuss
Correct Answer: all columns of the table are to be returned.
- 3. The command to eliminate a table from a database is:
Options- A. REMOVE TABLE CUSTOMER;
- B. DROP TABLE CUSTOMER;
- C. DELETE TABLE CUSTOMER;
- D. UPDATE TABLE CUSTOMER; Discuss
Correct Answer: DROP TABLE CUSTOMER;
- 4. 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
Correct Answer: has a distinct form that cannot be duplicated by a join.
- 5. 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
Correct Answer: use FROM to name the source table(s) and list the columns to be shown after SELECT.
- 6. SQL query and modification commands make up a(n) ________ .
Options- A. DDL
- B. DML
- C. HTML
- D. XML Discuss
Correct Answer: DML
- 7. A subquery in an SQL SELECT statement is enclosed in:
Options- A. braces -- {...}.
- B. CAPITAL LETTERS.
- C. parenthesis -- (...) .
- D. brackets -- [...]. Discuss
Correct Answer: parenthesis -- (...) .
- 8. SQL data definition commands make up a(n) ________ .
Options- A. DDL
- B. DML
- C. HTML
- D. XML Discuss
Correct Answer: DDL
- 9. The Microsoft Access wildcards are ____ and ____ .
Options- A. asterisk (*); percent sign (%)
- B. percent sign (%); underscore (_)
- C. underscore(_); question mark (?)
- D. question mark (?); asterisk (*) Discuss
Correct Answer: question mark (?); asterisk (*)
- 10. ON UPDATE CASCADE ensures which of the following?
Options- A. Normalization
- B. Data Integrity
- C. Materialized Views
- D. All of the above. Discuss
Correct Answer: Data Integrity
More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.