100% Guarantee 1Z0-063 Dumps Questions 2021

NEW QUESTION 1
Which three factors influences the optimizer's choice of an execution plan? (Choose three.)

• A. Cardinality estimates
• B. The OPTIMIZER_MODE initialization parameter
• C. Fixed baselines
• D. Type of connection used to connect to database instance
• E. Object statistics in the data dictionary

Answer: ABE

NEW QUESTION 2
You restore and recover your database to a new host by using an existing RMAN open database backup. Which step must you perform next?

• A. Execute catproc.sql to recompile invalid PL/SQL modules.
• B. Open the database with the RESETLOGS option.
• C. Set a new database identifier (DBID) for the newly restored database.
• D. Use the RMAN SET NEWNAME and SWITCH commands to switch to new files.

Answer: B

NEW QUESTION 3
You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).
The following are the possible steps to accomplish this task:
1. Place all the user-defined tablespace in read-only mode on the source database.
2. Upgrade the source database to a 12c version.
3. Create a new PDB in the target container database.
4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.
5. Copy the associated data files and export the dump file to the desired location in the target database.
6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.
7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function. Identify the correct order of the required steps.

• A. 2, 1, 3, 4, 5, 6
• B. 1, 3, 4, 5, 6, 7
• C. 1, 4, 3, 5, 6, 7
• D. 2, 1, 3, 4, 5, 6, 7
• E. 1, 5, 6, 4, 3, 2

Answer: C

Explanation: This example 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:
* (1) Set user tablespaces in the source database to READ ONLY.
* (3) Create a CDB on the destination system, including a PDB into which you will import the source database.
* (4) 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.
* (5) Copy the tablespace data files from the source system to the destination system.
* (6) In the Oracle Database 12c environment, connect to the pre-created PDB and import the dump file.
References:
http://www.oracle.com/technetwork/database/upgrade/upgrading-oracle-database-wp-12c-1896123.pdf, page 11

NEW QUESTION 4
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? (Choose two.)

• A. 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
• B. Setting the target tablespace to read-only 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. Taking the target tablespace offline after the segments are moved
• E. 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

Answer: BC

NEW QUESTION 5
A complete database backup to media is taken for your database every day. Which three actions would you take to improve backup performance? (Choose three.)

• A. Set the backup_tape_io_slaves parameter to true.
• B. Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.
• C. Configure large pool if not already done.
• D. Remove the rate parameter, if specified, in the allocate channel command.
• E. Always use RMAN compression for tape backups rather than the compression provided by media manager.
• F. Always use synchronous I/O for the database.

Answer: BCD

NEW QUESTION 6
You create two Resource Manager plans, one for night time workloads, the other for day time. How would you make the plans switch automatically?

• A. Use job classes.
• B. Use scheduler windows.
• C. Use the mapping rule for the consumer groups.
• D. Set the switch_time plan directive for both plans.
• E. Use scheduler schedules.

Answer: B

NEW QUESTION 7
Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled? (Choose two.)

• A. Reduced logical I/O
• B. Reduced virtual memory utilization
• C. Improved Serial Execution performance
• D. Reduced physical I/O
• E. Reduced CPU utilization

Answer: BE

NEW QUESTION 8
Which two statements are true about making RMAN image copies of a database? (Choose two.)

• A. The can only be written to disk.
• B. The can be made only when the database is running in NOARCHIVELOG mode.
• C. They can be made only when the database is in MOUNT state.
• D. They consist of all used an unused blocks in the data files.
• E. They can be made only when the database is running in ARCHIVELOG mode.

Answer: AD

Explanation: An image copy can be written only to disk.
An image copy is the same as datafiles. The disadvantage of image copy backup mode is that it occupies much space and does not skip unused data blocks.
References:
http://www.dba-oracle.com/t_rman_10_image_copies.htm

NEW QUESTION 9
You regularly take backups of your database using RMAN with a recovery catalog. Your database is currently open and the temp01.dbf temp file belonging to the TEMP tablespace is corrupted.
Identify two methods to recover the temp file with the least disruption to database availability. (Choose two.)

• A. Drop the TEMP tablespace, and then re-create it with new temp files.
• B. Restart the database instance to create the temp file automatically.
• C. Take the TEMP tablespace offline, drop the missing temp file, and then create a new temp file.
• D. Add a new temp file to the TEMP tablespace with a new name, and then drop the temp file that is corrupted.

Answer: BC

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 10
Examine the command:
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
In which two scenarios is this command required? (Choose two.)

• A. The current online redo log file is missing.
• B. A data file belonging to a noncritical tablespace is missing.
• C. All the control files are missing.
• D. The control file backup is older than the database backup.
• E. All the data files are missing.

Answer: CD

NEW QUESTION 11
You want to consolidate databases for the CRM, ERP, and SCM applications by migrating them to pluggable databases (PDBs).
You have already created a test system to support the consolidation of databases in a multitenant container database (CDB) that has multiple PDBs.
What is the easiest way to perform capacity planning for consolidation?

• A. capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Performance Analyzer on the test system
• B. capturing the workload on the production system and replaying the workload for one PDB at a time on the test system
• C. capturing the workload on the production system and using Consolidated Database Replay to replay the workload of all production systems simultaneously for all PDBs
• D. capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Tuning Advisor on the test system

Answer: C

NEW QUESTION 12
Which two operations are NOT performed by the DUPLICATE command in RMAN while duplicating a database that is open? (Choose two.)

• A. creating a control file for the duplicate database
• B. restoring target data files to the duplicate database
• C. performing complete recovery by using all available backups
• D. generating a new, unique database identifier (DBID) for the duplicate database
• E. copying online redo log files from the target database to the duplicate database

Answer: CE

NEW QUESTION 13
You created a tablespace with this statement: CREATE BIGFILE TABLESPACE adtbs
DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G;
The tablespace is nearly full and you need to avoid any out of space errors for the load of a 5 gig table.
Which two alter statements will achieve this? (Choose two.)

• A. ALTER TABLESPACE adtbs RESI2E 20G;
• B. ALTER TABLESPACE adtbs ADD DATAFILE;
• C. ALTER TABLESPACE adtbs AUTOEXTEND ON;
• D. ALTER TABLESPACE adtbs ADD DATAFILE '/proddb/data/adtbsl.dbf' SIZE 1QG;
• E. ALTER TABLESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf AUTOEXTEND ON;

Answer: AC

Explanation: http://www.techonthenet.com/oracle/tablespaces/alter_tablespace.php

NEW QUESTION 14
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 all the 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?

• A. Restore the data file, recover it by using the recover datafilenoredo command, and use the resetlogs option to open the database.
• B. 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.
• C. Restore all the data files, recover them by using the recover database command, and open the database.
• D. 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

NEW QUESTION 15
Which two statements are true about RMAN duplexed backups? (Choose two.)

• A. It is only supported for backups to tape via media management interface.
• B. It is not supported for image copies.
• C. For performing duplexed backups, the parallelism for the device must be set equal to the number of copies.
• D. Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously.
• E. Duplex backups can contain only data files and control files.

Answer: BD

NEW QUESTION 16
You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent objects. During this operation, you want to ensure the following:

• A. Long-running queries are not affected.i
• B. No extra space is used.ii
• C. Data manipulation language (DML) operations on the table succeed at all times throughout the process.i
• D. Unused space is reclaimed both above and below the high water mar
• E. Which alter TABLE option would you recommend?
• F. DEALLOCATE UNUSED
• G. SHRINK SPACE CASCADE
• H. SHRINK SPACE COMPACT
• I. ROW STORE COMPRESS BASIC

Answer: C