Database Management System Practice Test 8

1. The name of the transaction file shall be provided by the operator and the file that contains the edited transactions ready for execution shall be called

Trans. Exe

Opt. Exe

Batch. Exe

Edit.Exe

2. Capabilities of RAISERROR

All of the mentioned

It can print a message to the application

It can assign an error number, state and severity

It can be logged in the error log

3. What is the default "SORT" order for a SQL?

Ascending

As specified by the user

None of the mentioned

Descending

4. Which utilities can we use to export data from sql server to a text file?

DTS export wizard

ISQL

DTS export wizard and BCP

BCP

5. Which is the subset of SQL commands used to manipulate Oracle Database Structures, including tables?

Data Definition Language

Data Retrieval Language

Data Described Language

Data Manipulation Language

6. A ___________________ is an explicit numeric, character, string or Boolean value not represented by an identifier.

Identifiers

Comments

Delimiters

Literals

7. What are the different events in Triggers?

Select, Commit

Define, Create

Insert, Update, Delete

Drop, Comment

8. If no header is specified, the block is said to be an _______________ PL/SQL block.

Anonymous

Empty

Weak

Strong

9. The relation schema Student_Performance (name, courseNo, rollNo, grade) has the following FDs:

name,courseNo->grade
rollNo,courseNo->grade
name->rollNo
rollNo->name

The highest normal form of this relation scheme is

BCNF

4NF

3NF

2NF

10. Which global variables can be used to determine if a transaction is still open?

@@CONNECTIONS

@@TRANCOUNT

@@FETCH_STATUS

@@NESTLEVEL