Oracle 1Z0-060 Study Guides 2021

NEW QUESTION 1
In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20.
Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?

• A. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
• B. Setting the target tablespace to read-only
• C. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
• D. Setting the target tablespace offline
• E. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

Answer: BC

NEW QUESTION 2
You run a script that completes successfully using SQL*Plus that performs these actions:
1.Creates a multitenant container database (CDB)
2.Plugs in three pluggable databases (PDBs)
3.Shuts down the CDB instance
4.Starts up the CDB instance using STARTUP OPEN READ WRITE Which two statements are true about the outcome after running the script?

• A. The seed will be in mount state.
• B. The seed will be opened read-only.
• C. The seed will be opened read/write.
• D. The other PDBs will be in mount state.
• E. The other PDBs will be opened read-only.
• F. The PDBs will be opened read/write.

Answer: BD

NEW QUESTION 3
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 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
Which three statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled In UNIX?

• A. Thread creation must be routed through a dispatcher process
• B. The local listener may spawn a now process and have that new process create a thread
• C. Each Oracle process runs an SCMN threa
• D. Each multithreaded Oracle process has an SCMN threa
• E. The local listener may pass the request to an existing process which in turn will create a threa

Answer: ADE

NEW QUESTION 6
Which statement is true about Oracle Net Listener?

• A. It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.
• B. A single listener can service only one database instance and multiple remote client connections.
• C. Service registration with the listener is performed by the process monitor (LREG) process of each database instance.
• D. The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.
• E. The listener.ora configuration file must be located in the ORACLE_HOME/network/admin directly.

Answer: C

NEW QUESTION 7
On your Oracle Database, you issue the following commands to create indexes:
SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE;
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id);
Which two statements are true?

• A. Only the ORD_CUSTOMER_IX1 index create
• B. Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.
• C. Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.
• D. The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.
• E. Both the indexes are created and used by the optimizer for queries on the ORDERS table.
• F. Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.

Answer: BF

NEW QUESTION 8
You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).
Examine the query and its output:

Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?

• A. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
• B. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
• C. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.
• D. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.
• E. Re-create the password file in the Oracle Database 12c format.

Answer: BD

NEW QUESTION 9
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 10
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 11
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 12
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 13
Which two statements are true about the Oracle Direct Network File system (DNFS)?

• A. It utilizes the OS file system cache.
• B. A traditional NFS mount is not required when using Direct NFS.
• C. Oracle Disk Manager can manage NFS on its own, without using the operating kernel NFS driver.
• D. Direct NFS is available only in UNIX platforms.
• E. Direct NFS can load-balance I/O traffic across multiple network adapters.

Answer: CE

NEW QUESTION 14
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 15
Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyze impact on the performance of SQL statements.

• A. Change in the Oracle Database version
• B. Change in your network infrastructure
• C. Change in the hardware configuration of the database server
• D. Migration of database storage from non-ASM to ASM storage
• E. Database and operating system upgrade

Answer: ACE

NEW QUESTION 16
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 17
Examine the commands executed to monitor database operations:
$> conn sys oracle/oracle@prod as sysdba
SQL > VAR eid NUMBER
SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING => ‘Y’);
Which two statements are true?

• A. Database operations will be monitored only when they consume a significant amount of resource.
• B. Database operations for all sessions will be monitore
• C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.
• D. Only DML and DDL statements will be monitored for the session.
• E. All subsequent statements in the session will be treated as one database operation and will be monitore

Answer: CE

NEW QUESTION 18
You plan to migrate your database from a File system to Automata Storage Management (ASM) on same platform.
Which two methods or commands would you use to accomplish this task?

• A. RMAN CONVERT command
• B. Data Pump Export and import
• C. Conventional Export and Import
• D. The BACKUP AS COPY DATABASE . . . command of RMAN
• E. DBMS_FILE_TRANSFER with transportable tablespace

Answer: AD

NEW QUESTION 19
Identify three valid methods of opening, pluggable databases (PDBs).

• A. ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the root
• B. ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a PDB
• C. ALTER PLUGGABLE DATABASE PDB OPEN issued from the seed
• D. ALTER DATABASE PDB OPEN issued from the root
• E. ALTER DATABASE OPEN issued from that PDB
• F. ALTER PLUGGABLE DATABASE PDB OPEN issued from another PDB
• G. ALTER PLUGGABLE DATABASE OPEN issued from that PDB

Answer: AEG