Oracle 1Z0-060 Dumps 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
Which two statement is true concerning dropping a pluggable database (PDB)?

• A. The PDB must be open in read-only mode.
• B. The PDB must be in mount state.
• C. The PDB must be unplugge
• D. The PDB data files are always removed from disk.
• E. A dropped PDB can never be plugged back into a multitenant container database (CDB).

Answer: CD

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 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 5
A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL:

There is enough free space in the disk group for mirroring to be done.
What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?

• A. Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.
• B. Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.
• C. The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiate
• D. ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.
• E. Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succee

Answer: B

NEW QUESTION 6
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 7
In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer.
Which statement is true?

• A. The CDB must be open.
• B. The CDB must be in the mount stage.
• C. The CDB must be in the nomount stage.
• D. Alt existing PDBs must be close

Answer: A

NEW QUESTION 8
In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You execute the following command from the root container:
SQL > REVOKE create table FROM C # # A_ADMIN;
What is the result?

• A. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.
• B. It fails and reports an error because the CONTAINER=ALL clause is not use
• C. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.
• D. It fails and reports an error because the CONTAINER=CURRENT clause is not use
• E. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.

Answer: A

NEW QUESTION 9
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 10
You execute the following commands to audit database activities:
SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE;
SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL;
Which statement is true about the audit record that generated when auditing after instance restarts?

• A. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.
• B. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.
• C. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.
• D. One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables use
• E. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command on a table, and contains the execution plan, SQL text, and bind variables use

Answer: D

NEW QUESTION 11
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 12
On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:
$> sqlldr hr/hr@pdb table=employees
Which two statements are true regarding the command?

• A. It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.
• B. It fails because no SQL *Loader data file location is specifie
• C. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.
• D. It fails because no SQL *Loader control file location is specifie

Answer: AC

NEW QUESTION 13
A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions
The table has a local prefixed, range partitioned index.
Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions.
This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month.
You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned.
Which three methods could transparently help to achieve this result?

• A. Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.
• B. Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
• C. Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.
• D. Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned column.
• E. Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.
• F. Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.

Answer: ACE

NEW QUESTION 14
Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column?

• A. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.
• B. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.
• C. All the components may be moved into SYSAUX tablespace.
• D. All the components may be moved from the SYSAUX tablespace.

Answer: AB

NEW QUESTION 15
Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database.
You issue the command to open ACCOUNTS_PDB and find that the USERDATA. DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupteD.
What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?

• A. Place CDB1 in the mount stage and then the USERDATA tablespace offline in ACCOUNTS_PD
• B. Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATE comman
• C. Issue the ALTER PLUGGABLE DATABASE accounts_pdb RESTRICTED comman
• D. Take the USERDATA tablespace offline in ACCOUNTS_PD

Answer: D

NEW QUESTION 16
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 17
Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace.
The table does not have a primary key and is used by an OLTP application.
Which technique will move the table and indexes while maintaining the highest level of availability to the application?

• A. Oracle Data Pump.
• B. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.
• C. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.
• D. Online Table Redefinition.
• E. Edition-Based Table Redefinition.

Answer: D

NEW QUESTION 18
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 19
Which three statements are true about Flashback Database?

• A. Flashback logs are written sequentially, and are archive
• B. Flashback Database uses a restored control file to recover a database.
• C. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Are
• D. Flashback Database can recover a database to the state that it was in before a reset logs operation.
• E. Flashback Database can recover a data file that was dropped during the span of time of the flashback.
• F. Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

Answer: CDF

NEW QUESTION 20
Which two statements are true about the RMAN validate database command?

• A. It checks the database for intrablock corruptions.
• B. It can detect corrupt pfiles.
• C. It can detect corrupt spfiles.
• D. It checks the database for interblock corruptions.
• E. It can detect corrupt block change tracking files.

Answer: AC