The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully? (Choose two.)

• A. SELECT TO_CHAR(NVL(cust_credit_limit * .15, `Not Available')) FROM customers;
• B. SELECT NVL(TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;
• C. SELECT NVL2(cust_credit_limit * .15, `Not Available') FROM customers;
• D. SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;
• E. SELECT NVL(cust_credit_limit * .15, `Not Available') FROM customers;

Which three statements are true about single-row functions? (Choose three.)

• A. They can be nested to any level
• B. The argument can be a column name, variable, literal or an expression
• C. They can be used only in the WHERE clause of a SELECT statement
• D. They return a single result row per table
• E. They can accept only one argument
• F. The data type returned can be different from the data type of the argument

View the Exhibit and examine the structure of the PRODUCTS table.
Which two tasks require subqueries? (Choose two.)

• A. Display suppliers whose PROD_LIST_PRICE is less than 1000
• B. Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable
• C. Display the minimum PROD_LIST_PRICE for each product status
• D. Display the total number of products supplied by supplier 102 which have a product status of obsolete
• E. Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE

Which statement is true about database links?

• A. A public database link can be created only by sys.
• B. A database link can be created only between two Oracle databases.
• C. A public database link can be used by a user connected to the local database instance to connect to any schema in the remote database instance.
• D. A database link created in a database allows a connection from that database's instance to the target database's Instance, but not vice versa.
• E. Private database link creation requires the same user to exist in both the local and the remote databases.

In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties:
1. A size of 100 MB
2. AUTOEXTEND is off
3. UNDO_RETENTION is set to 15 minutes
4. It has RETENTION GUARANTEE
UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens.
What will happen when the next update is attempted by any transaction?

• A. It succeeds and the generated undo is stored in SYSTEM.
• B. It fails and returns the error message "ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'".
• C. It succeeds and the generated undo is stored in SYSAUX.
• D. It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.
• E. It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.