SQL Server Mock Test 4

10%

Question 1 of 10

1. User defined scalar function can return only __________ data type values.

All of the mentioned

Numerical

String

Float

Question 1 of 10

Question 2 of 10

2. Which of the following procedures are created by user for own actions?

User Defined Stored Procedure

All of the mentioned

Extended Procedure

CLR Stored Procedure

Question 2 of 10

Question 3 of 10

3. Scope of DDL triggers in SQL Server can be _____________

Views

Client

Server

None of the mentioned

Question 3 of 10

Question 4 of 10

4. Point out the correct statement.

All of the mentioned

Stored procedures cannot improve performance

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

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

Question 4 of 10

Question 5 of 10

5. Point out the correct statement.

DML triggers are special type of trigger that fire when LOGON event of Sql Server is raised

None of the mentioned

Logon triggers are special type of trigger that fire when LOGON event of Sql Server is raised

DDL triggers are special type of trigger that fire when LOGON event of Sql Server is raised

Question 5 of 10

Question 6 of 10

6. Purpose of DDL Trigger is to _____________

Regulating database operations

Perform administrative tasks

Audit

All of the mentioned

Question 6 of 10

Question 7 of 10

7. Exception handling is possible in SQL Server using _____________

All of the mentioned

FINAL

FINALLY

THROW

Question 7 of 10

Question 8 of 10

8. CREATE FUNCTION requires __________ permission in the database.

ALTER

DROP

All of the mentioned

DELETE

Question 8 of 10

Question 9 of 10

9. Point out the correct statement.

All of the mentioned

A cursor is declared by defining the SQL statement that returns a result set

After data manipulation, we should close the cursor explicitly

A Cursor is opened and populated by executing the SQL statement defined by the cursor

Question 9 of 10

Question 10 of 10

10. Which of the cursors further have their subtypes?

Static Cursors

Dynamic Cursors

Keyset Driven Cursors

None of the mentioned

Question 10 of 10