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

Get Full Version of the Exam
http://www.EnsurePass.com/1z0-062.html

Question No.111

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 gt; exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (`SRV1#39;);

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?

  1. 1

  2. 2 and 4

  3. 2 and 5

  4. 3 and 4

  5. 3 and 5

Correct Answer: B

Explanation:

Tracing information is present in multiple trace files and you must use the trcsess tool to collect it into a single file.

Incorrect:

Not 1: Parameter service_name

Name of the service for which tracing is enabled. module_name

Name of the MODULE. An optional additional qualifier for the service.

Note:

The procedure enables a trace for a given combination of Service, MODULE and ACTION name. The specification is strictly hierarchical: Service Name or Service Name/MODULE, or Service Name, MODULE, and ACTION name must be specified. Omitting a qualifier behaves like a wild- card, so that not specifying an ACTION means all ACTIONs. Using the ALL_ACTIONS constant achieves the same purpose.

SERV_MOD_ACT_TRACE_ENABLE Procedure

This procedure will enable SQL tracing for a given combination of Service Name, MODULE and ACTION globally unless an instance_name is specified.

DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE(

service_name IN VARCHAR2,

module_name IN VARCHAR2 DEFAULT ANY_MODULE, action_name IN VARCHAR2 DEFAULT ANY_ACTION, waits IN BOOLEAN DEFAULT TRUE,

binds IN BOOLEAN DEFAULT FALSE,

instance_name IN VARCHAR2 DEFAULT NULL);

Question No.112

Your production database uses file system storage. You want to move storage to Oracle Automatic Storage Management (ASM). How would you achieve this?

  1. by using a transportable database

  2. by using the Database Upgrade Assistant (DBUA)

  3. by using Data Pump

  4. by using RMAN

Correct Answer: D

Explanation:

http://docs.oracle.com/cd/E11882_01/server.112/e18951.pdf (p.184)

Question No.113

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

  1. 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

  2. Setting the target tablespace to read-only

  3. 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

  4. Setting the target tablespace offline

  5. 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

Correct Answer: BC

Explanation:

The value for TBS_PERCENT_USED specifies the percentage of the tablespace quota when a tablespace is considered full. The value for TBS_PERCENT_FREE specifies the targeted free percentage for the tablespace. When the percentage of the tablespace quota reaches the value of TBS_PERCENT_USED, ADO begins to move data so that percent free of the tablespace quota approaches the value of TBS_PERCENT_FREE. This action by ADO is a best effort and not a guarantee.

Question No.114

Examine the parameters for a database instance:

image

Which two statements are true? (Choose two.)

  1. Undo records for temporary tables are stored in a temporary tablespace.

  2. Undo records for temporary tables are stored in the undo tablespace and logged in the redo.

  3. Undo records for temporary tables are stored in the undo tablespace and logged in the redo only for those sessions where temporary undo is enabled.

  4. No redo is generated for the undo records belonging to temporary tables.

  5. No redo and undo records are generated for temporary tables.

Correct Answer: AD

Question No.115

Which three statements are true about Flashback Database? (Choose three.)

  1. Flashback logs are written sequentially, and are archived.

  2. Flashback Database uses a restored control file to recover a database.

  3. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.

  4. Flashback Database can recover a database to the state that it was in before a reset logs operation.

  5. Flashback Database can recover a data file that was dropped during the span of time of the flashback.

  6. Flashback logs are used to restore to the blocks#39; before images, and then the redo data may be used to roll forward to the desired flashback time.

Correct Answer: CDF

Question No.116

Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column? (Choose two.)

  1. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.

  2. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.

  3. All the components may be moved into SYSAUX tablespace.

  4. All the components may be moved from the SYSAUX tablespace.

Correct Answer: AB

Question No.117

Examine these two statements:

image

Which three are true about the MRKT tablespace? (Choose three.)

  1. The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.

  2. The MRKT tablespace may be dropped if it has no contents.

  3. Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.

  4. No more data files can be added to the tablespace.

  5. The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.

Correct Answer: CDE

Question No.118

In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database?

Both local and global partitioned B-tree Indexes are defined on the table.

A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends.

Minimal disrupt ion to availability is required.

Which three statements are true about this requirement? (Choose three.)

  1. The partitions can be moved online to new tablespaces.

  2. Global indexes must be rebuilt manually after moving the partitions.

  3. The partitions can be compressed in the same tablespaces.

  4. The partitions can be compressed in the new tablespaces.

  5. Local indexes must be rebuilt manually after moving the partitions.

Correct Answer: ACD

Explanation:

A: You can create and rebuild indexes online. Therefore, you can update base tables at the same time you are building or rebuilding indexes on that table. You can perform DML operations while the index build is taking place, but DDL operations are not allowed. Parallel execution is not supported when creating or rebuilding an index online.

D: Moving (Rebuilding) Index-Organized Tables

Because index-organized tables are primarily stored in a B-tree index, you can encounter fragmentation as a consequence of incremental updates. However, you can use the ALTER

TABLE…MOVE statement to rebuild the index and reduce this fragmentation.

C: If a table can be compressed in the new tablespace, also it can be compressed in the same tablespace.

Incorrect:

Not B, not E: Local and Global indexes can be automatically rebuild with UPDATE INDEXES when you move the table.

Question No.119

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

  1. Thread creation must be routed through a dispatcher process

  2. The local listener may spawn a now process and have that new process create a thread

  3. Each Oracle process runs an SCMN thread.

  4. Each multithreaded Oracle process has an SCMN thread.

  5. The local listener may pass the request to an existing process which in turn will create a thread.

Correct Answer: ADE

Question No.120

You plan to install the Oracle Database 12c software on a new server. The database will use Automatic Storage Management (ASM) and Oracle Restart. Oracle Grid Infrastructure for a standalone server is already installed on the server.

You want to configure job role separation. You create the following operating system users and groups:

image

image

The user oracle as the owner of the Oracle database installation The user grid as the owner of Oracle Grid Infrastructure

image

The group oinstall as an Oracle Inventory group

image

image

The group dba as the OSDBA group for Oracle database The group asmdba as the OSDBA group for Oracle ASM

image

image

The group asmadmin as the administration privileges group for Oracle ASM The group asmoper as the group for Oracle ASM

Which two additional tasks should you perform with regard to the OS-level owners and groups? (Choose two.)

  1. creating a separate central inventory group for the Oracle Database 12c installation

  2. assigning oinstall as the primary group for the oracle user

  3. assigning asmadmin and asmoper as primary groups for the oracle user

  4. creating OS groups associated with the OSBACKUPDBA, OSDGDBA, and OSKMDBA system privileges

  5. assigning asmdba as the secondary group for the oracle user

Correct Answer: BD

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