Practice Sqlserver Multiple Choice Multiple Choice Questions with Answers Quiz-1

Q.1.

Reasons for consideration of the stored procedure can be?

a) With which tables will you have to work? Does it make sense to create a VIEW first?
b) How often will this procedure actually be used?
c) Do you want to view data in the database (SELECT), insert new records (INSERT INTO), or do I want to change an existing record (UPDATE)?
d) All of the mentioned

Explanation

Q.2.

Point out the correct statement.

a) Conditional logic applied to the results of the first SQL statements determines which subsequent SQL statements are executed
b) A stored procedure is a group of Transact-SQL statements pre compiled into a single execution plan
c) Stored procedures cannot improve performance
d) All of the mentioned

Explanation

Q.3.

__________ takes no parameters and returns all kinds of interesting information.

Explanation

Q.4.

Which of the following has support for transaction?

Explanation

Q.5.

Point out the wrong statement.

a) Support for transactions is one of the most important reasons to use database engines such as SQL Server
b) BASE support
c) ACID support
d) All of the mentioned

Explanation

Q.6.

__________create the removable database.

Explanation

Q.7.

Which of the following stored procedure is used for error messages?

Explanation

Q.8.

_____________ sets procedure options in SQL Server.

Explanation

Q.9.

__________ is used to build the code dynamically and execute it.

Explanation

Q.10.

Stored procedure used to remember the exact number of bytes is _____________

Explanation