Vivid of 1Z0-063 test preparation materials and bootcamp for Oracle certification for IT examinee, Real Success Guaranteed with Updated 1Z0-063 pdf dumps vce Materials. 100% PASS Oracle Database 12c: Advanced Administration exam Today!
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-063 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 1Z0-063 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/1Z0-063-exam-dumps.html
Q61. In which three scenarios is media recovery required?
A. when a tablespace is accidentally dropped from a database
B. when archived redo log files are lost
C. when data files are lost
D. when one of the online redo log members is corrupted
E. when all control files are lost
Answer: A,C,E
Reference:http://docs.oracle.com/cd/A87860_01/doc/server.817/a76993/recoscen.htm
Q62. 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?
A. Configure backup optimization.
B. Configure the channel to increase maxopenfiles.
C. Configure a backup policy by using incremental backups.
D. Configure the channel to increase capacity with the rate parameter.
E. Configure the channel to adjust the tape buffer size byusing the 3LKSIZE option.
F. Configure large_pool, if not done already. Alternatively, you can increase the size of
G. LARGE_POOL.
Answer: A,D
Q63. In the SPFILE, UNDOJTABLESPACEis Set to UNDOTBS.
You rename the undotbs undo tablespace:
ALTER TABLESPACE undotbs RENAME TO undotbs_old;
Which statement is true?
A. The tablespace will be renamed but the data file headers will not be updated.
B. The statement will fail because you cannot rename an undo tablespace.
C. The tablespace will be renamed and all the changes will be logged in the alert log.
D. The tablespace will be renamed and a message written to the alert log indicating that you should change the corresponding initialization parameter.
E. You must set the undo_tablespace parameter to some other tablespace name before renaming undotbs.
Answer: C
Q64. As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single-instance database.
Which step should you perform next to start the upgrade of the database?
A. Start up the database instance by using the new location of the server parameter file and run the catuppst.sqi script to generate informational messages and log files duringthe upgrade.
B. Start up the database instance by using the new location of the server parameter file and run the cact1.pl script from the new Oracle home to use parallel upgrade options that reduce down time.
C. Start up the database instance by using theSTARTUP UPGRADE command and gather fixed object statistics to minimize the time needed for recompilation.
D. Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade operations.
Answer: C
Q65. Examine the command to back up the ASM metadata:
ASMCMD>md_backup /backup/ASM_backup
In which three situations can you use the backup?
A. when one or more disks in an ASM disk group are lost
B. when the data file on an ASM disk group gets corrupted
C. when one of the disks in a disk group is accidentally unplugged
D. when one or more file directory paths are accidentally deleted from an ASM disk group
E. when all the ASM disk groups for the ASM instance are lost
Answer: B,C,D
Q66. You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the db_smart_flash_file parameter:
DB_FLASH_CACHE_FILE= ‘ /dev/f lash_device_1‘,‘ /dev/f lash_device_2‘
How should the D3_flash_cache_size be configured to use both devices?
A. Set DB_FLASH_CACHE_SIZE=64G.
B. Set D3_FLASH_CACHE_SIZE=64G, 64G.
C. Set D3_FLASK_CACKE_SI2E=i28G.
D. db_flash_cache_SI2E is automatically configuredby the instance at startup.
Answer: B
Explanation: * Smart Flash Cache concept is not new in Oracle 12C - DB Smart Flash
Cache in Oracle 11g.
In this release Oracle has made changes related to both initialization parameters used by
DB Smart Flash cache. Now you can define many files|devices and its sizes for “Database
Smart Flash Cache” area. In previous releases only one file|device could be defined.
DB_FLASH_CACHE_FILE = /dev/sda, /dev/sdb, /dev/sdc
DB_FLASH_CACHE_SIZE = 32G, 32G, 64G
So above settings defines 3 devices which will be in use by “DB Smart Flash Cache”
/dev/sda – size 32G
/dev/sdb – size 32G
/dev/sdc – size 64G
New view V$FLASHFILESTAT – it’s used to determine the cumulative latency and read
counts of each file|device and compute the average latency
Q67. Your database is running in archivelog mode. You are taking a backup of your database by using RMAN with a recovery catalog. Because of a media failure, one of the data files and all the control files are lost.
Examine the steps to recover the database:
1.Restore the control filesby using the RMAN restore controlfile command.
2.Mount the database.
3.Restore the data files by using the RMAN restore database command.
4.Open the database with the resetlogs option.
5.Recover the data files by using the RMAN recover using backup controlfile command.
6.
Start the database instance in nomount state.
7.
Connect to the target database by using a recovery catalog.
8.Open the database.
9.Restore the data file.
10.Recover the data file.
Identify the required steps in the correct order.
A. 7,6, 1, 2, 3, 5, 4
B. 7, 2, 1, 3, 5, 8
C. 7, 6, 1, 2, 9, 10, 8
D. 7, 6, 1, 2, 9, 10, 4
Answer: D
140. You want RMAN to make duplicate copies of data files when using the backup command.
What must you set using the RMAN configure command to achieve this?
A. MAXSETSIZE TO 2;
B. DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
C. CHANNEL DEVICE TYPE DISK FORMAT '/disk1/%U' , '/disk2/%U'
D. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
Answer: D
e:http://docs.oracle.com/cd/B14117_01/server.101/b10734/rcmconfg.htm
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmconfa.htm#BRADV137
Q68. Which three statements are true about persistent lightweight jobs?
A. A user cannot set privileges on them.
B. They generate large amounts of metadata.
C. They may be created as fully self-contained jobs.
D. They must reference an existing Scheduler Program.
E. The are useful when users need to create a large number of jobs quickly.
Answer: A,D,E
Q69. Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2. RMAN is connected to the target database pdb2_1.
Examine the command executed to back up pdb2_1:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which statement is true about the execution of this command?
A. It fails because archive log files cannot be backed up using a connection to a PDB.
B. It succeeds but only the data files belonging to the pdb2_i pluggable database are backed up.
C. It succeeds andall data files belonging to PD32_i are backed up along with the archive log files.
D. It fails because the pluggable clause is missing.
Answer: C
Q70. Examine the command to create a pluggable database (PDB):
SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1
FILE_NAME-_CONVERT = ('/disk1/oracle/pdb1/', '/disk2/oracle/pdb2/’) PATH_PREFIX= '/disk2/oracle/pdb2'
Which two statements are true?
A. The pluggable database pdb2 is created by cloning pdb1 and is in mount state.
B. Details about the metadata describing pdb2 are stored in an XML file in the '/disk2/oracle/pdb2/' directory.
C. The tablespace specifications of pdb2 are the same as pdb1.
D. All database objects belonging to common users in PD3I are cloned in PD32.
E. pdb2 is created with its own private undo and temp tablespaces.
Answer: A,C
Reference:http://oracle-info.com/2013/07/27/12c-database-create-pdbs-plug-unplug/(see the table, 4throw)