Oracle 1z0-074 問題集

質問 1：
While performing a cross-platform PDB transport in an Oracle Database 12c Release 2 database, by using XTTS from a Linux (x86-64) server to a Solaris (x86-64) server, this command is executed to back up the files in a compatible format:

What will be the outcome?
A. It successfully completes.
B. The backup fails because the UNPLUG operation for cross-endian platforms is not supported.
C. It creates the /tmp/pdb_orcl.xml file, which contains the metadata and data of the source database.
D. It successfully takes a backup but the UNPLUG operation of PDB_ORCL fails.
E. It creates a backupset of the source database in the /home/oracle/backup directory
正解：E

質問 2：
You create and enable a unified audit policy on a database that has the default auditing configuration.

The OE user, who has the DBA role, executes these statements.

What is true about the SELECT statement and why?
A. It is not audited because audit records are stored only when unified auditing is enabled in the database.
B. It is audited because unified auditing is disabled be default.
C. It is audited because, by default, the database is in mixed auditing mode with default policies enabled.
D. It is audited because, by default, all user activities in the database are audited.
E. It is not audited because the table belongs to another schema.
正解：D

質問 3：
You plan to use Information Lifecycle Management (ILM) for the ORDERS table.
Which is true about Heat Map statistics when HEAT_MAP is ON?
A. They are collected only for the ORDERS table if it has an associated ADO policy.
B. They are collected for all segments and are stored in the SYSAUX tablespace.
C. They are collected for all segments except for those in the SYSTEM and SYSAUX tablespaces, and are stored in the SYSTEM tablespace.
D. They are collected for all segments and are stored in the SYSTEM tablespace.
E. They are collected for all segments except for those in the SYSTEM and SYSAUX tablespaces, and are stored in the SYSAUX tablespace.
正解：D

質問 4：
In your CDB1 container database, the DB_CREATE_FILE_DEST parameter is set to
'/u01/app/oracle/oradata'.
CDB1 has an application container called REGIONS_APP.
There are no seeds for REGIONS_APP and there are no other application containers.
You plan to execute this command.
CREATE PLUGGABLE DATABASE AS SEED ADMIN USER seed_adm IDENTIFIED BY admin_123; What must you do for the command to execute successfully?
A. Set the current container to CDB1
B. Add the FILE_NAME_CONVERT clause to the command
C. Add the CREATE_FILE_DEST clause to the command
D. Set the current container to REGIONS_APP
E. Set the PDB_FILE_NAME_CONVERT parameter to '/u01/app/oracle/oradata'
正解：E

質問 5：
You set the maximum size of the diagnostic collection repository by issuing this command as root.tfact1 set reposizeMB=5120 You then notice that the current repository size is 5 GB and that old files are not being purged.
Which statement is true?
A. TFA does not collect new diagnostic data when the maximum repository size is reached.
B. TFA collects new diagnostic data while the repository directory's file system has free space.
C. The tfact1 command fails because it can be set only by the Oracle software owner.
D. TFA collects new diagnostic data but logs a warning message.
E. TFA collects new diagnostic data if the Max Size of TFA Log parameter value is greater than 5 G
正解：C

質問 6：
You execute this command in your database:
ALTER SYSTEM SET ENCRYPT_NEW_TABLESPACES = DDL;
How does this affect the creation of tablespaces?
A. User tablespaces with no ENCRYPTION clause specified in the CREATE TABLESPACE statement are transparently encrypted with AES128 only in an on-premise database.
B. TEMP and UNDO tablespaces are transparently encrypted with AES128 by default only in the cloud.
C. User tablespaces with no ENCRYPTION clause specified in the CREATE TABLESPACE statement are transparently encrypted with AES128 only in the cloud.
D. User tablespaces with no ENCRYPTION clause specified in the CREATE TABLESPACE statement are not encrypted anywhere.
E. TEMP and UNDO tablespaces are transparently encrypted with AES128 by default in an on-premise database.
正解：B

質問 7：
Which method can be used to migrate from an on-premises Oracle Database 11g to Oracle Database 12c in the cloud if the on-premises platform is big-endian?
A. Data Pump Conventional Export/Import
B. RMAN Transportable Tablespace with Data Pump for all tablespaces
C. remote cloning
D. Data Pump Transportable Tablespace for all tablespaces
E. Oracle Loader-type external tables
正解：B