An error that has a severity level of 10 is considered to be at a/an ______ leve
ID: 3579802 • Letter: A
Question
An error that has a severity level of 10 is considered to be at a/an ______ level:
< >
< >
< >
< >
If neither of 2 transactions can be committed because they each have a lock on a resource needed by the other, it is called a/an _______________.
< >
< >
< >
Save Point
Which of the following SQL statements prevents users from examining the SQL code that defines the view?
CREATE VIEW v_IN_Vendors
WITH ENCRYPTION
AS
SELECT * FROM Vendors
WHERE VendorState = ‘IN’;
CREATE VIEW v_IN_Vendors
WITH SCHEMABINDING
AS
SELECT * FROM Vendors
WHERE VendorState = ‘IN’;
CREATE VIEW v_IN_Vendors
AS
SELECT * FROM Vendors
WHERE VendorState = ‘IN’
WITH CHECK OPTION;
CREATE VIEW v_IN_Vendors
WITH VIEWLOCK
AS
SELECT * FROM Vendors
WHERE VendorState = ‘IN’;
Explanation / Answer
1. An error that has a severity level of 10 is considered to be at a/an ______ level:
severity level 10 is just information massage, the error information to the calling application.
2. If neither of 2 transactions can be committed because they each have a lock on a resource needed by the other, it is called a/an _______________
ans: save point.
3. ans:
CREATE VIEW v_IN_Vendors
WITH ENCRYPTION
AS
SELECT * FROM Vendors
WHERE VendorState = ‘IN’;