Question 11

You want to apply the principle of Least Privilege in all your live databases.
One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.
Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose three.)
  • Question 12

    Which two actions can you perform using DBCA for an existing database?
  • Question 13

    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:
    SELECT cust_last_name, cust_credit_limit FROM customers
    Which two where conditions give the required result?
    A)


    C)

    D)

    E)
  • Question 14

    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 15

    Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)