databases Online Quiz - 4
Description: databases Online Quiz - 4 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
PRINT NOGEN
PCB TYPE=DB,DBDNAME=VENDOR
SENSEG NAME=VENSEG,PROCOPT=G
SENSEG NAME=ITEMSEG,PARENT=VENSEG,PROCOPT=R
SENSEG NAME=LOCNSEG,PARENT=ITEMSEG,PROCOPT=A
PSBGEN
END
Referring to the sample code above, what is missing in the first macro in the PSBGEN job stream?
@@Error returns the sys.messages.message_id column value if an error occurs in the last T-SQL statement executed.True/False?
A transaction must have ACID properties to be qualified as such.
Which of the Isolation levels causes "Dirty Read"?
Which one of the below functions is Non-Deterministic?
The given T-SQL statement is executed. What happens?
COUNT(*) returns the number of items in a group - which of the below is correct?
sys.sql_modules system catalog contains a row for each object of type P, RF, V, TR, FN, IF, TF, R, and D.
We can write triggers for Truncate.
Extended Stored Procedure master.dbo.xp_fileexist can be used to decide if a file exists.
If DBCC CHECKDB for a database then DBCC CHECKALLOC has to be run separately.
MARS stands for:
There must be at least one log file for each database.
SQL 2005 XML data type instance storage has a limit. Choose the correct limit:
A trigger name in SQL 2005 cannot start with #.
Which one of the below, returns the maximum number of simultaneous user connections allowed on an instance of SQL Server?
Choose the correct option:
Choose the correct option:
Which of the below is used to get the system lock information?
Which of the below is a part of Data Control Language?