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

Get Full Version of the Exam

Question No.201

The performance of your database degrades between 11:00 AM and 3:00 PM. Automatic Workload Repository (AWR) snapshots are collected on an hourly basis. What is the most efficient way of diagnosing this problem?

  1. Create a custom ADDM task for the period defined by the snapshots taken between 11:00 AM and 3:00 PM.

  2. Analyze the latest Automatic Database Diagnostic Monitor (ADDM) report.

  3. Analyze the hourly ADDM reports generated between 11:00 AM and 3:00 PM.

  4. Create a SQL Tuning Set (STS) for the currently cached SQL statements in the shared pool and run SQL Performance Analyzer (SPA) to generate recommendations.

Correct Answer: A

Question No.202

Which three are activities performed by SMON? (Choose three.)

  1. cleaning up the database buffer cache and freeing resources that a client process was using

  2. applying online redo during instance recovery

  3. cleaning up temporary segments that are no longer needed

  4. performing database services registration with the default listener

  5. restarting a server or a dispatcher process that terminated abnormally

  6. recovering failed transactions that were skipped during instance recovery because of file-read or tablespace offline errors

Correct Answer: BCF

Question No.203

Your database has been running with a peak load for the past hour. You want to preserve the performance statistics collected during this period for comparison when you analyze the performance of the database later. What must you do to achieve this?

  1. Increase the window size of the moving window baseline so that it equals the Automatic Workload Repository (AWR) snapshot retention period.

  2. Create a baseline on a pair of snapshots that span the peak load period.

  3. Generate Active Session History reports for the peak load period.

  4. Set the snapshot retention period in AWR to 60 to avoid automatic purging of snapshots for the past hour.

Correct Answer: B

Question No.204

Automatic Shared Memory Management is enabled for your database instance. You notice that there are SQL statements performing poorly because of repeated parsing activity. Which action generates recommendations to overcome the performance issues?

  1. running the Memory Advisor for the buffer cache

  2. running the Memory Advisor for the library cache

  3. running the Memory Advisor for the SGA

  4. running the Memory Advisor for the PGA

Correct Answer: B

Question No.205

What is the effect 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.

Correct Answer: C



Question No.206

A user establishes a connection to a database instance by using an Oracle Net. You want to ensure that:

  1. The user account must be locked after five consecutive unsuccessful login attempts.

  2. Data read per session must be limited for the user.

  3. The user cannot have more than three simultaneous sessions.

  4. The user must have a maximum of 10 minutes session idle time before being logged off automatically.

Which two would you do to implement this? (Choose two.)

  1. by alerting the appropriate user attributes with an ALTER USER command

  2. by using appropriate PASSWORD parameters set in the profile assigned to the user

  3. by implementing Database Resource Manager and assign it a profile for the user

  4. by implementing Database Resource Manager and assign it a role for the user

  5. by using appropriate KERNEL parameters set in the profile assigned to the user

Correct Answer: BE

Question No.207

You want to distribute a set of structured data to your customers who can integrate this data into their existing databases irrespective of the platform. Which method provides the fastest way of achieving this?

  1. using the DBVERIFY utility

  2. using direct-path INSERT SQL statements

  3. using SQL*Loader

  4. using RMAN transportable tablespace operation

Correct Answer: D

Question No.208

Your database is configured in ARCHIVELOG mode, and daily full database backups are taken. RMAN is configured to perform control file autobackups. Which statement is true about the loss of a duplexed control file?

  1. The database remains open but transactions are not permitted.

  2. The database instance aborts, and media recovery is required after restoration of the control file to open the database.

  3. The database instance remains open and the control file can be restored without shutting down the database.

  4. The database instance aborts and a control file restore operation does not require media recovery.

Correct Answer: C

Question No.209

Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace Point- in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process, you queried the TS_PITR_CHECK view and you realized that the table has a referential constraint with DEPARTMENTS that exists in another tablespace, MASTERTBS. Which two actions will permit the TSPITR to work? (Choose two.)

  1. Taking the MASTERTBS tablespace offline

  2. Dropping the relationship between the tables

  3. Adding the MASTERTBS tablespace to the recovery set

  4. Putting the MASTERTBS tablespace in read-only mode

Correct Answer: BC



If constraints for the tables in tablespace tbs1 are contained in the tablespace tbs2, then you cannot recover tbs1 without also recovering tbs2.

Question No.210

Which two statements are true about the Database Configuration Assistant (DBCA)? (Choose two.)

  1. It can be used to create a database template from an existing database.

  2. It can be used to add a new tablespace.

  3. It can generate SQL database creation scripts.

  4. It can be used to copy an existing Oracle database to a new host and apply any patches necessary in the new host.

  5. It can configure Automatic Storage Management (ASM) diskgroups.

Correct Answer: AC

Explanation: https://docs.oracle.com/cd/E17559_01/em.111/e16599/appdx_creating_db_templates.htm# CJACEDCD

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