Question is ⇒ The strictest transaction isolation level provided by SQL Server is called:, Options are ⇒ (A) REPEATABLE READ., (B) SERIALIZABLE., (C) READ COMMITTED., (D) READ UNCOMMITTED., (E) , Leave your comments or Download question paper.

Question is ⇒ The strictest transaction isolation level provided by SQL Server is called:, Options are ⇒ (A) REPEATABLE READ., (B) SERIALIZABLE., (C) READ COMMITTED., (D) READ UNCOMMITTED., (E) , Leave your comments or Download question paper. Previous question Next question


Q1.	The strictest transaction isolation level provided by SQL Server is called:
A.	REPEATABLE READ. [Wrong Answer]
B.	SERIALIZABLE. [Correct Answer]
C.	READ COMMITTED. [Wrong Answer]
D.	READ UNCOMMITTED. [Wrong Answer]
View Answer 1 -1 Explanation:- Answer : B Discuss it below : !! OOPS Login [Click here] is required to post your answer/result Help other students, write article, leave your comments

Previous question Next question

Also Read Similar Questions Below :

⇒ What is sent to the user via HTTP, invoked using the HTTP protocol on the user's computer, and run on the user's computer as an application?
A Java application
A Java applet
A Java servlet
None of the above is correct.

⇒ What type of join is needed when you wish to include rows that do not have matching values?
Equi-join
Natural join
Outer join
All of the above.

⇒ To define what columns should be displayed in an SQL SELECT statement:
use FROM to name the source table(s) and list the columns to be shown after SELECT.
use USING to name the source table(s) and list the columns to be shown after SELECT.
use SELECT to name the source table(s) and list the columns to be shown after USING.
use USING to name the source table(s) and list the columns to be shown after WHERE.

⇒ Which of the following are the five built-in functions provided by SQL?
COUNT, SUM, AVG, MAX, MIN
SUM, AVG, MIN, MAX, MULT
SUM, AVG, MULT, DIV, MIN
SUM, AVG, MIN, MAX, NAME

⇒ Which of the following refers to the SQL Server transaction isolation level which places and holds locks on all rows that are read?
REPEATABLE READ
SERIALIZABLE
READ COMMITTED
READ UNCOMMITTED

⇒ An SQL Server 2000 language that adds programming elements like parameters, variables, IF, WHILE loops, and so forth, to the basic capabilities of SQL is called:
COBOL.
VB.NET.
TRANSACT SQL.
Visual Basic.

⇒ What SQL structure is used to limit column values of a table?
The LIMIT constraint
The CHECK constraint
The VALUE constraint
None of the above is correct.

⇒ The SQL keyword BETWEEN is used:
for ranges.
to limit the columns displayed.
as a wildcard.
None of the above is correct.

⇒ Which JDBC driver Type(s) can be used in either applet or servlet code?
Both Type 1 and Type 2
Both Type 1 and Type 3
Both Type 3 and Type 4
Type 4 only

⇒ What is an SQL virtual table that is constructed from other tables?
Just another table
A view
A relation
Query results

⇒ How does Tomcat execute a JSP?
As a CGI script
As an independent process
By one of Tomcat's threads
None of the above is correct.

⇒ Embedded SQL is which of the following?
Hard-coded SQL statements in a program language such as Java.
The process of making an application capable of generating specific SQL code on the fly.
Hard-coded SQL statements in a procedure.
Hard-coded SQL statements in a trigger.

⇒ What type of join is needed when you wish to return rows that do have matching values?
Equi-join
Natural join
Outer join
All of the above.

⇒ The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;
Equi-join
Natural join
Outer join
Cartesian join

⇒ What servlet processor was developed by Apache Foundation and Sun?
Apache Tomcat
Apache Web server
Sun servlet processor
None of the above is correct.

⇒ Which JDBC driver Types are for use over communications networks?
Type 3 only
Type 4 only
Both Type 3 and Type 4
Neither Type 3 nor Type 4

⇒ ON UPDATE CASCADE ensures which of the following?
Normalization
Data Integrity
Materialized Views
All of the above.

⇒ A JSP is transformed into a(n):
Java applet.
Java servlet.
Either 1 or 2 above.
Neither 1 nor 2 above.

⇒ The wildcard in a WHERE clause is useful when?
An exact match is necessary in a SELECT statement.
An exact match is not possible in a SELECT statement.
An exact match is necessary in a CREATE statement.
An exact match is not possible in a CREATE statement.

⇒ The SQL WHERE clause:
limits the column data that are returned.
limits the row data are returned.
Both A and B are correct.
Neither A nor B are correct.

⇒ The SQL statement that queries or reads data from a table is ________ .
SELECT
READ
QUERY
None of the above is correct.

⇒ A view is which of the following?
A virtual table that can be accessed via SQL commands
A virtual table that cannot be accessed via SQL commands
A base table that can be accessed via SQL commands
A base table that cannot be accessed via SQL commands

⇒ Which of the following is an SQL trigger supported by Oracle?
BEFORE
INSTEAD OF
AFTER
All of the above.

⇒ With this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data.
Nonclustered
Clustered
Primary
Secondary

⇒ Which of the following is true concerning triggers?
You do not create them with SQL.
They execute against only some applications that access a database.
They have an event, condition, and action.
They cannot cascade (cause another trigger to fire).

⇒ Which of the following is the original purpose of SQL?
To specify the syntax and semantics of SQL data definition language
To specify the syntax and semantics of SQL manipulation language
To define the data structures
All of the above.

⇒ Where is metadata stored in MySQL?
In the MySQL database
In the MySQL database
In the MySQL database
None of the above is correct.

⇒ How many tables may be included with a join?
One
Two
Three
All of the above.

⇒ Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?
READ_ONLY
SCROLL_LOCK
OPTIMISTIC
READCOMMITTED

⇒ SQL Server program code that is executed after an SQL command has been processed is called a(n):
INSTEAD OF trigger.
BEFORE trigger.
AFTER trigger.
BEGIN trigger.