Use Real 1z0-063 - 100% Cover Real Exam Questions [Jan-2022]
Dumps Brief Outline Of The 1z0-063 Exam - PracticeTorrent
NEW QUESTION 149
Which two statements are true about tablespaces in multitenant container databases (CDBs)? (Choose
two.)
- A. Each PDB can have its own default temporary tablespace.
- B. The default permanent tablespace for a PDB can be changed only by a local user with the required
permissions. - C. The amount of space that each PDB can use in a shared temporary tablespace must be set at the CDB
level. - D. The current container must be set to root to create or modify the default temporary tablespace or
tablespace group for a CDB. - E. Default permanent tablespaces can be shared across pluggable databases (PDBs).
Answer: A,D
NEW QUESTION 150
Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?
- A. The PDB does not close and the temp file is re-created automatically whenever the container database (CDB) is opened.
- B. The PDB does not close and starts by using the default temporary tablespace defined for the CDB.
- C. The PDB is closed and requires media recovery at the PDB level.
- D. The PDB is closed and the temp file is re-created automatically when the PDB is opened.
Answer: A
NEW QUESTION 151
Which three statements are true about the database instance startup after an instance failure? (Choose three.)
- A. The RECO process recovers the uncommitted transactions at the next instance startup.
- B. Online redo log files and archived redo log files are required to complete the rollback stage of instance recovery.
- C. Uncommitted changes are rolled back to ensure transactional consistency.
- D. Media recovery is required to complete the database recovery.
- E. Changes committed before the failure, which were not written to the data files, are re-applied.
- F. The SMON process coordinates the database recovery.
Answer: A,C,F
Explanation:
A: Occasionally a database closes abnormally with one or more distributed transactions in doubt (neither committed nor rolled back). When you reopen the database and recovery is complete, the RECO background process automatically, immediately, and consistently resolves any in-doubt distributed transactions.
C: Crash and instance recovery involve two distinct operations: rolling forward the current, online datafiles by applying both committed and uncommitted transactions contained in online redo records, and then rolling back changes made in uncommitted transactions to their original state.
D: The SMON background process performs instance recovery, applying online redo automatically. No user intervention is required.
References:
https://docs.oracle.com/cd/B28359_01/server.111/b28318/startup.htm
https://docs.oracle.com/database/121/CNCPT/startup.htm
NEW QUESTION 152
What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?
- A. statistics recommendations
- B. creation of materialized views to improve query performance
- C. SQL statement restructure recommendations
- D. SQL profile recommendations
Answer: D
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 153
Examine the command:
Which statement is true about the execution of the command?
- A. It fails because no absolute path is specified for the log file and dump file.
- B. It fails because the log file parameter is not specified.
- C. It succeeds and exports the full database, simultaneously creating three copies of dump files at three different locations.
- D. 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: D
NEW QUESTION 154
Which two methods can be used to add an Oracle 11g database to a multitenant container database (CDB) as a pluggable database (PDB)? (Choose two.)
- A. Pre-create a PDB in CDB and use data pump to load data from the complete database export of the Oracle 11g database into the newly created PDB.
- B. Upgrade the Oracle 11g database to a 12c non-CDB and use the DBMS_PDB.DESCRIBEprocedure to plug the database as a new PDB into the CDB.
- C. Use the CREATE DATABASE ... ENABLE PLUGGABLE DATABASEstatement to create a PDB by copying data files from PDB$SEEDand use data pump to load data from the Oracle 11g database into the newly created PDB.
- D. Use the DBMS_PDBpackage to plug the Oracle 11g database into the existing CDB as a PDB.
- E. Pre-create a PDB in CDB and use the NETWORK_LINKand PARALLELparameters with data pump import to import data from the Oracle 11g database to the newly created PDB.
Answer: B,E
NEW QUESTION 155
You created a database with DBCA by using one of the Oracle supplied templates.
Which is the default permanent tablespace for all users except DBSNMP and OUTLN?
- A. EXAMPLE
- B. SYSTEM
- C. SYSAUX
- D. USERS
Answer: B
Explanation:
Explanation/Reference:
NEW QUESTION 156
RMAN is configured to create backupset backups for your database. You issue the command to back up the database:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which two statements are true about the backup performed by the command? (Choose two.)
- A. Only the used blocks in the data files are backed up.
- B. It backs up only those archived log files that are not backed up at least once.
- C. It backs up all archived redo log files and online log files and deletes the archived log files after the backup is complete.
- D. It backs up all the data files and deletes obsolete backups after the backup is complete.
- E. It backs up all the archived log files and deletes the ones that were just backed up.
Answer: D,E
Explanation:
Explanation
You can use BACKUP ... DELETE to back up archived redo logs, data file copies, or backup sets and then delete the input files after successfully backing them up.
The BACKUP ARCHIVELOG ... DELETE INPUT command deletes archived log files after they are backed up. This command eliminates the separate step of manually deleting archived redo logs.
Oracle Database, Backup and Recovery User's Guide, 12 Release 2 (January 2017), page 9-31
NEW QUESTION 157
You execute the RMAN commands:
RMAN> BACKUP VALIDATE DATABASE;
RMAN> RECOVER CORRUPTION LIST;
Which task is performed by these commands?
- A. Corrupted blocks in the data files are checked and repaired before performing the database backup.
- B. Corrupted blocks, if any, are repaired in the backup created.
- C. Only those data files that have corrupted blocks are backed up.
- D. The database is checked for physically corrupt blocks and any corrupted blocks are repaired.
Answer: A
NEW QUESTION 158
You regularly take backups of your database using RMAN with a recovery catalog. Your database is
currently open and the temp01.dbftemp file belonging to the TEMPtablespace is corrupted.
Identify two methods to recover the temp file with the least disruption to database availability. (Choose
two.)
- A. Drop the TEMPtablespace, and then re-create it with new temp files.
- B. Add a new temp file to the TEMPtablespace with a new name, and then drop the temp file that is
corrupted. - C. Take the TEMP tablespace offline, drop the missing temp file, and then create a new temp file.
- D. Restart the database instance to create the temp file automatically.
Answer: C,D
Explanation:
Explanation/Reference:
Explanation:
Temp files are a special class of data files that are associated only with temporary tablespaces.
B: After restore and recovery of a whole database, when the database is open, missing temporary
tablespaces that were recorded in the control file are re-created with their previous creation size,
AUTOEXTEND, and MAXSIZE attributes. Only temporary tablespaces that are missing are re-created. If a
temp file exists at the location recorded in the RMAN repository but has an invalid header, then RMAN
does not re-create the temp file.
If the temp files were created as Oracle-managed files, then they are re-created in the current
DB_CREATE_FILE_DEST location. Otherwise, they are re-created at their previous locations.
C: If a data file becomes missing or corrupted. You must take it offline before you can open the database.
References:
https://docs.oracle.com/database/121/ADMIN/dfiles.htm
https://docs.oracle.com/database/121/BRADV/rcmcomre.htm
NEW QUESTION 159
Your database supports an OLTP workload. Examine the output of the query:
To ensure faster instance recovery, you set the FAST_START_MTTR_TARGET initialization parameter to
30.
What is the effect of this setting on the database?
- A. The frequency of log switches is increased.
- B. The overhead on database performance is increased because of frequent writes to disk.
- C. The MTTR advisor is disabled.
- D. Automatic checkpoint tuning is disabled.
Answer: B
NEW QUESTION 160
Your database supports an online transaction processing (OLTP) workload and it needs to be up 24 x 7.
You want to perform a complete database backup by using RMAN.
Identify the minimum requirement for accomplishing the task.
- A. All tablespaces in the database must be locally managed.
- B. The database must be configured in ARCHIVELOGmode.
- C. Redo log groups must have at least two members each.
- D. An RMAN channel must be configured to device-type disk.
Answer: B
NEW QUESTION 161
Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and is affecting undo retention.
Which two actions would you take to solve this problem? (Choose two.)
- A. Enable Automatic Memory Management (AMM).
- B. Increase the size of the temporary tablespace.
- C. Enable undo retention guarantee.
- D. Increase the size of the redo log buffer.
- E. Enable temporary undo for the database.
Answer: B,E
NEW QUESTION 162
Examine the following set of RMAN commands:
Which statement is true about the RMAN RUN block execution?
- A. The execution of the script fails because multiple channels cannot exist simultaneously.
- B. The script is executed and both DC1 and CH1 channels are used for script execution.
- C. The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN RUN block.
- D. The new channel, CH1, is ignored because a channel has been configured already.
Answer: C
NEW QUESTION 163
Examine the following set of RMAN commands:
RKAN> CONFIGURE CHANNEL del DEVICE TYPE DISK FORMAT ' /u02/backup/%U' ;
RKAN> RUN
{
ALLOCATE CHANNEL chl DEVICE TYPE DISK;
EXECUTE SCRIPT arc_backup;
}
Which statement is true about the RMAN run block execution?
- A. The execution of the script fails because multiple channels cannot exist simultaneously.
- B. The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN run block.
- C. The script is executed and both DC1 and chi channels are used for script execution.
- D. The new channel, chi, is ignored because a channel has been configured already.
Answer: B
NEW QUESTION 164
Your multitenant container database (CDB) contains multiple pluggable databases (PDBs). You execute the command to create a common user:
SQL> CREATE USER c##a_admin
IDENTIFIED BY password
DEFAULT TABLESPACE users
QUOTA 100M ON users
TEMPORARY TABLESPACE temp;
Which statement is true about the execution of the command?
- A. The command succeeds only if all the PDBs have the USERS and TEMPtablespaces.
- B. The command succeeds and sets the default permanent tablespace of a PDB as the default tablespace for the C##A_ADMINuser if the USERStablespace does not exist in that PDB.
- C. The common user is created in the CDB and all the PDBs, and uses the users and temp tablespaces of the CDB to store schema objects.
- D. The command gives an error because the CONTAINER=ALLclause is missing.
Answer: A
NEW QUESTION 165
You need to perform a block media recovery on the tools01.dbfdata file in your database by using Recovery Manager (RMAN).
Which two are prerequisites for performing this operation? (Choose two.)
- A. You must configure a block change tracking file.
- B. You must use an incremental level-1 backup to restore blocks.
- C. You must have full or level-0 backups to restore blocks.
- D. You must take the tools01.dbfdata file offline.
- E. You must ensure that the database is mounted or open.
Answer: C,E
Explanation:
The target database must run in ARCHIVELOG mode and be open or mounted with a current control file.
The backups of the data files containing the corrupt blocks must be full or level 0 backups. They cannot be proxy copies or incremental backups.
References: Oracle Database, Backup and Recovery User's Guide, 12 Release 2 (January 2017), page 19-4
NEW QUESTION 166
Your multitenant container database (CDB) CDB1that is running in ARCHIVELOGmode contains two pluggable databases (PDBs), PDB2_1and PDB2_2, both of which are open. RMAN is connected to the target pluggable database PDB2_1.
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which statement is true about the execution of this command to back up the database?
- A. All data files belonging to PDB2_1are backed up and all archive log files are deleted.
- B. All data files belonging to PDB2_1are backed up along with the archive log files.
- C. This command gives an error because archive log files can be backed up only when RMAN is connected to the root container database.
- D. Only the data files belonging to pdb2_1are backed up.
Answer: B
Explanation:
Explanation/Reference:
NEW QUESTION 167
In your database, the tbs percent used parameter is set to 60 and the tbs percent free parameter is set to
20.
Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM) to automate data movement?
- A. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used
- B. Taking the target tablespace offline after the segments are moved
- C. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds T3S percent used
- D. Setting the target tablespace to read-only after the segments are moved
- E. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used
Answer: C,D
NEW QUESTION 168
You want to create a duplicate database DUP_DB from your production database PROD on the same host.
The PROD database uses Automatic Storage Management (ASM) for storage. Regular backups are taken using RMAN connected to a recovery catalog.
You create an auxiliary instance and want to execute the command:
What is a prerequisite for the successful execution of this command?
- A. The target database must be in MOUNT state.
- B. RMAN must be connected to the target database instance and the auxiliary instance.
- C. Flashback must be enabled for the PROD database.
- D. A most recent backup set of the PROD database must exist.
Answer: B
Explanation:
Explanation
Assume that the source database prod is on host1 and stores its data files in a non-ASM file system. The control files for prod are located in /oracle/oradata/prod/.
You want to duplicate the source database to database dupdb on remote host host2.
You want to store the duplicate database files in ASM disk group +DISK1.
After connecting RMAN to the target, duplicate, and recovery catalog databases, run the following RMAN script to duplicate the database.
DUPLICATE TARGET DATABASE TO dupdb
FROM ACTIVE DATABASE
SPFILE
PARAMETER_VALUE_CONVERT '/oracle/oradata/prod/', '+DISK1'
SET DB_CREATE_FILE_DEST +DISK1;
When the DUPLICATE command completes, the duplicate database is created, with data files, online redo log files, and control files in ASM disk group +DISK1.
References: Oracle Database, Backup and Recovery User's Guide, 12 Release 2 (January 2017), page 26-7
NEW QUESTION 169
When is the UNDO_RETENTION parameter value ignored by a transaction?
- A. when there are multiple undotablespaces available in a database
- B. when the undo tablespace is of a fixed size and retention guarantee is not enabled
- C. when the data file of the undo tablespace is autoextensible
- D. when Flashback Database is enabled
Answer: B
NEW QUESTION 170
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 D3_FLASH_CACHE_SIZE=64G, 64G.
- B. db_flash_cache_SI2E is automatically configured by the instance at startup.
- C. Set D3_FLASK_CACKE_SI2E=i28G.
- D. Set DB_FLASH_CACHE_SIZE=64G.
Answer: A
Explanation:
Explanation/Reference:
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
NEW QUESTION 171
You wish to create jobs to satisfy these requirements:
1. Automatically bulk load data from a flat file.
2. Rebuild indexes on the SALES table after completion of the bulk load.
How would you create these jobs?
- A. Create one job to rebuild indexes using application raised events and another job to perform bulk load using Scheduler raised events.
- B. Create one job to rebuild indexes using Scheduler raised events and another job to perform bulk load by using events raised by the application.
- C. Create both jobs by using Scheduler raised events.
- D. Create both jobs using application raised events.
Answer: A
NEW QUESTION 172
Which three conditions must be met before you Virtual Private Catalog (VPC) can be created and used by an Administrator? (Choose three.)
- A. A base recovery catalog must exist.
- B. The DBArole must be granted to the virtual catalog owner.
- C. The REGISTER DATABASE privilege should be granted to the virtual catalog owner.
- D. The owner of the VPC cannot own recovery catalog.
- E. At least one target database should be registered in the recovery catalog.
Answer: A,B,D
NEW QUESTION 173
......
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!
Certification Training for 1z0-063 Exam Dumps Test Engine: https://www.practicetorrent.com/1z0-063-practice-exam-torrent.html