Oracle 1Z0-060 Dumps 2021

NEW QUESTION 1
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 2
You find this query being used in your Oracle 12c database:

Which method a used by the optimizer to limit the rows being returned?

• A. A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows
• B. All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.
• C. A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.
• D. A TOP-N query is created to limit the rows to 20 percent of the total rows

Answer: C

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
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 5
Which three statements are true about Automatic Workload Repository (AWR)?

• A. All AWR tables belong to the SYSTEM schem
• B. The AWR data is stored in memory and in the database.
• C. The snapshots collected by AWR are used by the self-tuning components in the database
• D. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.
• E. AWR contains system wide tracing and logging information.

Answer: CDE

NEW QUESTION 6
The persistent configuration settings for RMAN have default for all parameters. Identify four RMAN commands that produce a multi-section backup.

• A. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;
• B. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;
• C. BACKUP ARCHIVELOG ALL SECTION SIZE 25M;
• D. BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;
• E. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;
• F. BACKUP SPFILE SECTION SIZE 1M;
• G. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

Answer: ABEG

NEW QUESTION 7
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

NEW QUESTION 8
Which three statements are true concerning unplugging a pluggable database (PDB)?

• A. The PDB must be open in read only mode.
• B. The PDB must be dose
• C. The unplugged PDB becomes a non-CD
• D. The unplugged PDB can be plugged into the same multitenant container database (CDB)
• E. The unplugged PDB can be plugged into another CD
• F. The PDB data files are automatically removed from disk.

Answer: ADE

NEW QUESTION 9
You configure your database Instance to support shared server connections.
Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?

• A. User session data
• B. Stack space
• C. Private SQL area
• D. Location of the runtime area for DML and DDL Statements
• E. Location of a part of the runtime area for SELECT statements

Answer: AC

NEW QUESTION 10
You executed a DROP USER CASCADE on an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA. EXAM_RESULTS table to the OCP schema.
The RECYCLE_BIN enabled before the DROP USER was executed and the OCP user has been granted the FLASHBACK ANY TABLE system privilege.
What is the quickest way to recover the contents of the OCA. EXAM_RESULTS table to the OCP schema?

• A. Execute FLASHBACK TABLE OC
• B. EXAM_RESULTS TO BEFORE DROP RENAME TO OCP.EXAM_RESULTS; connected as SYSTEM.
• C. Recover the table using traditional Tablespace Point In Time Recovery.
• D. Recover the table using Automated Tablespace Point In Time Recovery.
• E. Recovery the table using Database Point In Time Recovery.
• F. Execute FLASHBACK TABLE OC
• G. EXAM_RESULTS TO BEFORE DROP RENAME TO EXAM_RESULTS; connected as the OCP user.

Answer: C

NEW QUESTION 11
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 12
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 13
A new report process containing a complex query is written, with high impact on the database. You want to collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests.
For the database instance STATISTICS_LEVEL, the initialization parameter is set to
TYPICAL and the CONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.
What should you do to accomplish this task?

• A. Execute the query and view Active Session History (ASH) for information about the query.
• B. Enable SQL trace for the query.
• C. Create a database operation, execute the query, and use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the report.
• D. Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.

Answer: C

NEW QUESTION 14
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 15
You use a recovery catalog for maintaining your database backups.
You execute the following command:
$rman TARGET / CATALOG rman / cat@catdb
RMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;
Which two statements are true?

• A. Corrupted blocks, if any, are repaire
• B. Checks are performed for physical corruptions.
• C. Checks are performed for logical corruptions.
• D. Checks are performed to confirm whether all database files exist in correct locations
• E. Backup sets containing both data files and archive logs are create

Answer: BD

NEW QUESTION 16
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 17
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 18
You are administering a database and you receive a requirement to apply the following restrictions:
1.A connection must be terminated after four unsuccessful login attempts by user.
2.A user should not be able to create more than four simultaneous sessions.
3.User session must be terminated after 15 minutes of inactivity.
4.Users must be prompted to change their passwords every 15 days. How would you accomplish these requirements?

• A. by granting a secure application role to the users
• B. by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to FALSE
• C. By creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4
• D. By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE.
• E. By implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.

Answer: C