[Free] 2019(Nov) EnsurePass Oracle 1z0-062 Dumps with VCE and PDF 171-180

Get Full Version of the Exam

Question No.171

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?

  1. When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.

  2. When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.

  3. When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.

  4. When you create a database service by modifying the SERVICE_NAMES initialization parameter,

it is automatically added to the Oracle Restart configuration.

Correct Answer: B


About Startup Dependencies

Oracle Restart ensures that Oracle components are started in the proper order, in accordance with component dependencies. For example, if database files are stored in Oracle ASM disk groups, then before starting the database instance, Oracle Restart ensures that the Oracle ASM instance is started and the required disk groups are mounted. Likewise, if a component must be shut down, Oracle Restart ensures that dependent components are cleanly shut down first.

Oracle Restart also manages the weak dependency between database instances and the Oracle Net listener (the listener): When a database instance is started, Oracle Restart attempts to start the listener. If the listener startup fails, then the database is still started. If the listener later fails, Oracle Restart does not shut down and restart any database instances.

Explanation: http://docs.oracle.com/cd/E16655_01/server.121/e17636/restart.htm#ADMIN12710

Question No.172

Which two statements are true about the (PMON) background process in Oracle Database 12c? (Choose two.)

  1. It records checkpoint information in the control file.

  2. It frees unused temporary segments.

  3. It kills sessions that exceed idle time.

  4. It registers database services with all local and remote listeners known to the database instance.

  5. It frees resources held by abnormally terminated processes.

Correct Answer: DE



Question No.173

Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled? (Choose three.)

  1. Reduced logical I/O

  2. Reduced virtual memory utilization

  3. Improved parallel Execution performance

  4. Improved Serial Execution performance

  5. Reduced physical I/O

  6. Reduced CPU utilization

Correct Answer: BCF


Multiprocess and Multithreaded Oracle Database Systems Multiprocess Oracle Database (also called multiuser Oracle Database) uses several processes to run different parts of the Oracle Database code and additional Oracle processes for the userseither one process for each connected user or one or more processes shared by multiple users. Most databases are multiuser because a primary advantage of a database is managing data needed by multiple users simultaneously. Each process in a database instance performs a specific job. By dividing the work of the database and applications into several processes, multiple users and applications can connect to an instance simultaneously while the system gives good performance.

In previous releases, Oracle processes did not run as threads on UNIX and Linux systems.

Starting in Oracle Database 12c, the multithreaded Oracle Database model enables Oracle processes to execute as operating system threads in separate address spaces.

Question No.174

Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:


Which two statements are true about redefining the table? (Choose two.)

  1. All the triggers for the table are disabled without changing any of the column names or column types in the table.

  2. The primary key constraint on the EMPLOYEES table is disabled during redefinition.

  3. VPD policies are copied from the original table to the new table during online redefinition.

  4. You must copy the VPD policies manually from the original table to the new table during online redefinition.

Correct Answer: BC



Used to indicate to copy VPD policies automatically DBMS_RLS.ADD_POLICY

The DBMS_RLS package contains the fine-grained access control administrative interface, which is used to implement Virtual Private Database (VPD).DBMS_RLS is available with the Enterprise Edition only.


CONS_USE_PK and CONS_USE_ROWID are constants used as input to the quot;options_flagquot; parameter in both the START_REDEF_TABLE Procedure and CAN_REDEF_TABLE Procedure. CONS_USE_ROWID is used to indicate that the redefinition should be done using rowids while CONS_USE_PK implies that the redefinition should be done using primary keys or pseudo-

primary keys (which are unique keys with all component columns having NOT NULL constraints). DBMS_REDEFINITION.START_REDEF_TABLE

To achieve online redefinition, incrementally maintainable local materialized views are used. These logs keep track of the changes to the master tables and are used by the materialized views during refresh synchronization.


Prior to calling this procedure, you must manually create an empty interim table (in the same schema as the table to be redefined) with the desired attributes of the post- redefinition table, and then call this procedure to initiate the redefinition.

Question No.175

Examine the commands executed to monitor database operations:

$gt; conn sys oracle/oracle@prod as sysdba SQL gt; VAR eid NUMBER

SQL gt; EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (`batch_job#39; , FORCED_TRACKING =gt; `Y#39;);

Which two statements are true? (Choose two.)

  1. Database operations will be monitored only when they consume a significant amount of resource.

  2. Database operations for all sessions will be monitored.

  3. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC TUNING.

  4. Only DML and DDL statements will be monitored for the session.

  5. All subsequent statements in the session will be treated as one database operation and will be monitored.

Correct Answer: CE


C: Setting the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter to DIAGNOSTIC TUNING (default) enables monitoring of database operations. Real-Time SQL Monitoring is a feature of the Oracle Database Tuning Pack.


The DBMS_SQL_MONITOR package provides information about Real-time SQL Monitoring and Real-time Database Operation Monitoring.

(not B) BEGIN_OPERATION Function

starts a composite database operation in the current session.

(E) FORCE_TRACKING – forces the composite database operation to be tracked when the operation starts. You can also use the string variable #39;Y#39;.

(not A) NO_FORCE_TRACKING – the operation will be tracked only when it has consumed at least 5 seconds of CPU or I/O time. You can also use the string variable #39;N#39;.

Question No.176

In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time. How would you accomplish this?

  1. Setting a metric threshold

  2. Implementing Database Resource Manager

  3. Enabling resumable timeout for user sessions

  4. Decreasing the value of the IDLE_TIME resource limit in the default profile

Correct Answer: B

Question No.177

Which two are prerequisites for performing a flashback transaction? (Choose two.)

  1. Flashback Database must be enabled.

  2. Undo retention guarantee for the database must be configured.

  3. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.

  4. Supplemental logging must be enabled.

  5. Recycle bin must be enabled for the database.

  6. Block change tracking must be enabled tor the database.

Correct Answer: BD


http://searchoracle.techtarget.com/tip/How-to-perform-Oracle-Flashback-Transaction-Queries https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS6

Question No.178

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


Which two statements are true? (Choose two.)

  1. Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.

  2. The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.

  3. The command will, create a common user whose description is contained in the root and each PDB.

  4. The schema for the common user C # # A_ADMIN can be different in each container.

  5. The command will create a user in the root container only because the container clause is not used.

Correct Answer: CD

Question No.179

Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3. Which two RMAN commands may be; used to back up only the PDB1 pluggable database? (Choose two.)

  1. BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container

  2. BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container

  3. BACKUP DATABASE while connected to the PDB1 container

  4. BACKUP DATABASE while connected to the boot container

  5. BACKUP PLUGGABLE database PDB1 while connected to PDB2

Correct Answer: AC


To perform operations on a single PDB, you can connect as target either to the root or directly to the PDB.

(A) If you connect to the root, you must use the PLUGGABLE DATABASE syntax in your RMAN commands. For example, to back up a PDB, you use the BACKUP PLUGGABLE DATABASE command.

(C) If instead you connect directly to a PDB, you can use the same commands that you would use when connecting to a non-CDB. For example, to back up a PDB, you would use the BACKUP DATABASE command.

Question No.180

You execute this command:


Which two statements are true about segment space management for segments in this tablespace? (Choose two.)

  1. Space utilization inside segments is mapped by bitmaps.

  2. Segments are automatically shrunk and compressed when rows are deleted.

  3. The PCTFREE storage parameter has no effect on segments created in this tablespace.

  4. The PCTUSED storage parameter has no effect on segments created in this tablespace.

Correct Answer: AD

Get Full Version of the Exam
1z0-062 Dumps
1z0-062 VCE and PDF