Question 71

Which two statements are true about the DUAL table? (Choose two.)
  • Question 72

    Examine the description of the SALES1 table:

    SALES2 is a table with the same description as SALES1.
    Some sales data is duplicated in both tables.
    You want to display the rows from the SALES1 table which are not present in the SALES2 table.
    Which set operator generates the required output?
  • Question 73

    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 74

    In one of your databases, user KING is:
    1. Not a DBA user
    2. An operating system (OS) user
    Examine this command and its output:

    What must you do so that KING is authenticated by the OS when connecting to the database instance?
  • Question 75

    You have been tasked to create a table for a banking application.
    One of the columns must meet three requirements:
    1. Be stored in a format supporting date arithmetic without using conversion functions
    2. Store a loan period of up to 10 years
    3. Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?