Question 1 (3 points) Saved When performing a single-row INSERT statement, if you omit the list of columns into which the data will be inserted: The INSERT operation will fail You should specify the column values in the same order as they appear in the table You must remember to include a value for any IDENTITY columns 0 You should code only for the values you're inserting (skip other columns) Question 2 (3 points) What method can you use to insert more than one row at a time? Multiple tables in the INSERT INTO clause A subquery instead of a VALUES clause Multiple lists in the VALUES clause, separated by commas The command MULTIPLE VALUES Question 3 (3 points When performing an UPDATE statement without using a WHERE clause, All rows will be updated All rows will be deleted The operation will fail No rows will be updated Question 4 (3 points) Applying a WHERE clause condition to a DELETE statement can allow you to: Remove a single row from the table Remove multiple rows from the table Remove rows based on a calculated expression All of the above Question 5 (3 points) DDL ("data definition language") commands are used to create and maintain database objects (such as tables, views, etc.). Which if the SQL commands below is a DDL command? Select only those that apply: UPDATE DELETE CREATE ALTER INSERT DROP Question 6 (3 points What is the correct syntax for a statement to make a new table? CREATE TABLE MAKE TABLE INSERT TABLE BUILD TABLE Question 7 (3 points) You can create multiple indexes (up to 250) on a single table. What is the primary benefit of indexes? They can improve performance in searches They can reduce the number of columns in a table They can improve performance in updates They can save space in the file system Question 8 (3 points) How are database constraints tested, and what is the result? They are tested after an INSERT or UPDATE; if they are violated, the operation succeeds They are tested after an INSERT or UPDATE; if they are violated, the operation succeeds with a warning They are tested before an INSERT or UPDATE; if they are violated, the operation succeeds with a warning They are tested before an INSERT or UPDATE; if they are violated, the operation fails Question 9 (3 points) A database view is a SELECT statement which is stored within the database, which can act as a sort of "virtual table". How do views differ from tables? Views can only be used in SELECT -not other DML statements Unlike a table, a view does not store any data Views do not allow visibility of underlying table data Views cannot be referenced in the FROM clause of a query Question 10 (3 points) Which of the following is an advantage of using database views? They can restrict data access by limiting visible columns/rows They can replace tables entirely They can be substituted for long, complicated SQL statements They reduce the amount of storage used by tables
