SQL Server Mock Test 4

10%

Question 1 of 10

1. User defined function in SQL Server can return ____________

Result set

Scalar value

All of the mentioned

Set of values

Question 1 of 10

Question 2 of 10

2. Life cycle of typical cursor involves ______ steps in SQL Server.

Question 2 of 10

Question 3 of 10

3. Point out the wrong statement.

If the function specifies a user-defined type, requires READ permission on the type

If the function specifies a user-defined type, requires ALTER permission on the type

None of the mentioned

If the function specifies a user-defined type, requires EXECUTE permission on the type

Question 3 of 10

Question 4 of 10

4. Point out the wrong statement.

If an error does not occur in the TRY block, control is passed to another group of statements that is enclosed in a CATCH block

None of the mentioned

If an error occurs in the TRY block, control is passed to another group of statements that is enclosed in a CATCH block

If an error occurs in the TRY block, control is not passed to another group of statements that is enclosed in a CATCH block

Question 4 of 10

Question 5 of 10

5. ____________ cursor is sensitive to any changes to the data source.

Keyset Driven Cursors

None of the mentioned

Static Cursors

Dynamic Cursors

Question 5 of 10

Question 6 of 10

6. Purpose of DDL Trigger is to _____________

Regulating database operations

Audit

Perform administrative tasks

All of the mentioned

Question 6 of 10

Question 7 of 10

7. Point out the wrong statement.

DML Triggers are used to evaluate data after data manipulation using DML statements

INSTEAD OF triggers cause their source DML operation to skip

AFTER triggers cause their source DML operation to skip

We can have an INSTEAD OF insert/update/delete trigger on a table that successfully executed

Question 7 of 10

Question 8 of 10

8. Which of the following is not a limitation of user defined function?

The FOR XML clause is not allowed

SET statements are allowed in a user-defined function

User-defined functions cannot call a stored procedure, but can call an extended stored procedure

User-defined functions cannot make use of dynamic SQL or temp tables. Table variables are allowed

Question 8 of 10

Question 9 of 10

9. Syntax for creation of user defined function is ____________

CREATE FUNCTION

CREATE FUNCTIONS

CREATE FUNC

All of the mentioned

Question 9 of 10

Question 10 of 10

10. Point out the correct statement.

A stored procedure is a group of Transact-SQL statements pre compiled into a single execution plan

Conditional logic applied to the results of the first SQL statements determines which subsequent SQL statements are executed

Stored procedures cannot improve performance

All of the mentioned

Question 10 of 10