1Z0-082 Exam Question 11

Examine the description of the CUSTOMERS table:

For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?
  • 1Z0-082 Exam Question 12

    View the Exhibit and examine the structure of the PRODUCTS table.
    Which two tasks require subqueries? (Choose two.)
  • 1Z0-082 Exam Question 13

    Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)
  • 1Z0-082 Exam Question 14

    Which two statements are true about the WHERE and HAVING clauses in a SELECT statement?
    (Choose two.)
  • 1Z0-082 Exam Question 15

    A database is configured to use automatic undo management with temporary undo enabled.
    An UPDATE is executed on a temporary table.
    Where is the UNDO stored?