Placement papers on SQL Server - Set 4

Placement papers on SQL Server - Set 4

1. Default is a type of constraint although it does not really enforce anything

Yes
No
View Answer / Hide Answer


2. Which one of the following can not have error-handling (e.g. RAISERROR)?

User-Defined Functions
Stored Procedures
Trigger
View Answer / Hide Answer


3. ___________________repeatedly sent from the client each time they run are compiled and optimized every time they are executed by SQL Server.

Transact-SQL statements
Stored Procedures
View Answer / Hide Answer


4. When SET SHOWPLAN_ALL is ON, SQL Server returns execution information for each statement without executing it.

True
False
View Answer / Hide Answer


5. Which statement should you execute when you do not want to rollback your data?

Delete
Truncate
View Answer / Hide Answer


6. Which of the following is the default isolation level in SQL Server?

Read Committed
Read Uncommitted
Repeatable Read
Serializable
View Answer / Hide Answer


7. Which of the following prevent "Dirty Reads"?

Read commited
Read Uncommitted
Repeatable Read
Serializable
View Answer / Hide Answer


8. Which join combines all rows from both tables?

Inner Join
Left Outer Join
Right Outer Join
Cross Join
View Answer / Hide Answer