[Free] 2018(Jan) EnsurePass Passguide Oracle 1z0-063 Dumps with VCE and PDF 81-90

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-063
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-063.html

Oracle Database 12c: Advanced Administration

Question No: 81

You are administering a database that supports a data warehousing workload and is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 incremental backups on allthe other days of the week.

One of the data files is corrupted and the current online redo log file is lost because of a media failure.

Which action must you take for recovery?

  1. Restore the data file, recover it by using the recover datafilenoredo command, and use the resetlogs option to open the database.

  2. Restore the control file and all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.

  3. Restore all the data files, recoverthem by using the recover database command, and open the database.

  4. Restore all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.

Answer: B

Question No: 82

Examine the command used to perform an incrementallevel-0 backup: RMANgt;BACKUPINCREMENTALLEVEL0DATABASE;

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

SQLgt;ALTERDATABASEENABLEBLOCKCHANGETRACKINGUSING

FILE#39;/mydir/rman_change_track.f#39;;

To perform an incremental level-1 cumulative backup, you issue the command: RMANgt;BACKUPINCREMENTALLEVEL1CUMULATIVEDATABASE;

Which two statements are true in the preceding situation?

  1. The block change tracking data is used only from the next incremental backup.

  2. The incremental level 1 backup fails because a block change tracking file Is created after the level 0 backup.

  3. The incremental level 1 backup does not use change tracking data for accomplishing the

    backup.

  4. The block change tracking file scans all blocks and creates a bitmap for the blocks backed up in the level 0 backup.

  5. The block change tracking data is used for the next incremental level 1 backup only after the next level 0 backup.

Answer: C,E

Question No: 83

Examine the initialization parameter that is set in the PFILE: DB_CREATE_FILE_DEST =#39;/u01/app/oracle/oradata/#39;

You execute the following command to create theCDB1. container database (CDB):

SQLgt;CREATEDATABASECDB1 DEFAULTTABLESPACE users DEFAULTTEMPORARY TABLESPACEtemp

UNDO TABLESPACEundotbsl ENABLEPLUGGA3LEDATABASE SEED

SYSTEMDATAFILESSIZE125M AUTOEXTEND ON NEXT10M MAXSIZEUNLIMITED SYSAUXDATAFILESSIZE100M;

Which three statements are true?

  1. It creates a multitenant container database with a root and a seed pluggable database (PDB) that are opened in read-write and read-only modes, respectively.

  2. The files created for both the root and seed databases use Oracle Managed Files (OMF).

  3. It creates a multitenant container database with the root and seed databases opened and one PDB mounted.

  4. It sets the users tablespace as the default for both the root and seed databases.

  5. undotbs1 is used as the undo tablespace for both the root and seed databases.

  6. It creates a multitenant container database with the root database opened and the seed database mounted.

Answer: A,B,E

Question No: 84

Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)?

  1. Database Resident Connection Pooling

  2. Oracle Suggested Backup Strategy

  3. Database Vault in ORACLE_HOME

  4. Nondefaultblocksizetablespaces

  5. Configure Label Security

Answer: D,E

Question No: 85

Examine the command:

SQLgt;RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;

In which two scenarios is this command required?

  1. The current online redo log file is missing.

  2. A data file belonging to a noncritical tablespace is missing.

  3. All the control files are missing.

  4. The database backup is older than the control file backup.

  5. All the data files are missing.

Answer: C,D

Explanation: http://searchoracle.techtarget.com/answer/Recover-database-using-backup- controlfile-until-cancel

Question No: 86

Examine the RMAN commands executed in your database:

RMANgt;CONFIGUREDEFAULT DEVICE TYPE TO disk; RMANgt;CONFIGURE DEVICETYPE DISK BACKUP TYPE TO BACKUPSET; RKANgt; CONFIGURE CONTROLFILE AUTOBACKUP ON;

You issue the command: RMANgt; BACKUP DATABASE;

Which two statements are true about the command?

  1. It performs a log switch.

  2. It creates compressed backup sets by using binary compression by default.

  3. It backs up only the used blocks in data files.

  4. It backs up data files, the control file, and the server parameter file.

  5. It creates a backup of only the control file whenever the database undergoes a structural change.

Answer: B,E

Question No: 87

Examinethe commands:

SQLgt; ALTER SESSION SET RECYCLBIN = ON;

Session altered.

SQLgt; DROP TABLE emp; -(First EMP table) Total dropped.

SQLgt; CREATE TABLE emp (id NUMBER CONSTRAINT emp_id_idx PRIMARY KEY, name VARCHAR2 (15), salary NUMBER(7,2) );

Table created.

You then execute multiple INSERT statements to insert rows into EMP table and drop the

table again:

SQLgt; DROP TABLE emp; – (Second EMP table) Table dropped.

SQLgt; FLASHBACK TABLE emp TO BEFORE DROP;

Which statement is true about the FLASHBACK command?

  1. It recovers the structure, data, and indexes of the first emp table.

  2. It recovers only the structure of the second emp table.

  3. It returns an error because two tables with the same name exist in the recycle bin.

  4. It recovers the structure, data, and indexes of the second emp table.

Answer: A

Question No: 88

Which three statements are true about Oracle Secure Backup (OSB)?

  1. It can encrypt client data written to tape.

  2. It can be used to take image copy backups to tape.

  3. It can be used to manage tape backup and restore operations for multiple databases.

  4. It can be used along with an RMAN recovery catalog for maintaining records of backups in a tape library.

  5. It can be used to perform file system backups at the file, directory, file system, or raw partition level.

Answer: A,C,E

Question No: 89

While performing database backupto tape via the media manager interface, you notice that tape streaming is not happening because RMAN is not sending data blocks fast enough to the tape drive.

Which two actions would you take for tape streaming to happen during the backup?

  1. Configure backup optimization.

  2. Configure the channel to increase maxopenfiles.

  3. Configure a backup policy by using incremental backups.

  4. Configure the channel to increase capacity with the rate parameter.

  5. Configure the channel to adjust the tape buffer size byusing the 3LKSIZE option.

  6. Configure large_pool, if not done already. Alternatively, you can increase the size of

  7. LARGE_POOL.

Answer: A,D

Question No: 90

Examine the command:

$expdp SYSTEM FULL=YES DUMPFILE=dpump_dir1:fulll%U.dmp, dpump_dir2:full2% U.dmp, dpump_dir3:full3%U.djnp FILESIZE=400M PARALLEL=3 JOB_NAME=expfull

Which statement is true about the execution of the command?

  1. It fails because the log file parameter is not specified.

  2. It fails because no absolutepath is specified for the log file and dump file.

  3. It succeeds and exports the full database, simultaneously creating three copies of dump files at three different locations.

  4. It succeeds and exports the full database, simultaneously creating three dump files at three different locations, but the total number of dump files can exceed three.

Answer: B

100% Ensurepass Free Download!
Download Free Demo:1z0-063 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-063 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *