Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called temp01.tmp.
A user issues a query on a table on one of the PDBs and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file ‘/u01/app/oracle/oradata/CDB1/temp01.tmp’ ORA-27037: unable to obtain file status
Identify two ways to rectify the error.

• A.Add a new temp file to the temporary tablespace and drop the temp file that that produced the error.
• B.Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.
• C.Take the temporary tablespace offline, recover the missing temp file by applying redo logs, and then bring the temporary tablespace online.
• D.Shutdown the database instance, restore and recover the temp file from the backup, and then open the database with RESETLOGS.
• E.Shut down the database instance and then restart the CDB and PDBs.

Comment: *

Name: *

Email: *

Verification: *

Which Oracle Database component is audited by default if the unified Auditing option is enabled?

• A.Oracle Data Pump
• B.Oracle Recovery Manager (RMAN)
• C.Oracle Label Security
• D.Oracle Database Vault
• E.Oracle Real Application Security

Comment: *

Name: *

Email: *

Verification: *

You execute this command:

Which two statements are true about segment space management for segments in this tablespace? (Choose two.)

• A.Space utilization inside segments is mapped by bitmaps.
• B.The PCTFREE storage parameter has no effect on segments created in this tablespace.
• C.Segments are automatically shrunk and compressed when rows are deleted.
• D.The PCTUSED storage parameter has no effect on segments created in this tablespace.

Comment: *

Name: *

Email: *

Verification: *

You configure your database Instance to support shared server connections.
Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?

• A.User session data
• B.Stack space
• C.Private SQL area
• D.Location of the runtime area for DML and DDL Statements
• E.Location of a part of the runtime area for SELECT statements

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true concerning dropping a pluggable database (PDB)? (Choose two.)

• A.The PDB must be open in read-only mode.
• B.The PDB must be in mount state.
• C.The PDB must be unplugged.
• D.The PDB data files are always removed from disk.
• E.A dropped PDB can never be plugged back into a multitenant container database (CDB).

Comment: *

Name: *

Email: *

Verification: *