With SQL Server, parameters and variables in T-SQL start with the "%" sign.
Answer: B
No answer description available for this question.
Enter details here
SQL Server program code that is executed instead of an SQL command that needs to be processed is called a(n):
Answer: A
No answer description available for this question.
Enter details here
The strictest transaction isolation level provided by SQL Server is called:
Answer: B
No answer description available for this question.
Enter details here
SERIALIZABLE is the strictest isolation level.
Answer: A
No answer description available for this question.
Enter details here
SQL Server supports INSTEAD OF, AFTER and BEFORE triggers.
Answer: B
No answer description available for this question.
Enter details here
There is only one way to create and modify tables in SQL Server. Write SQL code using either the CREATE or ALTER statements.
Answer: B
No answer description available for this question.
Enter details here
Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?
Answer: D
No answer description available for this question.
Enter details here
SQL Server supports three recovery modes: simple, full and Bulk.
Answer: A
SQL Server provides three different recovery models that allow you to specify the way SQL Server manages log files and prepares your enterprise for a disaster. Each of these models represents a different approach to balancing the tradeoff between conserving disk space and providing for granular disaster recovery options. The three disaster recovery models offered by SQL Server are:
1. Simple Recovery Model
2. Full Recovery Model
3. Bulk-logged Recovery Model
Enter details here
With which type of SQL Server recovery model, is no logging done?
Answer: D
No answer description available for this question.
Enter details here
With which type of SQL Server recovery model are all database changes logged except those that cause large log entries?
Answer: D
No answer description available for this question.
Enter details here