[Free] 2018(Jan) Latesttests Testking Oracle 1z0-053 Dumps with VCE and PDF Download 301-310

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

Oracle Database 11g: Administration II

Question No: 301 – (Topic 8)

Examine the following command that is used to duplicate a database on the same host:





Which two statements describe the effect after the database is duplicated successfully? (Choose two)

  1. The data files of the read-only tablespaces in the target database are not duplicated

  2. The read-only tablespaces in the target database are still defined in new the database

  3. The read-only tablespaces in the target database are changed to online after duplication

  4. The data files of the read-only tablespaces in the target database get duplicated

  5. The read-only tablespaces in the target database are not defined in the new database

Answer: A,B

Question No: 302 – (Topic 8)

Which of the following are included in a transportable tablespace set? (Choose all that apply.)

  1. The datafiles that make up a self-contained group of tablespaces required for copy

  2. The system tablespace

  3. An export of the tablespace metadata

  4. The spfile

  5. All of the above

Answer: A,C

Question No: 303 – (Topic 8)

Which of the following are prerequisite steps to transport a database? (Choose all that apply.)

  1. Query the V$TRANSPORTABLE_PLATFORMS view in the source database to determine if the intended destination is listed.

  2. Verify that there are no restrictions or limitations that the source or destination database may encounter.

  3. Verify that the source and destination have the same Oracle version, critical updates, patch-set version, and patch- set exceptions.

  4. Determine if you will perform the conversion on the source or destination platform.

  5. None of the above.

Answer: A,B,D

Question No: 304 – (Topic 8)

When performing a database duplication, which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location?

  1. log_file_name_convert

  2. convert_log_file_name

  3. file_name_convert_log

  4. redo_log_file_name_convert

  5. logfile_convert_directory

Answer: A

Question No: 305 – (Topic 8)

You are managing an Oracle Database 11g instance. You want to create a duplicate database for testing purpose.

What are the prerequisites for performing the active database duplication? (Choose all that apply.)

  1. The source database backup must be copied over the net for test database.

  2. The source database must be run in ARCHIVELOG mode if the database is open.

  3. The source database must be shut down cleanly if the database is in mounted state.

  4. A net service name should be set up and a listener configured with the target as well as the source database.

    Answer: B,C,D Explanation:

    To ensure that the source database is in the proper state:

    1. If the source database instance is not mounted or open, then mount or open it.

    2. If you are performing active database duplication, then ensure that the following additional requirements are met:

If the source database is open, then archiving must be enabled.

If the source database is not open, then the database does not require instance recovery. (Tips: does not require instance recovery, means you cannot shutdown the source database with abort option, you need to shutdown it cleanly.)

Starting RMAN and Connecting to Databases:

In this task, you must start the RMAN client and connect to the database instances required by the duplication technique chosen in quot;Step 1: Choosing a Duplication Techniquequot;. The RMAN client can be located on any host so long as it can connect to the necessary databases over the network.

Question No: 306 – (Topic 8)

As part of archiving the historical data, you want to transfer data from one database to another database, which is on another server. All tablespaces in the source database are read/write and online. The source and target databases use the same compatibility level and character sets. View the Exhibit and examine the features in the source and target database.

Which of the following steps are required to transport a tablespace from the database to the target database:

  1. Make the tablespace read-only at the source database.

  2. Export metadata from the source database.

  3. Convert data filed by using Recovery Manager (RMAN).

  4. Transfer the dump file and data filed to the target machine.

  5. Import metadata at the target database.

  6. Make the tablespace read/write at the target database. Exhibit:

    Latesttests 2018 PDF and VCE

    1. 2, 4, and 5

    2. All the steps C. 2, 3, 4 and 5 D. 1, 2, 4, 5 and 6

Answer: D Explanation:

Refer to here. Generate a Transportable Tablespace Set read_only-expdp-4-import-read_wrtie

1, 2, 4, 5, 6 (optional)

If both platforms have the same endianness, no conversion is necessary. Otherwise you must do a conversion of the tablespace set either at the source or destination database. Transport the dump file to the directory pointed to by the DATA_PUMP_DIR directory object, or to any other directory of your choosing.

Run the following query to determine the location of DATA_PUMP_DIR: SELECT * FROM DBA_DIRECTORIES WHERE DIRECTORY_NAME = #39;DATA_PUMP_DIR#39;;

Latesttests 2018 PDF and VCE


