1z0-062Free trialFree trial

By oracle
Aug, 2025

Verified

25Q per page

Question 1

Examine the parameters for your database instance:

Image 1

You execute the following command:
SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;
Which statement is true in this scenario?

  • A: Undo data is written to flashback logs after 1200 seconds.
  • B: Inactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lack of space in the undo tablespace.
  • C: You can perform a Flashback Database operation only within the duration of 1200 seconds.
  • D: An attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite the undo before that time has elapsed.
—

Question 2

Which two tasks can be performed on an external table? (Choose two.)

  • A: partitioning the table
  • B: creating an invisible index
  • C: updating the table by using an update statement
  • D: creating a public synonym
  • E: creating a view
—

Question 3

Examine the parameters for your database instance:

Image 1

Which three statements are true about the process of automatic optimization by using cardinality feedback? (Choose three.)

  • A: The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.
  • B: The optimizer can re optimize a query only once using cardinality feedback.
  • C: The optimizer enables monitoring for cardinality feedback after the first execution of a query.
  • D: The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.
  • E: After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.
—

Question 4

Which three statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled In
UNIX? (Choose three.)

  • 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 thread.
  • D: Each multithreaded Oracle process has an SCMN thread.
  • E: The local listener may pass the request to an existing process which in turn will create a thread.
—

Question 5

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

Image 1

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).
—

Question 6

Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:

Image 1

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 shared.
  • C: A large number COMMITS are being performed.
  • 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.
—

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
—

Question 8

A redaction policy was added to the SAL column of the SCOTT.EMP table:

Image 1

All users have their default set of system privileges.
For which three situations will data not be redacted? (Choose three.)

  • A: SYS sessions, regardless of the roles that are set in the session
  • B: SYSTEM sessions, regardless of the roles that are set in the session
  • C: SCOTT sessions, only if the MGR role is set in the session
  • D: SCOTT sessions, only if the MGR role is granted to SCOTT
  • E: SCOTT sessions, because he is the owner of the table
  • F: SYSTEM session, only if the MGR role is set in the session
—

Question 9

What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archiving enabled?

  • A: It fails with the ORA-665610 Invalid DDL statement on history-tracked message
  • B: The rows in the table are truncated without being archived.
  • C: The rows in the table are archived, and then truncated.
  • D: The rows in both the table and the archive are truncated.
—

Question 10

Which three statements are true about a job chain? (Choose three.)

  • A: It can contain a nested chain of jobs.
  • B: It can be used to implement dependency-based scheduling.
  • C: It cannot invoke the same program or nested chain in multiple steps in the chain.
  • D: It cannot have more than one dependency.
  • E: It can be executed using event-based or time-based schedules.
—

Question 11

You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition:

Image 1

Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table? (Choose three.)

  • A: The valid time columns employee_time_start and employee_time_end are automatically created.
  • B: The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
  • C: The valid time columns are not populated by the Oracle Server automatically.
  • D: The valid time columns are visible by default when the table is described.
  • E: Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data
—

Question 12

Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart.
Examine the following command and its output:
$ crsctl config has
CRS-4622: Oracle High Availability Services auto start is enabled.
What does this imply?

  • A: When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.
  • B: When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.
  • C: When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.
  • D: When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.
—

Question 13

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

Image 1

Which two statements are true? (Choose two.)

  • 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 PDB.
  • 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 used.
—

Question 14

You performed an incremental level 0 backup of a database:
RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE;
To enable block change tracking after the incremental level 0 backup, you issued this command:
SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
/mydir/rman_change_track.f;
To perform an incremental level 1 cumulative backup, you issued this command:
RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
Which three statements are true? (Choose three.)

  • A: Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.
  • B: The change tracking file must always be backed up when you perform a full database backup.
  • C: Block change tracking will always reduce I/O performed during cumulative incremental backups.
  • D: More than one database block may be read by an incremental backup for a change made to a single block.
  • E: The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed
—

Question 15

You find this query being used in your Oracle 12c database:

Image 1

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
—

Question 16

Which three resources might be prioritized between competing pluggable databases when creating a multitenant container database plan (CDB plan) using Oracle
Database Resource Manager? (Choose three.)

  • A: Maximum Undo per consumer group
  • B: Maximum Idle time
  • C: Parallel server limit
  • D: CPU
  • E: Exadata I/O
  • F: Local file system I/O
—

Question 17

You created an encrypted tablespace:

Image 1

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 closed.
  • 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.
—

Question 18

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? (Choose two.)

  • A: Only the ORD_CUSTOMER_IX1 index created.
  • 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.
—

Question 19

Which two statements are true when row archival management is enabled? (Choose two.)

  • A: The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.
  • B: The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.
  • C: The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
  • D: The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
  • E: The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer
—

Question 20

The HR user receives the following error while inserting data into the sales table:

Image 1

On investigation, you find that the users tablespace uses Automatic Segment Space Management (ASSM). It is the default tablespace for the HR user with an unlimited quota on it.
Which two methods would you use to resolve this error? (Choose two.)

  • A: Altering the data file associated with the USERS tablespace to extend automatically
  • B: Adding a data file to the USERS tablespace
  • C: Changing segment space management for the USERS tablespace to manual
  • D: Creating a new tablespace with autoextend enabled and changing the default tablespace of the HR user to the new tablespace
  • E: Enabling resumable space allocation by setting the RESUMABLE_TIMEOUT parameter to a nonzero value
—

Question 21

You use the segment advisor to help determine objects for which space may be reclaimed.
Which three statements are true about the advisor given by the segment advisor? (Choose three.)

  • A: It may advise the use of online table redefinition for tables in dictionary managed tablespace.
  • B: It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.
  • C: It may advise the use of online table redefinition for tables in locally managed tablespaces
  • D: It will detect and advise about chained rows.
  • E: It may advise the use of segment shrink for free list managed tables.
—

Question 22

In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container:

Image 1

Which two statements are true? (Choose two.)

  • A: The C # # ROLE1 role is created in the root database and all the PDBs.
  • B: The C # # ROLE1 role is created only in the root database because the container clause is not used.
  • C: Privileges are granted to the C##A_ADMIN user only in the root database.
  • D: Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.
  • E: The statement for granting a role to a user fails because the CONTAINER clause is not used.
—

Question 23

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;
—

Question 24

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB).
The characteristics of the non-CDB are as follows:
Version: Oracle Database 12c Releases 1 64-bit
Character set: WE8ISO8859P15
National character set: AL16UTF16
O/S: Oracle Linux6 64-bit
The characteristics of the CDB are as follows:
Version: Oracle Database 12c Release 1 64-bit
Character set: AL32UTF8
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 package
  • E: RMAN
—

Question 25

Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command:
SQL > exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (SRV1);
The possible outcome and actions to aggregate the trace files are as follows:

  1. The command fails because a module name is not specified.
  2. A trace file is created for each session that is running the SRV1 service.
  3. An aggregated trace file is created for all the sessions that are running the SRV1 service.
  4. The trace files may be aggregated by using the trcess utility.
  5. The trace files be aggregated by using the tkprof utility.
    Identify the correct outcome and the step to aggregate by using tkprof utility?
  • A: 1
  • B: 2 and 4
  • C: 2 and 5
  • D: 3 and 4
  • E: 3 and 5
—
Page 1 of 12 • Questions 1-25 of 282
12345
→

Free preview mode

Enjoy the free questions and consider upgrading to gain full access!