Microsoft SQL Server 2008, Database Development: Implementing Programming ObjectsImplementing Programming Objects weighs 16% of the exam. This category includes topics likes, Create and alter stored procedures, Create and alter user-defined functions (UDFs), Create and alter DML triggers, Create and alter DDL triggers, Create and deploy CLR-based objects, Implement error handling, Manage transactions.
Total 10 questions found in this category.
Submit Question Show By Status: New Submissions Pending Deleted Approved
| Question | Subject | Category | | Which of the following is true about the SERIALIZABLE isolation level ? | Microsoft SQL Server 2008, Database Development | Implementing Programming Objects | | Which of the following options can be used for viewing lock status within your computer running SQL Server? | Microsoft SQL Server 2008, Database Development | Implementing Programming Objects | | Which of the following is a best practice to reduce deadlock situations? | Microsoft SQL Server 2008, Database Development | Implementing Programming Objects | | Shared locks are not compatible with exclusive locks. True/False? | Microsoft SQL Server 2008, Database Development | Implementing Programming Objects | | How many transactions at a time can obtain an update lock on a resource? | Microsoft SQL Server 2008, Database Development | Implementing Programming Objects | | The _____ object is used to retrieve information about all active transactions on an instance. | Microsoft SQL Server 2008, Database Development | Implementing Programming Objects | | To see the number of open transactions in the current session, ____ global variable is used. | Microsoft SQL Server 2008, Database Development | Implementing Programming Objects | | To rollback a portion of a transaction, We have to define ___. | Microsoft SQL Server 2008, Database Development | Implementing Programming Objects | | BEGIN TRANSACTION
INSERT INTO DemoTable
VALUES(5,'XYZ','DEMO');
BEGIN TRANSACTION
UPDATE DemoTable SET Col3 = 'Test'
WHERE TestID = 5;
COMMIT TRANSACTION;
ROLLBACK;
What is the result of the above code execution?
| Microsoft SQL Server 2008, Database Development | Implementing Programming Objects | | Which of the following is true about Implicit Transactions? | Microsoft SQL Server 2008, Database Development | Implementing Programming Objects |
Submit Interview/Test Questions with Answers and make money from adsense revenue sharing program
|
|