Online Access Free 1z1-074 Practice Test

Which three statements are true about the SQL Performance Analyzer? (Choose three.)

• A.It always executes triggers that are fired recursively in FULLDML mode.
• B.It recommends the creation of indexes for regressed SQL statements.
• C.It compares and analyzes execution plans for the SQL statements in a SQL Tuning Set (STS).
• D.It recommends the use of SQL Tuning Advisor for regressed SQL statements.
• E.It generates execution plans for each SQL statement in an STS.

Which two operations is the opc user authorized to perform in an Oracle Database Cloud environment?
(Choose two.)

• A.Run some commands as root.
• B.Only run some commands as oracle.
• C.Only run all commands as oracle.
• D.Log in to the database deployment compute node.
• E.Run all commands as root.

Which two are true about tables recovered by using the RMAN RECOVER TABLE command or the command itself, starting from Oracle Database 12c Release 2? (Choose two.)

• A.An AUXILIARY instance is started only if there is sufficient disk space
• B.They can be recovered by RMAN without an AUXILIARY instance
• C.They may be recovered to a different schema in the same pluggable database (PDB)
• D.They must be un-partitioned tables
• E.They may be recovered to a schema in a different PDB

Which two statements are true about FLEX ASM? (Choose two.)

• A.A separate ASM network is required.
• B.A database instance on any node can connect to an ASM instance on any node.
• C.It is impossible to connect to a database instance on one node if the database password file for the same database is corrupt on another node in the cluster.
• D.Database instances that depend on an ASM instance that is terminated fail over to a node that has a surviving ASM instance.
• E.Database instances that depend on an ASM instance that is terminated connect to a surviving ASM instance.

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 collects new diagnostic data if the Max Size of TFA Log parameter value is greater than 5 G
• B.TFA collects new diagnostic data while the repository directory's file system has free space.
• C.TFA collects new diagnostic data but logs a warning message.
• D.The tfact1 command fails because it can be set only by the Oracle software owner.
• E.TFA does not collect new diagnostic data when the maximum repository size is reached.