View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.
You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.
Examine this SQL statement:

Exhibit 1.

Exhibit 2.

What will be the result?

• A.It gives an error because the ALL keyword is not valid
• B.It executes successfully and gives the required result
• C.It executes successfully but does not give the required result
• D.It gives an error because the GROUP BY clause is not valid

Comment: *

Name: *

Email: *

Verification: *

Examine this description of the TRANSACTIONS table:

Which two SQL statements execute successfully? (Choose two.)
SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100

• A.transactions;
  SELECT customer_id AS 'CUSTOMER-ID', transaction_date AS DATE, amount + 100
• B.DUES FROM transactions;
  SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount +
• C.'DUES AMOUNT' FROM transactions;
• D."DUES" FROM transactions;
  SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100
• E.100 "DUES AMOUNT" FROM transactions;
  SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true regarding indexes? (Choose three.)

• A.A UNIQUE index can be altered to be non-unique
• B.A SELECT statement can access one or more indices without accessing any tables
• C.A table belonging to one user can have an index that belongs to a different user
• D.An update to a table can result in updates to any or all of the table's indexes
• E.When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped
• F.An update to a table can result in no updates to any of the table's indexes

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)

• A.External table files can be used for other external tables in a different database
• B.The ORACLE_LOADER access driver can be used to unload data from a database into an external table
• C.The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table
• D.They cannot be partitioned
• E.The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table
• F.They support UPDATEs but not INSERTs and DELETEs

Comment: *

Name: *

Email: *

Verification: *

The customers table has a cust_last_name column of data type varchar2.
The table has two rows whose "jst_last_name values are Andersen and Ausson.
Which query produces output for cust_last_xame containing Oder for the first row and Aus for the second?

• A.SELECT REPLACE(SUBSTR(cust_last_name, -3), 'An', 'O') FROM customers;
• B.SELECT INITCAP (REPLACE(TRIM('son' FROM cust_last_name), 'An', 'O*)) FROM customers;
• C.SELECT REPLACE<TRIM<TRAILING 'son* FROM cust_last_name), 'An', *O'> FROM customers;
• D.SELECT REPLACE(REPLACE(cust_last_name, 'son', ''), 'An', 'O'> FROM customers;

Comment: *

Name: *

Email: *

Verification: *