Transport the data files to the location of the existing data files of the destination database. On the UNIX and Linux platforms, this location is typically /u01/app/oracle/oradata/SID/ or

DISKGROUP/SID/ datafile/.

Question No: 307 – (Topic 8)

The following query will provide what information about transportable tablespaces for the current database? (Choose all that apply.)

Latesttests 2018 PDF and VCE

  1. The list of target platforms having the same endian format as the source database

  2. The list of target platforms requiring endian conversion

  3. The list of target platforms that will not require endian conversion

  4. The list of all target platforms that can receive transportable tablespaces from the source database

  5. None of the above

Answer: A,C

Question No: 308 – (Topic 8)

How many database instances are used during a database-duplication process?

  1. One

  2. Two

  3. Three

  4. Four

  5. Five

Answer: B

Question No: 309 – (Topic 8)

Which two statements are true about a duplicate database that is created by using the DUPLICATE command in RMAN? (Choose two.)

  1. It is a copy or a subset of the target database.

  2. It is opened in RESTRICT mode after a duplicating operation.

  3. It is created by using backups and archived redo log files from the target database.

  4. It is created with the same database identifier (DBID) as that of target database.

    Answer: A,C Explanation: Duplicating a Database

    Overview of RMAN Database Duplication

    Database duplication is the use of the DUPLICATE command to copy all or a subset of the data in a source database. The duplicate database (the copied database) functions entirely independently from the source database (the database being copied).

    Purpose of Database Duplication

    If you copy a database with operating system utilities instead of the DUPLICATE command, then the DBID of the copied database remains the same as the original database. To register the copy database in the same recovery catalog with the original, you must change the DBID with the DBNEWID utility (see Oracle Database Utilities). In contrast, the DUPLICATE command automatically assigns the duplicate database a different DBID so that it can be registered in the same recovery catalog as the source database.

    Backup-Based Duplication

    In backup-based duplication, RMAN creates the duplicate database by using pre-existing RMAN backups and copies. This technique of duplication uses one of the following mutually exclusive subtechniques: Duplication without a target database connection, RMAN obtains metadata about backups from a recovery catalog.

    Duplication without a target database connection and without a recovery catalog. RMAN obtains metadata about where backups and copies reside from BACKUP LOCATION.

    Duplication with a target database connection. RMAN obtains metadata about backups from the target database control file or from the recovery catalog.

    How RMAN Duplicates a Database

    For backup-based duplication, the principal work of the duplication is performed by the auxiliary channels. These channels correspond to a server session on the auxiliary instance on the destination host. For active database duplication the primary work is performed by target channels. RMAN must perform database point-in-time recovery, even when no explicit point in time is provided for duplication. Point-in-time recovery is required because the online redo log files in the source database are not backed up and cannot be applied to the duplicate database. The farthest point of recovery of the duplicate database is the most recent redo log file archived by the source database.

    As part of the duplicating operation, RMAN automates the following steps:

    1. Creates a default server parameter file for the auxiliary instance if the following conditions are true:

      ->Duplication does not involve a standby database.

      ->Server parameter files are not being duplicated.

      ->The auxiliary instance was not started with a server parameter file.

    2. Restores from backup or copies from active database the latest control file that satisfies the UNTIL clause requirements.

    3. Mounts the restored or copied backup control file from the active database.

    4. Uses the RMAN repository to select the backups for restoring the data files to the auxiliary instance. This step applies to backup-based duplication.

    5. Restores and copies the duplicate data files and recovers them with incremental backups and archived redo log files to a noncurrent point in time.

    6. Shuts down and restarts the database instance in NOMOUNT mode.

    7. Creates a new control file, which then creates and stores the new DBID in the data files.

    8. Opens the duplicate database with the RESETLOGS option and creates the online redo log for the new database.

      Question No: 310 – (Topic 8)

      You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB. You issued the following RMAN commands to create a duplicate database:

      Latesttests 2018 PDF and VCE

      Which three are the prerequisites for the successful execution of the above command? (Choose three.)

      1. The source database should be open.

      2. The target database should be in ARCHIVELOG mode if it is open.

      3. RMAN should be connected to both the instances as SYSDBA.

      4. The target database backups should be copied to the source database backup directories.

      5. The password file must exist for the source database and have the same SYS user password as the target.

Answer: B,C,E

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

Latesttests 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 Latesttests IT Certification PDF and VCE