Highest Quality 1Z0-060 Exam Questions and Answers 2021

NEW QUESTION 1
You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name.
Which statement is true?

• A. The ORACLE_BASE base parameter is not set.
• B. The installation is being performed by the root user.
• C. The operating system group that is specified should have the root user as its member.
• D. The operating system group that is specified must have permission to write to the inventory directory.

Answer: D

NEW QUESTION 2
You notice that the performance of your production 24/7 Oracle database significantly degradeD. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance.
How can you detect the cause of the degraded performance?

• A. Enable Memory Access Mode, which reads performance data from SG
• B. Use emergency monitoring to fetch data directly from SGA analysis.
• C. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.
• D. Use Active Session History (ASH) data and hang analysis in regular performance monitoring.
• E. Run ADDM in diagnostic mode.

Answer: B

NEW QUESTION 3
In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.
How would you accomplish this?

• A. Setting a metric threshold
• B. Implementing Database Resource Manager
• C. Enabling resumable timeout for user sessions
• D. Decreasing the value of the IDLE_TIME resource limit in the default profile

Answer: D

NEW QUESTION 4
Which two are prerequisites for performing a flashback transaction?

• A. Flashback Database must be enable
• B. Undo retention guarantee for the database must be configure
• C. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
• D. Supplemental logging must be enable
• E. Recycle bin must be enabled for the database.
• F. Block change tracking must be enabled tor the database.

Answer: CD

NEW QUESTION 5
Identify two correct statements about multitenant architectures.

• A. Multitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration.
• B. Multiple pluggable databases (PDBs) share certain multitenant container database (CDB) resources.
• C. Multiple CDBs share certain PDB resources.
• D. Multiple non-RAC CDB instances can mount the same PDB as long as they are on the same server.
• E. Patches are always applied at the CDB level.
• F. A PDB can have a private undo tablespace.

Answer: BE

NEW QUESTION 6
You must track all transactions that modify certain tables in the sales schema for at least three years.
Automatic undo management is enabled for the database with a retention of one day.
Which two must you do to track the transactions?

• A. Enable supplemental logging for the database.
• B. Specify undo retention guarantee for the database.
• C. Create a Flashback Data Archive in the tablespace where the tables are store
• D. Create a Flashback Data Archive in any suitable tablespace.
• E. Enable Flashback Data Archiving for the tables that require tracking.

Answer: DE

NEW QUESTION 7
You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privileges and execute the following sequence statements:

What is the result of the last SET CONTAINER statement and why is it so?

• A. It succeeds because the PDB_ADMIN user has the required privileges.
• B. It fails because common users are unable to use the SET CONTAINER statement.
• C. It fails because local users are unable to use the SET CONTAINER statement.
• D. If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).

Answer: C

NEW QUESTION 8
Which three statements are true about adaptive SQL plan management?

• A. It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.
• B. The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.
• C. It adds new, bettor plans automatically as fixed plans to the baseline.
• D. The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.
• E. The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generate

Answer: ADE

NEW QUESTION 9
You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container database (CDB).
The following are the possible steps to accomplish this task:
1.Place all the user-defined tablespace in read-only mode on the source database.
2.Upgrade the source database to a 12c version.
3.Create a new PDB in the target container database.
4.Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.
5.Copy the associated data files and export the dump file to the desired location in the target database.
6.Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.
7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.
Identify the correct order of the required steps.

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

Answer: C

NEW QUESTION 10
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 11
You enabled an audit policy by issuing the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;
For which database users and for which executions is the audit policy now active? Select two.

• A. SYS, SYSTEM
• B. SCOTT
• C. Only for successful executions
• D. Only for failed executions
• E. Both successful and failed executions

Answer: AE

NEW QUESTION 12
You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS table in the SH schema.
Examine the following steps:
1.Issue the SELECT DBMS_STATS.CREATE_EXTENDED_STATS (‘SH’, ‘CUSTOMERS’) FROM dual statement.
2.Execute the DBMS_STATS.SEED_COL_USAGE (null, ‘SH’, 500) procedure.
3.Execute the required queries on the CUSTOMERS table.
4.Issue the SELECT DBMS_STATS.REPORT_COL_USAGE (‘SH’, ‘CUSTOMERS’) FROM dual statement.
Identify the correct sequence of steps.

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

Answer: B

NEW QUESTION 13
Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance.
What should you use to achieve this?

• A. Database replay
• B. SQL Tuning Advisor
• C. SQL Access Advisor
• D. SQL Performance Analyzer
• E. Automatic Workload Repository compare reports

Answer: D

NEW QUESTION 14
You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces are created by default in HR_PDB?

• A. SYSTEM
• B. SYSAUX
• C. EXAMPLE
• D. UNDO
• E. TEMP
• F. USERS

Answer: ABE

NEW QUESTION 15
A senior DBA asked you to execute the following command to improve performance: SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle);
You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.
What could be a reason for this recommendation?

• A. The keep pool is not configure
• B. Automatic Workarea Management is not configure
• C. Automatic Shared Memory Management is not enable
• D. The data blocks in the SUBSCRIBE_LOG table are rarely accesse
• E. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view.

Answer: D

NEW QUESTION 16
You created a new database using the "create database" statement without specifying the "ENABLE PLUGGABLE" clause.
What are two effects of not using the "ENABLE PLUGGABLE database" clause?

• A. The database is created as a non-CDB and can never contain a PD
• B. The database is treated as a PDB and must be plugged into an existing multitenant container database (CDB).
• C. The database is created as a non-CDB and can never be plugged into a CD
• D. The database is created as a non-CDB but can be plugged into an existing CD
• E. The database is created as a non-CDB but will become a CDB whenever the first PDB is plugged in.

Answer: AD

NEW QUESTION 17
You created an encrypted tablespace:

You then closed the encryption wallet because you were advised that this is secure.
Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE
tablespace with the SALT option on the EMPLOYEE column.
Which is true about the result?

• A. It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the wallet must be opened to encrypt columns with SALT.
• B. It generates an error when creating the table because the wallet is close
• C. It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.
• D. It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.

Answer: B

NEW QUESTION 18
Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container:

Which two statements are true?

• A. Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.
• B. The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.
• C. The command will, create a common user whose description is contained in the root and each PD
• D. The schema for the common user C # # A_ADMIN can be different in each container.
• E. The command will create a user in the root container only because the container clause is not use

Answer: CD