Question 1 10 pts

What makes stored procedures faster than sending a Transact-SQL statement to SQL Server? Please select the best answer.

Group of answer choices

The Transact-SQL statements are shorter.

There are less commands available, so parsing time is shorter.

The query plan is compiled and cached on the server.

They are not faster.

Question 2 10 pts

What is a view?

Group of answer choices

A view is a virtual table which results of executing a pre-compiled query

A view is a special stored procedure executed when certain event occurs

A view is a database diagram

None of the Above

Question 3 10 pts

Which of the following following statements is true?

Group of answer choices

All of the statements are true

Views add an additional layer on the table which enables us to protect intricate or sensitive data based upon our needs

Creating views can improve query response time

Views are virtual tables that are compiled at run time

Question 4 10 pts

You can delete a view with ___________ command.

Group of answer choices

DROP VIEW

DELETE VIEW

REMOVE VIEW

TRUNCATE VIEW

Question 5 10 pts

Create a stored procedure named "SelectAllCustomers" that selects all records from the

Question 6 10 pts

Indexes are transparent to users, they are just used to speed up searches/queries.

Group of answer choices

True

False

Question 7 10 pts

What database object is executed automatically in response to a database object, database, or server event?

Group of answer choices

Stored Procedure

View

Trigger

Index

Question 8 10 pts

What is NOT considered to be a difference between a stored procedure and a stored function?

Group of answer choices

You can group a set of SQL statements and execute them within a stored procedure, but not a function.

Functions are designed to send their output to a query or SQL statement. while stored procedures are designed to return one or more result set.

Stored procedures cannot be called within SQL statements, while functions may be invoked directly from your queries and/or stored procedures.

A stored procedure accepts input while a function does not.

Question 9 10 pts

Which of the following database objects can be used inside a SQL query?

Group of answer choices

Stored Procedure

View

User Function

Index

Question 10 10 pts

What is a disadvantage to using an index?

Group of answer choices

The database developer has to keep updating the index manually.

It is difficult to determine when to apply an index to a table.

Indexes make searching the database table slower.

Updating a table with indexes takes more time than updating a table without because the indexes also need an update.