Examine these statements executed in a single Oracle session:

Which three statements are true? (Choose three.)

• A.The code for penis 1.
• B.There is no row containing fountain pen.
• C.The code for penis 10.
• D.The code for fountain penis 3.
• E.There is no row containing pen.
• F.There is no row containing pencil.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of CUSTOMERS table.
Using the CUSTOMERS table, you need to generate a report that shows an increase in the credit limit by 15% for all customers. Customers whose credit limit has not been entered should have the message "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(cust_credit_limit), 'Not Available') "NEW CREDIT"FROM customers;
• C.SELECT NVL (TO CHAR(cust_credit_limit * .15), 'Not Available') "NEW CREDIT"FROM customers;
• D.SELECT NVL(cust_credit_limit * .15), 'Not Available') "NEW CREDIT"FROM customers;

Comment: *

Name: *

Email: *

Verification: *

The following are the steps for a correlated subquery, listed in random order:
* The WHERE clause of the outer query is evaluated.
* The candidate row is fetched from the table specified in the outer query.
* This is repeated for the subsequent rows of the table, till all the rows are processed.
* Rows are returned by the inner query, after being evaluated with the value from the candidate row in the outer query.
Which is the correct sequence in which the Oracle server evaluates a correlated subquery?

• A.2, 1, 4, 3
• B.4, 1, 2, 3
• C.4, 2, 1, 3
• D.2, 4, 1, 3

Comment: *

Name: *

Email: *

Verification: *

Examine the data in the CUST_NAMEcolumn of the CUSTOMERStable.

You want to extract only those customer names that have three names and display the * symbol in place of the first name as follows:

Which two queries give the required output? (Choose two.)

• A.SELECT LPAD(SUBSTR(cust_name, INSTR(cust_name, ' ')),LENGTH(cust_name),'*') "CUST NAME" FROM customers WHERE INSTR(cust_name, ' ',-1,2)<>0;
• B.SELECT LPAD(SUBSTR(cust_name, INSTR(cust_name, ' ')),LENGTH(cust_name),'*') "CUST NAME" FROM customers WHERE INSTR(cust_name, ' ',1,2)<>0;
• C.SELECT LPAD(SUBSTR(cust_name, INSTR (cust_name ' ')),LENGTH(cust_name) - INSTR(cust_name, '
  '), '*') "CUST NAME"
  FROM customers
  WHERE INSTR(cust_name, ' ',1,-2)<>0;
• D.SELECT LPAD(SUBSTR(cust_name, INSTR (cust_name ' ')),LENGTH(cust_name) - INSTR(cust_name, '
  '), '*') "CUST NAME"
  FROM customers
  WHERE INSTR(cust_name, ' ',1,2)<>0;

Comment: *

Name: *

Email: *

Verification: *

The customers table has the following structure:

You need to write a query that does the following tasks:
1. Display the first name and tax amount of the customers. Tax is 5% of their credit limit.
2. Only those customers whose income level has a value should be considered.
3. Customers whose tax amount is null should not be considered.
Which statement accomplishes all the required tasks?

• A.SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNTFROM customersWHERE (cust_income_level, tax_amount) IS NOT NULL;
• B.SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNTFROM customersWHERE cust_income_level IS NOT NULL ANDcust_credit_limit IS NOT NULL;
• C.SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNTFROM customersWHERE cust_income_level <> NULL ANDtax_amount <> NULL;
• D.SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNTFROM customersWHERE cust_income_level IS NOT NULL ANDtax_amount IS NOT NULL;

Comment: *

Name: *

Email: *

Verification: *