Question 1

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?

technology databases

The PSBNAME
The PROCOPT
The TYPE parameter
The KEYLEN
The NAME parameter

Answer

Correct Option: D

Question 2

@@Error returns the sys.messages.message_id column value if an error occurs in the last T-SQL statement executed.True/False?

technology databases

True
False

Answer

Correct Option: A

Question 3

A transaction must have ACID properties to be qualified as such.

technology databases

True
False

Answer

Correct Option: A

Question 4

Which of the Isolation levels causes "Dirty Read"?

technology databases

Read Uncommitted
Read Committed
Repeatable Read
Snapshot
Serializable

Answer

Correct Option: A

Question 5

Which one of the below functions is Non-Deterministic?

technology databases

CASE
ISNULL
ISNUMERIC
ISDATE
None

Answer

Correct Option: D

Question 6

The given T-SQL statement is executed. What happens?

technology databases

A run time error occurs
Returns all the column names in the table but no records
Returns all the records in the table
Returns nothing
Returns NULL

Answer

Correct Option: B

Question 7

COUNT(*) returns the number of items in a group - which of the below is correct?

technology databases

This includes NULL values and duplicate
This includes NULL values but not the duplicates
This does not include NULL values and duplicates
None of the above

Answer

Correct Option: A

Question 8

sys.sql_modules system catalog contains a row for each object of type P, RF, V, TR, FN, IF, TF, R, and D.

technology databases

True
False

Answer

Correct Option: A

Question 9

We can write triggers for Truncate.

technology databases

True
False

Answer

Correct Option: B

Question 10

Extended Stored Procedure master.dbo.xp_fileexist can be used to decide if a file exists.

technology databases

True
False

Answer

Correct Option: A

Question 11

If DBCC CHECKDB for a database then DBCC CHECKALLOC has to be run separately.

technology databases

True
False

Answer

Correct Option: B

Question 12

MARS stands for:

technology databases

Multiple Active Record Sets
Multiple Active Result Sets
Multiple Account Record Sets
Multiple Account Result Sets

Answer

Correct Option: A

Question 13

There must be at least one log file for each database.

technology databases

True
False

Answer

Correct Option: A

Question 14

SQL 2005 XML data type instance storage has a limit. Choose the correct limit:

technology databases

1 GB
1024 KB
2 GB
500 MB

Answer

Correct Option: C

Question 15

A trigger name in SQL 2005 cannot start with #.

technology databases

True
False

Answer

Correct Option: A

Question 16

Which one of the below, returns the maximum number of simultaneous user connections allowed on an instance of SQL Server?

technology databases

@@MAX_CONNECTIONS
@@TRANCOUNT
@@CONNECTIONS
None of the above

Answer

Correct Option: A

Question 17

Choose the correct option:

technology databases

When SET ANSI_NULLS is OFF, comparisons of all data against a null value evaluate to UNKNOWN if the data value is NULL
When SET ANSI_NULLS is OFF, comparisons of all data against a null value evaluate to UNKNOWN if the data value is NOT NULL
When SET ANSI_NULLS is OFF, comparisons of all data against a null value evaluate to FALSE if the data value is NULL
When SET ANSI_NULLS is OFF, comparisons of all data against a null value evaluate to TRUE if the data value is NULL

Answer

Correct Option: D

Question 18

Choose the correct option:

technology databases

A CTE is created using the WITH statement
A CTE is created using the SELECT statement
A CTE is created using the CREATE statement
None of the above

Answer

Correct Option: A

Question 19

Which of the below is used to get the system lock information?

technology databases

sp_who
sys.dm_tran_locks
@@lock_timeout
sp_lock
None of the above

Answer

Correct Option: D

Question 20

Which of the below is a part of Data Control Language?

technology databases

SELECT
DENY
APPLY
UPDATE
None of the above

Answer

Correct Option: B

Description: databases Online Quiz - 4
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 4

Find more quizzes from top tags