Printable 1Z0-060 Dumps Questions 2021

NEW QUESTION 1
You are connected to a pluggable database (PDB) as a common user with DBA privileges. The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:
SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE;
Which is true about the result of this command?

• A. The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opene
• B. The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopene
• C. The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarte
• D. Nothing happens; because there is no SPFILE for each PDB, the statement is ignore

Answer: A

NEW QUESTION 2
After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows:

After changing the value, you notice that FULL redaction continues to redact numeric data with zero.
What must you do to activate the new default value for numeric full redaction?

• A. Re-enable redaction policies that use FULL data redaction.
• B. Re-create redaction policies that use FULL data redaction.
• C. Re-connect the sessions that access objects with redaction policies defined on them.
• D. Flush the shared pool.
• E. Restart the database instance.

Answer: E

NEW QUESTION 3
Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command:
SQL > CREATE UNDO TABLESPACE undotb01
DATAFILE ‘u01/oracle/rddb1/undotbs01.dbf’ SIZE 60M AUTOEXTEND ON;
What is the result?

• A. It executes successfully and creates an UNDO tablespace in HR_PD
• B. It falls and reports an error because there can be only one undo tablespace in a CD
• C. It fails and reports an error because the CONTAINER=ALL clause is not specified in the comman
• D. It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the comman
• E. It executes successfully but neither tablespace nor the data file is create

Answer: E

NEW QUESTION 4
Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container.
The steps to recover the tablespace are as follows:
\1.Mount the CDB.
\2.Close all the PDBs.
\3.Open the database.
\4.Apply the archive redo logs.
\5.Restore the data file.
\6.Take the SYSAUX tablespace offline.
\7.Place the SYSAUX tablespace online.
\8.Open all the PDBs with RESETLOGS.
\9.Open the database with RESETLOGS.
\10.Execute the command SHUTDOWN ABORT.
Which option identifies the correct sequence to recover the SYSAUX tablespace?

• A. 6, 5, 4, 7
• B. 10, 1, 2, 5, 8
• C. 10, 1, 2, 5, 4, 9, 8
• D. 10, 1, 5, 8, 10

Answer: A

NEW QUESTION 5
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 6
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 7
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 8
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 9
Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache.
What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?

• A. Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.
• B. Run the Automatic Workload Repository Monitor (ADDM).
• C. Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.
• D. Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.

Answer: D

NEW QUESTION 10
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 11
Examine the following parameters for a database instance:
MEMORY_MAX_TARGET=0
MEMORY_TARGET=0
SGA_TARGET=0
PGA_AGGREGATE_TARGET=500m
Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?

• A. LOG_BUFFER
• B. SORT_AREA_SIZE
• C. JAVA_POOL_SIZE
• D. STREAMS_POOL_SIZE
• E. DB_16K_CACHE_SZIE
• F. DB_KEEP_CACHE_SIZE

Answer: AEF

NEW QUESTION 12
In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database?
Both local and global partitioned B-tree Indexes are defined on the table.
A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends.
Minimal disrupt ion to availability is required.
Which three statements are true about this requirement?

• A. The partitions can be moved online to new tablespaces.
• B. Global indexes must be rebuilt manually after moving the partitions.
• C. The partitions can be compressed in the same tablespaces.
• D. The partitions can be compressed in the new tablespaces.
• E. Local indexes must be rebuilt manually after moving the partitions.

Answer: ACD

NEW QUESTION 13
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 14
Examine the current value for the following parameters in your database instance:
SGA_MAX_SIZE = 1024M
SGA_TARGET = 700M
DB_8K_CACHE_SIZE = 124M
LOG_BUFFER = 200M
You issue the following command to increase the value of DB_8K_CACHE_SIZE:
SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;
Which statement is true?

• A. It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.
• B. It succeeds only if memory is available from the autotuned components if SG
• C. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.
• D. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.

Answer: D

NEW QUESTION 15
You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB).
The characteristics of the non-CDB are as follows:
✑ Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit
✑ Character set: AL32UTF8
✑ National character set: AL16UTF16
✑ O/S: Oracle Linux 6 64-bit
The characteristics of the CDB are as follows:
✑ Version: Oracle Database 12c Release 1 64-bit
✑ Character Set: AL32UTF8
✑ National character set: AL16UTF16
✑ O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?

• A. Transportable database
• B. Transportable tablespace
• C. Data Pump full export/import
• D. The DBMS_PDB packageE.RMAN

Answer: B

NEW QUESTION 16
Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called temp01.tmp.
A user issues a query on a table on one of the PDBs and receives the following error: ERROR at line 1:
ORA-01565: error in identifying file ‘/u01/app/oracle/oradata/CDB1/temp01.tmp’
ORA-27037: unable to obtain file status
Identify two ways to rectify the error.

• A. Add a new temp file to the temporary tablespace and drop the temp file that that produced the error.
• B. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.
• C. Take the temporary tablespace offline, recover the missing temp file by applying redo logs, and then bring the temporary tablespace online.
• D. Shutdown the database instance, restore and recover the temp file from the backup, and then open the database with RESETLOGS.
• E. Shut down the database instance and then restart the CDB and PDBs.

Answer: AE

NEW QUESTION 17
You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.
You plan to create the database using SQL statements.
Which three techniques can you use to achieve this?

• A. Use Oracle Managed Files (OMF).
• B. Specify the SEED FILE_NAME_CONVERT clause.
• C. Specify the PDB_FILE_NAME_CONVERT initialization parameter.
• D. Specify the DB_FILE_NAMECONVERT initialization parameter.
• E. Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).

Answer: ABC

NEW QUESTION 18
Which three activities are supported by the Data Recovery Advisor?

• A. Advising on block checksum failures
• B. Advising on inaccessible control files
• C. Advising on inaccessible block change tracking files
• D. Advising on empty password files
• E. Advising on invalid block header field values

Answer: ABE

NEW QUESTION 19
You execute the following PL/SQL:

Which two statements are true?

• A. Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accesse
• B. FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accesse
• C. FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.
• D. FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.

Answer: AD

NEW QUESTION 20
Which three statements are true about Oracle Data Pump export and import operations?

• A. You can detach from a data pump export job and reattach later.
• B. Data pump uses parallel execution server processes to implement parallel import.
• C. Data pump import requires the import file to be in a directory owned by the oracle owner.
• D. The master table is the last object to be exported by the data pump.
• E. You can detach from a data pump import job and reattach later.

Answer: ADE