View the exhibit and examine the structure and data in the invoice table. (Choose two.)

Which two SQL statements would execute successfully?

• A.SELECT MAX(AVG(SYSDATE -inv_date)) FROM invoice
• B.SELECT AVG( inv_date -SYSDATE), AVG(inv_amt) FROM invoice
• C.SELECT MAX(inv_date), MIN(cust_id) FROM invoice
• D.SELECT AVG(inv_date) FROM invoice

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTSand TIMEStables.

The PROD_IDcolumn is the foreign key in the SALEStable referencing the PRODUCTStable.
The CUST_IDand TIME_IDcolumns are also foreign keys in the SALEStable referencing the CUSTOMERS and TIMEStables, respectively.
Examine this command:
CREATE TABLE new_sales (prod_id, cust_id, order_date DEFAULT SYSDATE)
AS
SELECT prod_id, cust_id, time_id
FROM sales;
Which statement is true?

• A.The NEW_SALEStable would not get created because the column names in the CREATETABLE command and the SELECTclause do not match.
• B.The NEW_SALEStable would get created and all the NOTNULLconstraints defined on the selected columns from the SALES table would be created on the corresponding columns in the NEW_SALES table.
• C.The NEW_SALEStable would get created and all the FOREIGNKEYconstraints defined on the selected columns from the SALES table would be created on the corresponding columns in the NEW_SALES table.
• D.The NEW_SALEStable would not get created because the DEFAULTvalue cannot be specified in the column definition.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the SET VERIFY ONcommand? (Choose two.)

• A.It can be used in SQL Developer and SQL*Plus
• B.It displays values for variables used only in the WHEREclause of a query
• C.It can be used only in SQL*Plus
• D.It displays values for variables prefixed with &&
• E.It displays values for variables created by the DEFINEcommand

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about Data Manipulation Language (DML)?

• A.INSERT statements can insert NULLS explicitly into a column.
• B.DELETE statements can remove multiple rows based on multiple conditions.
• C.INSERT INTO...SELECT...FROM statements automatically commit.
• D.UPDATE statements can have different subqueries to specify the values for each updated column.
• E.DML statements require a primary key be defined on a table.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the CUSTOMERS table.

Using the CUSTOMERS table, you must generate a report that displays a credit limit increase of 15% for all customers.
Customers with no credit limit should have "Not Available" displayed.
Which SQL statement would produce the required result?

• A.SELECT TO_CHAR(NVL(cust_credit_limit*.15), 'Not Available')) "NEW CREDIT" FROM customers
• B.SELECT NVL (TO_CHAR(cust_credit_limit*.15), 'Not Available') "NEW CREDIT" FROM customers
• C.SELECT NVL (cust_credit_limit, 'Not Available')*.15 "NEW CREDIT" FROM customers
• D.SELECT NVL (cust_credit_limit*.15, 'Not Available') "NEW CREDIT" FROM customers

Comment: *

Name: *

Email: *

Verification: *