[Free] 2018(Jan) EnsurePass Passguide Oracle 1z0-062 Dumps with VCE and PDF 161-170

2018 Jan Oracle Official New Released 1z0-062
100% Free Download! 100% Pass Guaranteed!

Oracle Database 12c: Installation and Administration

Question No: 161

What is theeffect of setting the STATISTICS_LEVEL initialization parameter to BASIC?

  1. Optimizer statistics are collected automatically.

  2. Only timed operating system (OS) statistics and plan execution statistics are collected.

  3. Automatic Workload Repository(AWR) snapshots are not generated automatically.

  4. The Oracle server dynamically generates the necessary object-level statistics on tables as part of query optimization.

Answer: C Explanation: References:

https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams240.htm#REFRN1021 4

Question No: 162

Examine the following parameters for a database instance:


Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?







Answer: A,E,F Explanation:

Manually Sized SGA Components that Use SGA_TARGET Space SGA Component, Initialization Parameter

/ The log buffer LOG_BUFFER

/ The keep and recycle buffer caches DB_KEEP_CACHE_SIZE DB_RECYCLE_CACHE_SIZE

/ Nonstandard block size buffer caches DB_nK_CACHE_SIZE


  • In addition to setting SGA_TARGET to a nonzero value, you must set to zero all initialization parameters listed in the table below to enable full automatic tuning of the automatically sized SGA components.

  • Table, Automatically Sized SGA Components and Corresponding Parameters

Ensurepass 2018 PDF and VCE

Question No: 163

Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database(CDB) is open and you connect RMAN.

You want to issue the following RMAN command: RMAN gt; BACKUP TABLESPACE hr_pdb:userdata;

Which task should you perform before issuing the command?

  1. Place the root container in ARHCHIVELOG mode.

  2. Take the user datatablespace offline.

  3. Place the root container in the nomount stage.

  4. Ensure that HR_PDB is open.

Answer: A

Question No: 164

In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period oftime.

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

Answer: D Explanation:

An Oracle session is sniped when you set the idle_time parameter to disconnect inactive sessions. (It#39;s only like sniping on ebay in that a time is set for an action to occur.)

Oracle has several ways to disconnect inactive or idle sessions,both from within SQL*Plus via resources profiles (connect_time, idle_time), and with the SQL*net expire time parameter. Here are two ways to disconnect an idle session:

Set the idle_time parameter in the user profile Set the sqlnet.ora parameter expire_time

Question No: 165

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

  1. The PDB must be open in read only mode.

  2. The PDBmust be dosed.

  3. The unplugged PDB becomes a non-CDB.

  4. The unplugged PDB can be plugged into the same multitenant container database (CDB)

  5. The unplugged PDB can be plugged into another CDB.

  6. The PDB data files are automatically removed from disk.

Answer: B,D,E Explanation:

B, not A: The PDB must be closed before unplugging it.

D: An unplugged PDB contains data dictionary tables, and some of the columns in these encode information in an endianness-sensitive way. There is no supported way tohandle the conversion of such columns automatically. This means, quite simply, that an unplugged PDB cannot be moved across an endianness difference.

E (not F): To exploit the new unplug/plug paradigm for patching the Oracle version most effectively, thesource and destination CDBs should share a filesystem so that the PDB’s datafiles can remain in place.


Question No: 166

Which three factors influence the optimizer#39;s choice of an execution plan?

  1. the optimizer_mode initialization parameter

  2. type of connection used to connect to database instance

  3. cardinality estimates

  4. object statistics in the data dictionary

  5. fixed baselines

Answer: A,B,E

Question No: 167

Which three statements are true about Oracle DataPump?

  1. IMPDP can be used to change target data file names, schemas, and tablespaces during import.

  2. The DBMS_DATAPUMP PL/SQL package can be used independently of Data Pump clients to perform export and import operations.

  3. EXPDP and IMPDP are the client components of Oracle Data Pump.

  4. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.

  5. IMPDP always use the conventional path insert method to import data.

Answer: A,B,C Explanation:

References:https://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_overview.htm#S UTIL2880

Question No: 168

Which three statements are true about using flashback database in a multitenant container database (CDB)?

  1. The root container can be flashed back withoutflashing back the pluggable databases (PDBs).

  2. To enable flashback database, the CDB must be mounted.

  3. Individual PDBs can be flashed back without flashing back the entire CDB.

  4. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.

  5. A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

Answer: B,D,E

Question No: 169

Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

  1. The ADDM requires at least four AWR snapshots for analysis

  2. The ADDM runs after each AWR snapshot is collected automatically by MMON

  3. The resultsof the ADDM analysis are stored in the Automatic Workload Repository (AWR)

  4. The ADDM analysis provides only diagnostics information but does not provide recommendations

  5. The ADDM calls other advisors if required, but does not provide recommendationsabout the advisors

Answer: B,C

Question No: 170

Which two statements correctly describe the relationship between data files and logical database structures?

  1. A segment cannot span data files.

  2. A data file can belong to only one tablespace.

  3. An extent cannot span datafiles.

  4. The size of an Oracle data block in a data file should be the same as the size of an OS block.

Answer: B,C Explanation: References:

100% Free Download!
Download Free Demo:1z0-062 Demo PDF
100% Pass Guaranteed!
Download 2018 EnsurePass 1z0-062 Full Exam PDF and VCE

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2018 EnsurePass IT Certification PDF and VCE

Leave a Comment


Your email address will not be published. Required fields are marked *