Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 441:

  In your test database:

  You are using Recovery Manager (RMAN) to perform incremental backups of your test database

  The test database is running in NOARCHIVELOG mode

  One of the data files is corrupted

  All online redo log files are lost because of a media failure

  Which option must you consider in this scenario?

  A. Configuring the database in ARCHVIELOG mode and then using incremental backup to recover the database
  B. Using incremental backup to recover the damaged data file and then manually creating the online redo log files
  C. Creating a new test database because the database is not recoverable due to the fact that the database is configured in NOARCHIVELOG mode
  D. Using incremental backups to recover the database by using the RECOVER DATABASE NOREDO command and then using the RESETLOGS option to open the database.
  D. Using incremental backups to recover the database by using the RECOVER DATABASE NOREDO command and then using the RESETLOGS option to open the database.

• Question 442:

  Which two statements are correct about database transportation? (Choose two.)

  A. The source and target platforms must be the same
  B. Redo logs, control files and temp files are also transported
  C. The transported database must have the same database identifier (DBID) as the source database and cannot be changed
  D. The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported
  E. Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format
  D. The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported
  E. Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format

• Question 443:

  Examine the following command used to perform incremental level 0 backup:

  RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE;

  To enable the block change tracking, after the incremental level 0 backup you issued the following command:

  SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/mydir/rman_change_track.f';

  To perform incremental level 1 cumulative backup, you issued the following command:

  RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;

  Which two statements are true in the above situation? (Choose two.)

  A. The block change tracking data will be used only from the next incremental 0 backup.
  B. The incremental backup will use change tracking data for accomplishing the backup.
  C. The incremental backup will not use change tracking data for accomplishing the backup.
  D. The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.
  A. The block change tracking data will be used only from the next incremental 0 backup.
  C. The incremental backup will not use change tracking data for accomplishing the backup.

• Question 444:

  NLS parameters can be set using the five methods listed. Put the methods in order from highest to lowest according to Oracles order of precedence:

  a: Default setting

  b: Client environment variable

  c: Explicit ALTER SESSION statement

  d: Inside SQL function

  e:

  Server initialization parameter

  A. b, d, e, a, c
  B. e, a, b, c, d
  C. d, c, b, e, a
  D. a, b, d, c, e
  E. d, c, b, a, e
  C. d, c, b, e, a

• Question 445:

  Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g? (Choose all that apply.)

  A. Generate reports on data failure such as data file failures.
  B. You can track the Service Request (SR) and implement repairs.
  C. You can package and upload diagnostic data to Oracle Support.
  D. You can manually run health checks to gather diagnostic data for a problem.
  B. You can track the Service Request (SR) and implement repairs.
  C. You can package and upload diagnostic data to Oracle Support.
  D. You can manually run health checks to gather diagnostic data for a problem.

• Question 446:

  Which statement most accurately describes the implementation of a SQL Access Advisor recommendation?

  A. SQL Access Advisor recommendations are automatically implemented.
  B. Individual SQL Access Advisor recommendations can be scheduled for implementation.
  C. All SQL Access Advisor recommendations for a specific task must be implemented at the same time.
  D. SQL Access Advisor recommendations are automatically scheduled for implementation during the maintenance window.
  E. None of the above.
  B. Individual SQL Access Advisor recommendations can be scheduled for implementation.

• Question 447:

  You want to put a specific tablespace called MY_DATA in hot backup mode so you can back it up. What command would you use?

  A. alter tablespace MY_DATA begin backup;
  B. alter tablespace MY_DATA start backup;
  C. alter tablespace MY_DATA backup begin;
  D. alter MY_DATA begin backup;
  E. You cannot back up individual tablespaces.
  A. alter tablespace MY_DATA begin backup;

• Question 448:

  View the Exhibit to examine the Automatic SQL Tuning result details. Which action would you suggest for the selected SQL statement in the Exhibit?

  

  A. Accept the recommended SQL profile.
  B. Collect statistics for the related objects.
  C. Run the Access Advisor for the SQL statement.
  D. Run the Segment Advisor for recommendations.
  C. Run the Access Advisor for the SQL statement.

• Question 449:

  Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode?

  A. Archive log generation is suspended until the tablespaces are taken out of hot backup mode.
  B. Datafiles are not written to during hot backups.
  C. Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered.
  D. The datafile headers are not updated during the backup.
  E. The way data is written to the online redo logs is unchanged during the backup.
  D. The datafile headers are not updated during the backup.

• Question 450:

  Which statements are true regarding the Query Result Cache? (Choose all that apply.)

  A. It can be set at the system, session, or table level.
  B. It is used only across statements in the same session.
  C. It can store the results from normal as well as flashback queries.
  D. It can store the results of queries based on normal, temporary, and dictionary tables.
  A. It can be set at the system, session, or table level.
  C. It can store the results from normal as well as flashback queries.