Question 111

You upgrade your Oracle database in a multiprocessor environment. As a recommended best practice, you execute the following script:
SQL > @utlrp.sql
Which two actions does the script perform? (Choose two.)
  • Question 112

    You created an encrypted tablespace:

    You then closed the encryption wallet because you were advised that this is secure.
    Later in the day, you attempt to create the EMPLOYEEStable in the SECURESPACEtablespace with the SALT option on the EMPLOYEEcolumn.
    Which is true about the result?
  • Question 113

    You must track all transactions that modify certain tables in the sales schema for at least
    three years.
    Automatic undo management is enabled for the database with a retention of one day.
    Which two must you do to track the transactions?
  • Question 114

    Examine the commands executed to monitor database operations:
    $> conn sys oracle/oracle@prod as sysdba
    SQL > VAR eid NUMBER
    SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION ('batch_job' , FORCED_TRACKING => 'Y');
    Which two statements are true?
  • Question 115

    You Execute the Following command to create a password file in the database server:
    $ orapwd file = '+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12'
    Which two statements are true about the password file?