A container database called CDB1is OMF-enabled.
PDB_FILE_NAME_CONVERTis not configured in CDB1.
PDB1was unplugged from CDB1earlier in the week.
Examine this command, which will be executed in CDB1:
CREATE PLUGGABLE DATABASE pdb1
USING '/u01/app/oracle/oradata/pdb1.xml'
SOURCE_FILE_NAME_CONVERT
('/u01/app/oracle/oradata/', '/u02/app/oracle/oradata/');
Which two are true? (Choose two.)

• A.PDB1 data files already exist in the correct location.
• B.DBMS_PDB.CHECK_PLUG_COMPATIBILITYmust be run in CDB1before executing the command.
• C.PDB_FILE_NAME_CONVERTmust be set before executing the command.
• D./u01/app/oracle/oradata/pdb1.xmldoes not contain the current locations of data files for PDB1.
• E.PDB1 must be dropped from CDB1.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about the tools for diagnosing Oracle Database failure situations? (Choose three.)

• A.RMAN can always repair corrupt blocks.
• B.Flashback commands help with repairing physical errors.
• C.The ADR command-line utility (ADRCI) can package incident information to send to Oracle Support.
• D.The Data Recovery Advisor uses the ADR.
• E.The ADR can store metadata in an Oracle Database repository.
• F.The Automatic Diagnostic Repository (ADR) has a separate home directory for each instance of each Oracle product that is installed and uses it.

Comment: *

Name: *

Email: *

Verification: *

Which two are true in Oracle 19c and later releases?

• A.Schema Only accounts can be granted administrator privileges.
• B.Unified Auditing can be configured to audit only events that are issued directly by an audited user.
• C.If the password file location changes, then the new location is used automatically by the Oracle Server.
• D.Unified Auditing can be configured to audit only events that are issued indirectly by an audited user.
• E.All the Oracle-supplied accounts are Schema Only accounts.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about Oracle Grid Infrastructure for a Standalone Server? (Choose two.)

• A.It can manage database resources on the server where it is installed or on a different server.
• B.It requires Oracle Automatic Storage Management (ASM) components to be installed separately.
• C.It must be installed before the Oracle database software is installed.
• D.The CSS daemon runs from the Grid Infrastructure home.
• E.It supports volume management, file system, and automatic restart capabilities.

Comment: *

Name: *

Email: *

Verification: *

The USERS tablespace consists of data files 3 and 4 and must always be online in read/write mode.
Which two are true about using RMAN to perform an open database back up of this tablespace? (Choose two.)

• A.Backups can be done incrementally.
• B.Only consistent backups can be created.
• C.Backups must be done incrementally.
• D.Backups must be contained in backup sets.
• E.Backups can be taken only if the database is in ARCHIVELOG mode.
• F.The database must be registered in an RMAN catalog.

Comment: *

Name: *

Email: *

Verification: *