- All Exams Instant Download
One reason to create a stored procedure is to:
One reason to create a stored procedure is to:A . improve performance.B . minimize storage space.C . bypass case sensitivity requirements.D . give the user control of the query logic.View AnswerAnswer: A
What will make this type of search more efficient?
You have a table named Product that contains one million rows. You need to search for product information in the Product table by using the product's unique ID. What will make this type of search more efficient?A . a cursorB . a subqueryC . a triggerD . an indexView AnswerAnswer:...
The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?
The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?A . viewB . functionC . indexD . stored procedureE . triggerView AnswerAnswer: C
You need to store the contact information for each student in your school database.
You need to store the contact information for each student in your school database. You should store each student's information in a:A . stored procedure.B . function.C . row.D . variable.View AnswerAnswer: C
Which keyword would you use in a select statement to return rows that meet a specific condition?
Which keyword would you use in a select statement to return rows that meet a specific condition?A . WHEREB . UNIONC . ORDER BYD . FROMView AnswerAnswer: A
What is the result?
A database contains two tables named Customer and Order. You execute the following statement: DELETE FROM Order WHERE CustomerID = 209 What is the result?A . The first order for CustomerID 209 is deleted from the Order table.B . All orders for CustomerID 209 are deleted from the Order table,...
In SQL, an insert statement is used to add a:
In SQL, an insert statement is used to add a:A . user to a database.B . row of data to a table.C . table to a database.D . column to a table definition.View AnswerAnswer: B
Which category of SQL statements is used to add, remove, and modify database structures?
Which category of SQL statements is used to add, remove, and modify database structures?A . data access language (DAL)B . data manipulation language (DML)C . data control language (DCL)D . data definition language (DDL)View AnswerAnswer: D
One difference between a function and a stored procedure is that a function:
One difference between a function and a stored procedure is that a function:A . must be called from a trigger.B . must return a value.C . cannot contain a transaction.D . cannot accept parameters.View AnswerAnswer: B
Denormalization is performed in order to:
Denormalization is performed in order to:A . reduce redundancy.B . eliminate repeating groups.C . create smaller tables.D . improve query performance.View AnswerAnswer: D
