Question 6

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?
  • Question 7

    You execute this command:

    During the export operation, you detach from the job by using CTRL+C and then execute this command:
    Export> STOP_JOB=immediate
    Are you sure you wish to stop the job ([yes]/no): yes
    Which two statements are true about the job? (Choose two.)
  • Question 8

    Which three statements are true about sequences in a single instance Oracle database?
  • Question 9

    In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.
    The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

    Which statement is true?
  • Question 10

    In your data center, Oracle Managed Files (OMF) is used for all databases.
    All tablespaces are smallfile tablespaces.
    SALES_Q1 is a permanent user-defined tablespace in the SALES database.
    Examine this command which is about to be issued by a DBA logged in to the SALES database:
    ALTER TABLESPACE sales_q1 ADD DATAFILE;
    Which are two actions, either one of which you could take to ensure that the command executes successfully?
    (Choose two.)