SQL-Query Basics  «Prev  Next»

Batch Queries and System Catalogs - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. What must you ensure that you do before issuing a query against a system catalog?
Please select the best answer.
  A. Switch to the appropriate database with the USE statement
  B. Install the system catalog
  C. Create a stored procedure to include the query against the system catalog
  D. Always switch to the MASTER database

2. What is the result of issuing this Transact-SQL batch? 
DECLARE @tmp varchar(30)
SELECT @tmp = ‘TMANN’
CREATE DEFAULT defPayGrade
AS 5

Please select the best answer.
  A. The default will be created as indicated
  B. An error will occur because the default is not bound to a column
  C. An error will occur because CREATE DEFAULT is not the only statement in the batch
  D. An error will occur because the syntax is incorrect

3. What is meta-data?
Please select the best answer.
  A. Data used to describe other objects contained within a database
  B. Data used to describe stored procedures only
  C. Data used to describe tables only
  D. Data that is described by meta-tags
Correct answers:

Your Score: 0