Examine the description of the CUSTOMERS table:

You need to display last names and credit limits of all customers whose last name starts with A or B in lower or upper case, and whose credit limit is below 1000.
Examine this partial query:

Which two WHERE conditions give the required result?

• A.Option B
• B.Option E
• C.Option C
• D.Option D
• E.Option A

Comment: *

Name: *

Email: *

Verification: *

Which three are true about multitable INSERT statements?

• A.They can be performed on external tables using SQL* Loader.
• B.They can insert each computed row into more than one table.
• C.They can be performed on remote tables.
• D.They can be performed only by using a subquery.
• E.They can be performed on relational tables.
• F.They can be performed on views.

Comment: *

Name: *

Email: *

Verification: *

The first DROP operation is performed on PRODUCTS table using this command:
DROP TABLE products PURGE;
Then a FLASHBACK operation is performed using this command:
FLASHBACK TABLE products TO BEFORE DROP;
Which is true about the result of the FLASHBACK command?

• A.It recovers only the table structure.
• B.It recovers the table structure, data, and the indexes.
• C.It recovers the table structure and data but not the related indexes.
• D.It is not possible to recover the table structure, data, or the related indexes.

Comment: *

Name: *

Email: *

Verification: *

The SALES table has columns PROD_IDand QUANTITY_SOLDof data type NUMBER.
Which two queries execute successfully?

• A.COUNT(*) >10;
  SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*) > 10 GROUP
• B.prod_id;
  SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*) > 10 GROUP
• C.SELECT prod_id FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id HAVING
• D.BY prod_id HAVING COUNT(*) >10;
  SELECT COUNT (prod_id) FROM sales WHERE quantity_sold > 55000 GROUP BY
• E.BY COUNT(*) >10;
  SELECT COUNT(prod_id) FROM sales GROUP BY prod_id WHERE quantity_sold > 55000;

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the PROGRAMS table:

Which two SQL statements would execute successfully?

• A.SELECT NVL (TO_CHAR (MONTHS_BETWEEN (start-date, end_date)), 'Ongoing') FROM programs
• B.SELECT NVL (ADD_MONTHS (END_DATE,1) SYSDATE) FROM programs;
• C.SELECT NVL (MONTHS_BETWEEN (start_date, end_date), 'Ongoing') FROM programs;
• D.SELECT TO_DATE (NVL (SYSDATE-END_DATE, SYSDATE)) FROM programs;

Comment: *

Name: *

Email: *

Verification: *