Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

1. Which of the following statements is false? a. An object type can contain att

ID: 3903197 • Letter: 1

Question

1. Which of the following statements is false?

a. An object type can contain attributes and methods.

b. An object reference can be used to access a row in a object table.

c. An object type marked as NOT INSTANTIABLE prevents objects from that type from being created.

d. An object type cannot be used to define a column object or object table.

QUESTION 2 The AUDIT SYSTEM privilege is for tracking operations on specific database objects not for high-level auditing operations.

a. True

b. False

QUESTION 3 Which of the following is not a type of collection:

a. graphical views

b. associative arrays

c. nested tables

d. varrays

Explanation / Answer

1. An object type cannot be used to define a column object or object table. (FALSE)

Reason : Because with the help of object type one can define a type, defining a table, or data access.

2. The AUDIT SYSTEM privilege is for tracking operations on specific database objects not for high-level auditing operations. (TRUE)

REASON : AUDIT SYSTEM privilage is used to audit issuances of a SQL statement and also monitor different types of operation on a particular schema object.

3. Graphical Views is not a type of collection.

Reason : As the name specifies that since it is a view so it may be a type collection.