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

B.'DUES AMOUNT' FROM transactions;

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

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

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

A.A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.

B.GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.

C.A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.

D.GLOBAL TEMPORARY TABLE space allocation occurs at session start.

E.A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

F.Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.

A.CONCAT (qty_sold, invoice_date) : requires explicit conversion

B.invoie_date > '01-02-2019' : uses implicit conversion

C.invoice_date = '15-march-2019' : uses implicit conversion

D.qty_sold = '0554982' uses implicit conversion

E.qty_sold BETWEEN '101' AND '110' : uses implicit conversion

A.It must be smaller than the smallest BIGFILE tablespace

B.Free space is managed using freelists

C.Any data files added to the tablespace must have a size of 5 gigabytes

D.It uses the database default blocksize

E.It is a locally managed tablespace

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

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

C.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

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

E.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

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

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