• databases Online Quiz - 4
Back
0

databases Online Quiz - 4

Description: databases Online Quiz - 4
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
› 
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

  1. The PSBNAME

  2. The PROCOPT

  3. The TYPE parameter

  4. The KEYLEN

  5. The NAME parameter

Show answer
Correct Option: D

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

  1. True

  2. False

Show answer
Correct Option: A

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

  1. True

  2. False

Show answer
Correct Option: A

Which of the Isolation levels causes "Dirty Read"?
technology databases

  1. Read Uncommitted

  2. Read Committed

  3. Repeatable Read

  4. Snapshot

  5. Serializable

Show answer
Correct Option: A

Which one of the below functions is Non-Deterministic?

technology databases

  1. CASE

  2. ISNULL

  3. ISNUMERIC

  4. ISDATE

  5. None

Show answer
Correct Option: D

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

  1. A run time error occurs

  2. Returns all the column names in the table but no records

  3. Returns all the records in the table

  4. Returns nothing

  5. Returns NULL

Show answer
Correct Option: B

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

  1. This includes NULL values and duplicate

  2. This includes NULL values but not the duplicates

  3. This does not include NULL values and duplicates

  4. None of the above

Show answer
Correct Option: A

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

  1. True

  2. False

Show answer
Correct Option: A

We can write triggers for Truncate.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

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

technology databases

  1. True

  2. False

Show answer
Correct Option: A

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

  1. True

  2. False

Show answer
Correct Option: B

MARS stands for:
technology databases

  1. Multiple Active Record Sets

  2. Multiple Active Result Sets

  3. Multiple Account Record Sets

  4. Multiple Account Result Sets

Show answer
Correct Option: A

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

  1. True

  2. False

Show answer
Correct Option: A

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

technology databases

  1. 1 GB

  2. 1024 KB

  3. 2 GB

  4. 500 MB

Show answer
Correct Option: C

A trigger name in SQL 2005 cannot start with #.
technology databases

  1. True

  2. False

Show answer
Correct Option: A

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

  1. @@MAX_CONNECTIONS

  2. @@TRANCOUNT

  3. @@CONNECTIONS

  4. None of the above

Show answer
Correct Option: A

Choose the correct option:
technology databases

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

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

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

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

Show answer
Correct Option: D

Choose the correct option:
technology databases

  1. A CTE is created using the WITH statement

  2. A CTE is created using the SELECT statement

  3. A CTE is created using the CREATE statement

  4. None of the above

Show answer
Correct Option: A

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

  1. sp_who

  2. sys.dm_tran_locks

  3. @@lock_timeout

  4. sp_lock

  5. None of the above

Show answer
Correct Option: D

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

  1. SELECT

  2. DENY

  3. APPLY

  4. UPDATE

  5. None of the above

Show answer
Correct Option: B
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions