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.)
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?

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?
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?
$> 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?
$ orapwd file = '+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12'
Which two statements are true about the password file?