A.  The owner of an object acquires all object privileges on that object by default.

B.  A table owner must grant the REFERENCES privilege to allow other users to create FOREIGN KEY constraints using that table.

C.  An object privilege can be granted to other users only by the owner of that object.

D.  The WITH GRANT OPTION clause can be used only by DBA users.

E.  An object privilege can be granted to a role only by the owner of that object.

A.  Sequences can always have gaps

B.  A sequence can issue duplicate values

C.  A sequence number that was allocated can be rolled back if a transaction fails

D.  A sequence can only be dropped by a DBA

E.  A sequence's unallocated cached value are lost if the instance shuts down

F.  Two or more tables cannot have keys generated from the same sequence

A.  1 row

B.  an error

C.  2 rows

D.  0 rows

A.  UNION 演算子を使用した複合クエリの最初の SELECT の最初の列は、ORDER BY 句がない場合に出力を並べ替えるためにデフォルトで使用されます。

B.  複合クエリ内の各 SELECT ステートメントには、独自の ORDER BY 句を含めることができます。

C.  複合クエリ内の各 SELECT ステートメントには、独自の ORDER BY 句が必要です。

D.  複合クエリの最初の SELECT ステートメントの列名のみが認識されます。

E.  列の位置は ORDER BY 句で使用する必要があります。

A.  The DNAME column has a unique constraint.

B.  An index is created automatically in the MANAGER column.

C.  The DEPTNO column in the EMP table can contain the value 1.

D.  The COMMISSION column can contain negative values .

E.  The SALARY column must have a value .

F.  The MANAGER column is a foreign key referencing the EMPNO column.

G.  The DEPTNO column in the EMP table can contain NULLS .