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

Get Full Version of the Exam

Question No.261

For which three requirements would you use the Database Resource Manager? (Choose three.)

  1. specifying an idle time limit that applies to sessions that are idle and blocking other sessions

  2. limiting the degree of parallelism of operations performed by user sessions in a consumer group

  3. specifying the maximum number of concurrent sessions allowed for a user

  4. limiting the CPU used per database call

  5. specifying the amount of private space a session can allocate in the shared pool of the SGA.

Correct Answer: ABC



Question No.262

You are administering a database that supports an OLTP workload.

The default UNDO tablespace is a fixed size tablespace with the RETENTION NOGUARATNEE clause and undo retention set to 12 minutes.

The user SCOTT queries a large table during peak activity.

The query runs for more than 15 minutes and then SCOTT receives the following error: ORA-01555: snapshot too old

Which is possible reason for this?

  1. The Oracle server is unable to generate a read-consistent image for a block containing updates.committed after the query began.

  2. The query is unable to place data blocks in the UNDO tablespace.

  3. The flashback data archive is not enabled for the table on which the query is issued.

  4. There is not enough space in Fast Recovery Area.

  5. The Oracle server is unable to generate a read-consistent image for a block containing uncommitted updates.

Correct Answer: A

Question No.263

You create a locally managed tablespace ORDERS_TBS with automatic segment management.

You then create the table DAILY_ORDS_LST in the ORDERS_TBS tablespace using the command.

CREATE TABLE daily_ords_1st(ordno NUMBER, ord_date DATE) PCTFREE 20; How does the PCTFREE storage parameter influence data storage for this table?

  1. It allows only 80% of space to be occupied in all data blocks of this table.

  2. It minimizes row chaining during row insertion.

  3. It minimizes row migration during existing row data updation.

  4. It automatically coalesces free space of a data block when it reaches 20% of available space.

Correct Answer: A

Question No.264

Which statement is true about profiles?

  1. Resource limits specified in a profile assigned to a user are always enabled.

  2. A user can exist without any profile.

  3. A profile can be assigned only to one user.

  4. Password management using profiles is always enabled.

Correct Answer: D

Question No.265

Which three statements are true about checkpointing? (Choose three.)

  1. It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to

    the online redo log files.

  2. It ensures that all dirty buffers are written to data files during consistent shutdown.

  3. It reduces the time required for recovery in case of an instance failure.

  4. Frequent thread checkpoints can degrade database performance.

  5. It prompts the Database Writer (DBWn) process to write checkpoint information into data file headers and the control file.

Correct Answer: BCD

Question No.266

Which three tools or tasks are run by default as part automated maintenance tasks? (Choose three.)

  1. Automatic Database Diagnostic Monitor

  2. Optimizer statistics gathering

  3. SQL Access Advisor

  4. Segment Advisor

  5. Automatic SQL Tuning Advisor

Correct Answer: BDE

Question No.267

Identify two prerequisites for configuring Enterprise Manager Database Express (EM Express).

  1. Grant the APEX_PUBLIC_USER role to the SYSMAN user.

  2. Use the DBMS_XDB_CONFIG.SETHTTPPORT procedure to configure a port number for Oracle HTTP Server.

  3. Install Oracle HTTP Server.

  4. Configure at least one dispatcher for the TCP/IP protocol.

  5. Create a SYSMAN user with the SYSDBA privilege as an administrator for EM Express.

Correct Answer: BD

Question No.268

Which three statements are true about user account administration? (Choose three.)

  1. A user#39;s current session is not affected when the user#39;s profile is changed.

  2. Only users with the SYSDBA privilege can change the tablespace quota for other users.

  3. A new user account can be created only by SYS or SYSTEM users.

  4. A user#39;s quota can be set for any permanent tablespace but not for the default temporary tablespace.

  5. A user requires only the CREATE SESSION privilege to change his or her own password.

Correct Answer: ADE

Question No.269

Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)

  1. An AWR snapshot shows the SQL statements that are producing the highest load on the system, based on criteria such as elapsed time and CPU time.

  2. AWR data is stored in memory and in a database.

  3. All AWR tables belong to the SYSTEM schema.

  4. The manageability monitor (MMON) process gathers statistics and creates an AWR snapshot that is used by the self-tuning components in a database.

  5. An AWR snapshot contains system-wide tracing and logging information.

Correct Answer: ABD

Question No.270

Which statement is true about a database in ARCHIVELOG mode?

  1. All backups taken prior to switching to ARCHIVELOG mode can be used to perform complete recovery.

  2. Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.

  3. A Fast Recovery Area (FRA) must be configured for the database.

  4. Full database backups can be performed when the database is opened.

Correct Answer: D

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