Introduction to SQL Questions

• A view is which of the following?
• In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
• The command to eliminate a table from a database is:
• A subquery in an SQL SELECT statement:
• To define what columns should be displayed in an SQL SELECT statement:
• SQL query and modification commands make up a(n) ________ .
• A subquery in an SQL SELECT statement is enclosed in:
• SQL data definition commands make up a(n) ________ .
• The Microsoft Access wildcards are ____ and ____ .
• ON UPDATE CASCADE ensures which of the following?
• The wildcard in a WHERE clause is useful when?
• The SQL -92 wildcards are ____ and ____ .
• Which of the following are the five built-in functions provided by SQL?
• Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
• Which of the following is valid SQL for an Index?
• To sort the results of a query use:
• The benefits of a standard relational language include which of the following?
• Which of the following do you need to consider when you make a table in SQL?
• Which of the following is the correct order of keywords for SQL SELECT statements?
• The SQL keyword(s) ________ is used with wildcards.