[Dec-2021] 1z0-063 Dumps are Available for Instant Access using PassCollection
1z0-063 Dumps 2021 - New Oracle 1z0-063 Exam Questions
NEW QUESTION 148
Which three statements are true about Oracle Secure Backup (OSB)? (Choose three.)
- A. It can be used to perform file system backups at the file, directory, file system, or raw partition level.
- B. It can be used along with an RMAN recovery catalog for maintaining records of backups in a tape library.
- C. It can be used to take image copy backups to tape.
- D. It can be used to manage tape backup and restore operations for multiple databases.
- E. It can encrypt client data written to tape.
Answer: A,D,E
NEW QUESTION 149
You want to duplicate one of your databases when connected to the target database and to the recovery catalog.
Which three are true about this type of database duplication? (Choose three.)
- A. The duplication process can create backup sets or image copies.
- B. The target database must be in mount state.
- C. The target database must be open.
- D. The duplication process pushes image copies to the auxiliary instance.
- E. The duplication process pushes backup sets to the auxiliary instance.
- F. The duplication process can use existing backup sets or image copies.
Answer: B,C,E
Explanation:
Explanation/Reference:
Reference https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/DUPLICATE.html#GUID- E13D8A02-80F9-49A2-9C31-92DD3A795CE4
NEW QUESTION 150
A database instance uses an SPFILE. Examine the parameter:
You plan to multiplex the control file to a new location, parallelization for the backup
set./u01/app/oracle/oradata/cdb1/disk3/control03.ctl/.
Examine the possible steps that are in random order:
1. Shut down the database instance.
2.Issue ALTER SYSTEM SET CONTROL_FILES='/u01/app/oracle/oradata/cdb1/disk1/
control01.ctl, /u01/app/oracle/oradata/cdb1/disk2/control02, ctl,
/ u01/app/oracle/oradata/cdb1/disk3/control03.ctl'
SCOPE=SPFILE;.
3. Issue ALTER SYSTEM SET CONTROL_FILES
' /u01/app/oracle/oradata/cdb1/disk1/control01.ctl, /u01/app/oracle/oradata/
cdb1/disk2/control02.ctl, /u01/app/oracle/oradata/cdb1/disk3/control03.ctl';.
4. Copy the control file from the existing location to '/u01/app/oracle/oradata/cdb1/disk3/
control03.ctl'.
5. Mount the database.
6. Open the database.
Identify the required steps in the correct order to accomplish the task.
- A. 2, 6
- B. 1, 5, 2, 4, 6
- C. 3, 1, 4, 6
- D. 2, 1, 4, 6
- E. 3, 4
Answer: D
NEW QUESTION 151
You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).
Examine the steps required to perform the migration:
1. Use Data Pump export to perform a full transportable export on the source database with the export parameter VERSION=12.
2. Place all tablespaces in read-only mode on the source database.
3. Upgrade the source database to Oracle Database 12c.
4. Copy the dump file and data files to the desired location in the target database.
5. Create a new PDB in the target CDB.
6. Synchronize the PDB on the target CDB.
7. Use Data Pump import on the new PDB by using the full transportable import options.
Identify the required steps in the correct order.
- A. 3, 2, 5, 1, 4, and 7
- B. 2, 5, 1, 4, 7, and 6
- C. 2, 1, 3, 5, 7, and 6
- D. 1, 5, 4, 7, and 6
Answer: B
Explanation:
Explanation
This example is a dumpfile-based full transportable export/import operation. In this case the metadata from the source database is exported to a dump file, and both the dump file and the tablespace data files are transferred to a new system. The steps would be as follows:
* (2) Set user tablespaces in the source database to READ ONLY.
* (5) Create a CDB on the destination system, including a PDB into which you will import the source database.
* (1) From the Oracle Database 11g Release 2 (11.2.0.3) environment, export the metadata and any data residing in administrative tablespaces from the source database using the FULL=Y and TRANSPORTABLE=ALWAYS parameters. Note that the VERSION=12 parameter is required only when exporting from an Oracle Database 11g Release 2 database.
* (4) Copy the tablespace data files from the source system to the destination system.
* (7) In the Oracle Database 12c environment, connect to the pre-created PDB and import the dump file.
http://www.oracle.com/technetwork/database/upgrade/upgrading-oracle-database-wp-12c-1896123.pdf, page 11
NEW QUESTION 152
You are connected to a recovery catalog and target database. You execute the command:
RMAN> CATALOG START WITH '/disk1/backups';
Which statement is true?
- A. Only valid backup pieces and archived logs, existing in the /disk1/backups directory, are cataloged.
- B. It lists all data file copies, backup pieces, and achieved logs cataloged in the recovery catalog in the
/disk1/backups directory and its subdirectories. - C. Only valid data file copies, existing in the /disk1/backups directory, are cataloged.
- D. It lists and catalogs all valid data file copies, backup pieces, and archived logs that exist in all directory paths with the prefix /disk1/backups and their subdirectories.
Answer: D
Explanation:
Explanation
If you have data file copies, backup pieces, or archived logs on disk, then you can catalog them in the recovery catalog with the CATALOG command.
The following command catalogs all files in all of these directories, because /disk1/backups is a prefix for the paths for all of these directories:
CATALOG START WITH '/disk1/backups';
To catalog only backups in the /disk1/backups directory, the correct command is as follows:
CATALOG START WITH '/disk1/backups/';
https://docs.oracle.com/database/121/BRADV/rcmcatdb.htm
NEW QUESTION 153
In CDB$ROOTof your multitenant container database (CDB), you create a common user, C##A_ADMIN.
and then execute the command:
Which statement is true?
- A. The command executes successfully, enabling the C##A_ADMIN user to create tablespaces in the root database, as well as in the pluggable databases (PDBs).
- B. The command fails because system privileges cannot be granted to a common user.
- C. The command executes successfully, enabling the C##A_ADMIN user to create a tablespace only in the root database.
- D. The command fails because the CONTAINERclause is not used.
Answer: D
Explanation:
Explanation/Reference:
Explanation:
For commonly granted privileges the grantor must be connected to the root and must specify CONTAINER=ALL in the GRANT statement.
References: https://docs.oracle.com/database/121/DBSEG/authorization.htm
NEW QUESTION 154
Examine the command:
Which statement is true about the execution of the command?
- A. 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.
- B. It fails because no absolute path is specified for the log file and dump file.
- C. It succeeds and exports the full database, simultaneously creating three copies of dump files at three different locations.
- D. It fails because the log file parameter is not specified.
Answer: A
NEW QUESTION 155
You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded.
Sometimes, you are not able to connect to the database instance because it hangs.
How can you detect the cause of the degraded performance?
- A. by running ADDM to fetch information from the latest Automatic Workload Repository (AWR)
snapshots - B. by using Active Session History (ASH) data and performing hang analysis
- C. by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM)
to fetch data directly from SGA for analysis - D. by running ADDM in diagnostic mode
Answer: C
NEW QUESTION 156
You execute the command to recover your database:
Which statement is true?
- A. It restores all data files from the specified time, and then applies the redo logs.
- B. It restores all data files and control files from the most recent backup taken before the "until time", and then recovers up to the "until time" using any restored archive logs that are needed to complete the task.
- C. It restores the control file and all data files from the most recent backups, and then applies the redo logs up to the "until time".
- D. It restores all data files, redo log files, and control files, and then applies the redo logs up to the specified time.
Answer: B
Explanation:
Explanation
UNTIL TIME = 'date_string' specifies a time as an upper limit. RMAN selects only files that can be used to restore and recover up to but not including the specified time.
RMAN can perform recovery of the whole database to a specified past time, SCN, or log sequence number.
This type of recovery is sometimes called incomplete recovery because it does not completely use all of the available redo. Incomplete recovery of the whole database is also called database point-in-time recovery (DBPITR).
DBPITR requires restoring your database from an older backup, then performing media recovery until your specified target time, SCN or log sequence number. Note that because you need your archived redo log files to perform this process, you cannot perform database point-in-time recovery if you have been running your database in NOARCHIVELOG mode.
References: https://docs.oracle.com/cd/B13789_01/server.101/b10734/rcmrecov.htm
NEW QUESTION 157
Your database is running in archivelog mode and regular nightly backups are taken. Due to a media
failure, the current online redo log group, which has one member, is lost and the instance is aborted.
Examine the steps to recover the online redo log group and move it to a new location.
1. Restore the corrupted redo log group.
2. Restore the database from the most recent database backup.
3. Perform an incomplete recovery.
4. Relocate the member of the damaged online redo log group to a new location.
5. Open the database with the resetlogs option.
6. Issue a checkpoint and clear the log.
Identify the required steps in the correct order.
- A. 6, 4, 3, 5
- B. 1, 3, 4, 5
- C. 6, 3, 4, 5
- D. 2, 3, 4, 5
Answer: D
NEW QUESTION 158
Examine the RMAN command:
Which statement is true about the command?
- A. It uses asynchronous I/O for the backup.
- B. It uses multisection backup.
- C. It uses parallelization for the backup set.
- D. It creates compressed backup sets.
Answer: C
Explanation:
Explanation/Reference:
SBT stands for Serial Backup Tape.
Configuring Parallel Channels for Disk and SBT Devices
The number of channels available for a device type when you run a command determines whether RMAN reads or writes in parallel. As a rule, the number of channels used in executing a command should match the number of devices accessed.
For tape backups, allocate one channel for each tape drive.
References: Oracle Database, Backup and Recovery User's Guide, 12 Release 2 (January 2017), page 5-
6
NEW QUESTION 159
Examine the output:
SQL> ARCHIVE LOG LIST
Database log modeArchive Mode
Automatic archival Enabled
Archive DestinationUSE_DB_RECOVERY_FILE_DEST
Oldest online log sequence376
Next log sequence to archive378
Current log sequence378
Which three types of files are automatically placed in the fast recovery area? (Choose three.)
- A. Flashback data archives (FDA)
- B. Archived redo log files
- C. Server parameter file (SPFILE)
- D. Recovery Manager (RMAN) backup pieces
- E. Control file autobackups
Answer: B,D,E
NEW QUESTION 160
Your database instance is started using an SPFILE. You are connected to cdb$root, as a DBA. You issue:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH;
Which two statements are true about the statistics level parameter?
- A. It is immediately set to all in all PDBs where the statistics_level parameter is not set.
- B. It is immediately set to all in the SPFILE and the CDB instance.
- C. It is immediately set to all in only those pluggable databases (PDBs) where the value is set to typical.
- D. It is set to all for all PDBs only in the SPFIL
- E. It is immediately set to all only for cd3Sroot.
Answer: B,C
NEW QUESTION 161
Examine these RMAN commands:
Which two statements are true about the DUPLICATE command?
- A. It fails because no parallel channels are allocated for the auxiliary database.
- B. It succeeds.
- C. It fails because connection to the AUXILIARY instance must be as SYSDBA.
- D. No catalogued backup of the TARGET is used to duplicate the database.
- E. It succeeds only if the target database is greater than 400M.
Answer: E
NEW QUESTION 162
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
NEW QUESTION 163
Your database is on ARCHIVELOGmode and an incremental backup exists.
A media failure in the loss of a data file and an online redo log.
Examine these commands:
1. STARTUP NOMOUNT
2. STARTUP MOUNT
3. RESTORE DATABASE
4. RECOVER DATABASE
5. RECOVER DATABASE UNTIL CANCEL
6. ALTER DATABASE OPEN
7. ALTER DATABASE OPEN RESETLOGS
Which commands are required to recover your database?
- A. 2, 3, 5, and 7
- B. 2, 3, and 4
- C. 2, 3, 5, and 6
- D. 1, 3, and 4
- E. 1, 3, 5, and 6
Answer: D
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E25178_01/backup.1111/e10642/rcmadvre.htm
NEW QUESTION 164
You are required to migrate your 11.2.0.3 database to an Oracle 12c database.
Examine the list of steps that might be used to accomplish this task:
1. Place all user-defined tablespaces in read-only mode on the source database.
2. Use the RMAN convert command to convert data files to the target platform's endian format, if required.
3. Perform a full transportable export on the source database with the parameters
VERSI0N=12, TRANSPORTABLE=ALWAYS, and FULL=Y.
4. Transport the data files for all the user-defined tablespaces.
5. Transport the export dump file to the target database.
6. Perform an import on the target database by using the full, network_link, and transportable_datafiles
parameters.
7. Perform an import on the target database by using the full and transportable_datafiles parameters.
Identify the required steps in the correct order.
- A. 1, 3, 5, 4, 2, and 7
- B. 2, 4, 5, 6, and 7
- C. 1, 2,4, and 7
- D. 1, 2, 4, 6, 5, 3, and 7
Answer: A
NEW QUESTION 165
......
Conclusion
Now that you are clearly familiar with all the intricacies of the Oracle Database 12c: Advanced Administration 1Z0-063 exam, namely its objectives, process, and revision materials, you can see how having this certification can affect your future and career development. Even if you are already an Oracle Database 12c Administrator Certified Professional, don't be satisfied with what has been achieved. Set a new goal for yourself in the form of another prestigious certificate, start preparing for the related test with only credible sources, and continue on your career ladder, which will help you see new opportunities and/or stand out from other applicants for your desired position. Take the first step. After all, it is up to you!
Oracle 1z0-063 Exam Practice Test Questions: https://www.passcollection.com/1z0-063_real-exams.html
Free 1z0-063 Braindumps Download Updated: https://drive.google.com/open?id=10N8w6vWHVN2AnqpOWxcZX08_0c4P271-
