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

Get Full Version of the Exam

Question No.271

Which four operations performed after the Oracle Restart installation are automatically added to the Oracle Restart configuration? (Choose four.)

  1. listener configured by using NETCA

  2. database service created by using SRVCTL

  3. database created by using a SQL statement

  4. database created by using DBCA

  5. ASM instance created by using ASMCA

  6. database service created by using DBMS_SERVICE.CREATE_SERVICE

  7. database service created by modifying the SERVICE_NAMES initialization parameter

Correct Answer: ABDE



Question No.272

Which component resides in the System Global Area (SGA) of a database instance only in shared server connections?

  1. User Global Area

  2. Program Global Area

  3. SQL Query Result Cache

  4. PL/SQL Function Result Cache

Correct Answer: A

Question No.273

Your production database PROD uses file system storage. You want to migrate storage including the Fast Recovery Area for the PROD database to Oracle Automatic Storage Management (ASM) by using RMAN. You back up the entire database. What should the next step be in this migration process?

  1. enabling row movement for the database

  2. disabling Oracle Flashback Database if enabled

  3. opening the database in exclusive mode

  4. placing all tablespaces in read-only mode

Correct Answer: B



Question No.274

Which two statements are true about initialization parameter files? (Choose two.)

  1. A lost or damaged SPFILE can be re-created by using the parameter values listed in the alert log.

  2. A PFILE must exist for an SPFILE to be created.

  3. The ALTER SYSTEM command cannot be used to change the value of any parameter if a database instance has started using a PFILE.

  4. Both the SPFILE and PFILE must always reside on a file system accessible from the database host server.

  5. On startup, by default a database instance always first searches for an SPFILE, and if it does not find any, searches for a PFILE.

Correct Answer: BE

Question No.275

What action must you take to ensure complete database recovery till the point of failure?

  1. Multiplex the control files

  2. Duplex the RMAN backup sets.

  3. Multiplex the online redo log files.

  4. Configure the database to run in ARCHIVELOG mode.

Correct Answer: D

Question No.276

Your database is running in NOARCHIVLOG mode. Examine the following parameters:


You execute the following command after performing a STARTUP MOUNT: SQLgt; ALTER DATABASE ARCHIVELOG;

Which statement is true about the execution of the command?

  1. It executes successfully and sets the Fast Recovery Area as the local archive destination.

  2. It executes successfully and issues a warning to set LOG_ARCHIVE_DEST while opening the database.

  3. It fails and returns an error about LOG_ARCHIVE_DEST not being set.

  4. It executes successfully and sets $ORACLE_HOME/dbs as the default archive destination.

Correct Answer: A

Question No.277

The HR.DEPARTMENTS table is the parent of the HR.EMPLOYEES table. The EMPLOYEES.DEPARTMENT_ID column has a foreign key constraint with the ON DELETE CASCADE option that refers to the DEPARTMENTS.DEPARTMENT_ID column. An index exists on the DEPARTMENTS.DEPARTMENT_ID column. A transaction deletes a primary key in the DEPARTMENTS table, which has child rows in the EMPLOYEES table. Which statement is true?

  1. The transaction acquires a table lock only on the DEPARTMENTS table until the transaction is complete.

  2. The transaction acquires a table lock on the DEPARTMENTS table. This lock enables other sessions to query but not update the DEPARTMENTS table until the transaction on the DEPARTMENTS table is complete.

  3. The transaction acquires a table lock on the EMPLOYEES table. This lock enables other sessions to query but not update the EMPLOYEES table until the transaction on the DEPARTMENTS table is complete.

  4. Only the rows that are deleted in the DEPARTMENTS and EMPLOYEES tables are locked until the transactions on the DEPARTMENTS table is complete.

Correct Answer: C

Question No.278

You are managing an Oracle Database 12c database. The database is open, and you plan to perform Recovery Manager (RMAN) backups. Which three statements are true about these backups? (Choose three.)

  1. The backups would be consistent.

  2. The backups would be possible only if the database is running in ARCHIVELOG mode.

  3. The backups need to be restored and the database has to be recovered in case of a media failure.

  4. The backups would be inconsistent.

  5. The backups by default consist of all the data blocks within the chosen files or the full database.

Correct Answer: BCD

Question No.279

Which two would you recommend to an application developer for reducing locking conflicts on tables in an Oracle database? (Choose two.)

  1. Create objects in locally managed tablespaces with Automatic Segment Space Management (ASSM) enabled.

  2. Avoid coding long-running transactions.

  3. Allow the database to handle locks ln default locking mode.

  4. Create objects in locally managed tablespaces with manual segment space management enabled.

  5. Enable undo retention guarantee.

Correct Answer: BC

Question No.280

Which two tasks must you perform before you begin the upgrade process to Oracle Database 12c? (Choose two.)

  1. Put all readonly tablespaces in read write mode

  2. Recompile all invalid objects

  3. Set the compatible parameter to

  4. Gather dictionary statistics

  5. Empty all user recycle bins

Correct Answer: BE

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