Download 1Z0-060 Braindumps 2021

NEW QUESTION 1
Which three actions are possible during an Online Data file Move operation?

• A. Creating and dropping tables in the data file being moved
• B. Performing file shrink of the data file being moved
• C. Querying tables in the data file being moved
• D. Performing Block Media Recovery for a data block in the data file being moved
• E. Flashing back the database
• F. Executing DML statements on objects stored in the data file being moved

Answer: ACF

NEW QUESTION 2
You notice a performance change in your production Oracle database and you want to know which change has made this performance difference.
You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.
Which three findings would you get from the report?

• A. It detects any configuration change that caused a performance difference in both time periods.
• B. It identifies any workload change that caused a performance difference in both time periods.
• C. It detects the top wait events causing performance degradation.
• D. It shows the resource usage for CPU, memory, and I/O in both time periods.
• E. It shows the difference in the size of memory pools in both time periods.
• F. It gives information about statistics collection in both time periods.

Answer: ABD

NEW QUESTION 3
Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):

Which three are prerequisites for successful execution of the command?

• A. The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXD_FULL_DATABASE role.
• B. All the user-defined tablespaces must be in read-only mode on the source database.
• C. The export dump file must be created before starting the import on the target database.
• D. The source and target database must be running on the same platform with the same endianness.
• E. The path of data files on the target database must be the same as that on the source database.
• F. The impdp operation must be performed by the same user that performed the expdp operation.

Answer: ABD

NEW QUESTION 4
You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.
In which three ways can you re-create the lost disk group and restore the data?

• A. Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the dat
• B. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.
• C. Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the dat
• D. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the dat
• E. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.
• F. Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the dat

Answer: CDF

NEW QUESTION 5
Which two statements are true about variable extent size support for large ASM files?

• A. The metadata used to track extents in SGA is reduce
• B. Rebalance operations are completed faster than with a fixed extent size
• C. An ASM Instance automatically allocates an appropriate extent size.
• D. Resync operations are completed faster when a disk comes online after being taken offline.
• E. Performance improves in a stretch cluster configuration by reading from a local copy of an extent.

Answer: AC

NEW QUESTION 6
The following parameter are set for your Oracle 12c database instance:
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
You want to manage the SQL plan evolution task manually. Examine the following steps:
1. Set the evolve task parameters.
2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function.
3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.
4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.
5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function. Identify the correct sequence of steps:

• A. 2, 4, 5
• B. 2, 1, 4, 3, 5
• C. 1, 2, 3, 4, 5
• D. 1, 2, 4, 5

Answer: B

NEW QUESTION 7
Examine these two statements:

Which three are true about the MRKT tablespace?

• A. The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.
• B. The MRKT tablespace may be dropped if it has no contents.
• C. Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.
• D. No more data files can be added to the tablespace.
• E. The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.

Answer: CDE

NEW QUESTION 8
Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:

What are three possible causes for the latch-related wait events?

• A. The size of the shared pool is too small.
• B. Cursors are not being share
• C. A large number COMMITS are being performe
• D. There are frequent logons and logoffs.
• E. The buffers are being read into the buffer cache, but some other session is changing the buffers.

Answer: ABE

NEW QUESTION 9
Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command:
SQL > exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (‘SRV1’);
The possible outcome and actions to aggregate the trace files are as follows:
1.The command fails because a module name is not specified.
2.A trace file is created for each session that is running the SRV1 service.
3.An aggregated trace file is created for all the sessions that are running the SRV1 service.
4.The trace files may be aggregated by using the trcess utility.
5.The trace files be aggregated by using the tkprof utility.
Identify the correct outcome and the step to aggregate by using tkprof utility?

• A. 1
• B. 2 and 4
• C. 2 and 5
• D. 3 and 4
• E. 3 and 5

Answer: B

NEW QUESTION 10
What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?

• A. Effectively implements role separation
• B. Enables you to take advantage of Oracle Managed Files.
• C. Automatically registers the database with Oracle Restart.
• D. Helps you to easily upgrade the database from a prior release.
• E. Enables the Installation of Grid Infrastructure files on block or raw devices.

Answer: CE

NEW QUESTION 11
To implement Automatic Management (AMM), you set the following parameters:

When you try to start the database instance with these parameter settings, you receive the following error message:
SQL > startup
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.
Identify the reason the instance failed to start.

• A. The PGA_AGGREGATE_TARGET parameter is set to zero.
• B. The STATISTICS_LEVEL parameter is set to BASI
• C. Both the SGA_TARGET and MEMORY_TARGET parameters are set.
• D. The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.

Answer: B

NEW QUESTION 12
In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation.
How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?

• A. It collects data from SGA and compares it with a preserved snapshot.
• B. It collects data from SGA, analyzes it, and provides a report.
• C. It collects data from SGA and compares it with the latest snapshot.
• D. It collects data from both SGA and PGA, analyzes it, and provides a report.

Answer: B

NEW QUESTION 13
You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege.
The CDB has several pluggable databases (PDBs) open in the read/write mode. There are ongoing transactions in both the CDB and PDBs.
What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?

• A. The shutdown proceeds immediately.The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolled hack.
• B. The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.
• C. The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.
• D. The statement results in an error because there are open PDBs.

Answer: B

NEW QUESTION 14
Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.
Which two RMAN commands may be; used to back up only the PDB1 pluggable database?

• A. BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container
• B. BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container
• C. BACKUP DATABASE while connected to the PDB1 container
• D. BACKUP DATABASE while connected to the boot container
• E. BACKUP PLUGGABLE database PDB1 while connected to PDB2

Answer: AC

NEW QUESTION 15
Examine the parameter for your database instance:

You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan:

Identify the reason why the optimizer chose different execution plans.

• A. The optimizer used a dynamic plan for the query.
• B. The optimizer chose different plans because automatic dynamic sampling was enable
• C. The optimizer used re-optimization cardinality feedback for the query.
• D. The optimizer chose different plan because extended statistics were created for the columns use

Answer: B

NEW QUESTION 16
Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

• A. Reduced logical I/O
• B. Reduced virtual memory utilization
• C. Improved parallel Execution performance
• D. Improved Serial Execution performance
• E. Reduced physical I/O
• F. Reduced CPU utilization

Answer: BCF

NEW QUESTION 17
Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:
1.Create a policy to capture the privilege used by a user for privilege analysis.
2.Generate a report with the data captured for a specified privilege capture.
3.Start analyzing the data captured by the policy.
4.Revoke the unused privileges.
5.Compare the used and unused privileges’ lists.
6.Stop analyzing the data.
Identify the correct sequence of steps.

• A. 1, 3, 5, 6, 2, 4
• B. 1, 3, 6, 2, 5, 4
• C. 1, 3, 2, 5, 6, 4
• D. 1, 3, 2, 5, 6, 4
• E. 1, 3, 5, 2, 6, 4

Answer: B

NEW QUESTION 18
Which three functions are performed by the SQL Tuning Advisor?

• A. Building and implementing SQL profiles
• B. Recommending the optimization of materialized views
• C. Checking query objects for missing and stale statistics
• D. Recommending bitmap, function-based, and B-tree indexes
• E. Recommending the restructuring of SQL queries that are using bad plans

Answer: ACE

NEW QUESTION 19
Examine this command:
SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’,
‘false’);
Which three statements are true about the effect of this command?

• A. Statistics collection is not done for the CUSTOMERS table when schema stats are gathere
• B. Statistics collection is not done for the CUSTOMERS table when database stats are gathere
• C. Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.
• D. Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.
• E. Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.

Answer: CDE