Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

• A.By default, EM express is available for a database after database creation.
• B.You can use EM express to manage multiple databases running on the same server.
• C.You can perform basic administrative tasks for pluggable databases by using the EM express interface.
• D.You cannot start up or shut down a database Instance by using EM express.
• E.You can create and configure pluggable databases by using EM express.

Comment: *

Name: *

Email: *

Verification: *

Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.
You want to Issue the following RMAN command:
RMAN > BACKUP TABLESPACE hr_pdb:userdata;
Which task should you perform before issuing the command?

• A.Place the root container in ARHCHIVELOG mode.
• B.Take the user data tablespace offline.
• C.Place the root container in the nomount stage.
• D.Ensure that HR_PDB is open.

Comment: *

Name: *

Email: *

Verification: *

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?

• A.Enable supplemental logging for the database.
• B.Specify undo retention guarantee for the database.
• C.Create a Flashback Data Archive in the tablespace where the tables are stored.
• D.Create a Flashback Data Archive in any suitable tablespace.
• E.Enable Flashback Data Archiving for the tables that require tracking.

Comment: *

Name: *

Email: *

Verification: *

You database is running an ARCHIVELOG mode.
The following parameter are set in your database instance: LOG_ARCHIVE_FORMAT = arch+%t_%r.arc LOG_ARCHIVE_DEST_1 = 'LOCATION = /disk1/archive' DB_RECOVERY_FILE_DEST_SIZE = 50G DB_RECOVERY_FILE = '/u01/oradata'
Which statement is true about the archived redo log files?

• A.They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.
• B.They are created only in the Fast Recovery Area.
• C.They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.
• D.They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.

Comment: *

Name: *

Email: *

Verification: *

In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure:
CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename VARCHAR2, v_SALARY NUMBER, v_dept_id NUMBER)
BEGIN
INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id); END;
/
GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king;
How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into tables on which they do not have any privileges?

• A.Create the CREATE_TEST procedure with definer's rights.
• B.Grant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure.
• C.Create the CREATE_TEST procedure with invoker's rights.
• D.Create the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege the package.

Comment: *

Name: *

Email: *

Verification: *