A.Segments can span multiple tablespaces.

B.The number of data files is constrained only by the size of the storage array.

C.Extent location metadata is stored in the data dictionary by default.

D.Segments can span multiple data files.

E.Maximum file size can be set to unlimited only if the logical volume manager supports striping.

A.A table can have only one primary key but multiple foreign keys

B.It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted

C.Only the primary key can be defined at the column and table level

D.It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted

E.A table can have only one primary key and one foreign key

F.The foreign key columns and parent table primary key columns must have the same names

G.Primary key and foreign key constraints can be defined at both the column and table level

A.Oracle Managed Files (OMF)

B.Online table segment shrink

C.Online index segment shrink

D.Automatic data file extension (AUTOEXTEND)

E.Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR)

A.SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 DUES FROM transactions;

B.SELECT customer_id AS 'CUSTOMER-ID', transaction_date AS DATE, amount + 100 'DUES AMOUNT' FROM transactions;

C.SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;

D.SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100 "DUES" FROM transactions;

E.SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100 "DUES AMOUNT" FROM transactions;

A.It can be accessed only by the SYS user

B.It consists of a single row and single column of VARCHAR2 data type

C.It can display multiple rows but only a single column

D.It can be used to display only constants or pseudo columns

E.It can be accessed by any user who has the SELECT privilege in any schema

F.It can display multiple rows and columns