module 8 part #5

Question 1

Oracle recommends _____ for creating audit logs.

a. triggers
b. stored procedures
c. stored functions
d. tables

Answer 1

a. triggers

Question 2

Which statement describes a feature of Oracle sequences?

a. Oracle sequences are tied to columns and tables.

b. Oracle sequences generate a character string that can be assigned to tables.

c. An Oracle sequence uses the identity column property to automatically number rows.

d. Dropping a sequence does not delete values assigned to table attributes; it deletes only the sequence object from the database.

Answer 2

d. Dropping a sequence does not delete values assigned to table attributes; it deletes only the sequence object from the database.

Question 3

In Oracle, _____ make(s) it possible to merge SQL and traditional programming constructs, such as variables, conditional processing (IF-THEN-ELSE), basic loops (FOR and WHILE loops,) and error trapping.

a. dynamic SQL
b. stored procedures
c. embedded SQL
d. Procedural Language SQL

Answer 3

d. Procedural Language SQL

Question 4

In MS Access, a designer can use the _____ data type to define a column in his table that will be automatically populated with unique numeric values.

Answer 4

AutoNumber

Question 5

The Oracle string concatenation function is _____.

a. CONCAT
b. +
c. ||
d. &&

Answer 5

c. ||

Question 6

When writing SQL table-creating command sequences, the entire table definition is enclosed in _____.

a. asterisks
b. commas
c. quotations
d. parentheses

Answer 6

d. parentheses