Question:

Which of the following is NOT an Oracle- supported trigger?

A.

before

B.

during

C.

after

D.

instead of

Answer» b. during

Question:

Which one of the following is the right syntax for DECODE?

A.

decode (search, expression, result [, search, result]… [, default])

B.

decode (expression, result [, search, result]… [, default], search)

C.

decode (search, result [, search, result]… [, default], expression)

D.

decode (expression, search, result [, search, result]… [, default])

Answer» d. decode (expression, search, result [, search, result]… [, default])

Question:

Any recursive view must be defined as the union of two subqueries: a                query that is nonrecursive and a                      query.

A.

base, recursive

B.

recursive, base

C.

base, redundant

D.

view, base

Answer» a. base, recursive

Question:

Which prefixes are available to Oracle triggers?

A.

: new only

B.

: old only

C.

both :new and : old

D.

neither :new nor : old

Answer» c. both :new and : old

Question:

What MySQL property is used to create a surrogate key in MySQL?

A.

identical

B.

unique

C.

auto_increment

D.

sequence

Answer» c. auto_increment

Question:

Where is metadata stored in MySQL?

A.

in the mysql database meta

B.

in the mysql database metasql

C.

in the mysql database metadata

D.

in the mysql database mysql

Answer» d. in the mysql database mysql