A.Partition key columns cannot be dropped.

B.A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.

C.An UNUSED column's space is reclaimed automatically when the row containing that column is next queried.

D.A column that is set to UNUSED still counts towards the limit of 1000 columns per table

E.An UNUSED column's space is reclaimed automatically when the block containing that column is next queried.

F.A DROP COLUMN command can be rolled back

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

B.100 "DUES AMOUNT" FROM transactions;
SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM

C.'DUES AMOUNT' FROM transactions;

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

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

A.It executes successfully but does not return any result

B.It generates an error

C.It returns the date for the last Monday of the current month

D.It returns the date for the first Monday of the next month

A.When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped

B.A SELECT statement can access one or more indices without accessing any tables

C.An update to a table can result in no updates to any of the table's indexes

D.A UNIQUE index can be altered to be non-unique

E.A table belonging to one user can have an index that belongs to a different user

F.An update to a table can result in updates to any or all of the table's indexes

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