adplus-dvertising
frame-decoration

Question

By default sql server has ___________ isolation level

a.

READ COMMITTED

b.

READ UNCOMMITTED

c.

SERIALIZABLE

d.

REPEATABLE READ

Posted under DBMS

Answer: (a).READ COMMITTED

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. By default sql server has ___________ isolation level

Similar Questions

Discover Related MCQs

Q. Which feature converts row data to column for better analytical view?

Q. Which of the following statements is/are not true for SQL profiler?

Q. Which global variables can be used to determine if a transaction is still open?

Q. Which statement is used to define a cursor?

Q. What is the default “SORT” order for a SQL?

Q. Capabilities of RAISERROR

Q. How inserting data through stored procedure do reduces network traffic and increase database performance?

Q. Stored procedures are safe from SQL injection attacks

Q. Which of the following connection type supports application role permissions and password encryption?

Q. Cursor that reflects the changes made to the database table even after the result set is returned

Q. _______________ is a procedural extension of Oracle – SQL that offers language constructs similar to those in imperative programming languages.

Q. ___________ combines the data manipulating power of SQL with the data processing power of Procedural languages.

Q. _______________ has made PL/SQL code run faster without requiring any additional work on the part of the programmer.

Q. A line of PL/SQL text contains groups of characters known as

Q. We use ______________ name PL/SQL program objects and units.

Q. A ___________________ is an explicit numeric, character, string or Boolean value not represented by an identifier.

Q. If no header is specified, the block is said to be an _______________ PL/SQL block.

Q. _________________ is a sequence of zero or more characters enclosed by single quotes.

Q. In _______________ the management of the password for the account can be handled outside of oracle such as operating system.

Q. In ________________ of Oracle, the database administrator creates a user account in the database for each user who needs access.