Actual 1Z0-063 Exam Dumps 2021

NEW QUESTION 1
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. 3, 4
• B. 2, 1, 4, 6
• C. 3, 1, 4, 6
• D. 1, 5, 2, 4, 6
• E. 2, 6

Answer: B

NEW QUESTION 2
For which three pieces of information can you use the RMAN LIST command? (Choose three.)

• A. stored scripts in the recovery catalog
• B. available archived redo log files
• C. backup sets and image copies that are obsolete
• D. backups of tablespaces
• E. backups that are marked obsolete according to the current retention policy

Answer: ABD

NEW QUESTION 3
Which two statements describe the relationship between a window, a resource plan, and a job class? (Choose two.)

• A. A window specifies a resource plan that will be activated when that window becomes active.
• B. A window specifies a job class that will be activated when that window becomes active.
• C. A job class specifies a window that will be open when that job class becomes active.
• D. A window in association with a resource plan controls a job class allocation.
• E. A window in association with a job class controls a resource allocation.

Answer: AE

NEW QUESTION 4
A user issues a query on the sales table and receives the following error: ERROR at line 1:
ORA-01565: error in identifying file '/u0l/app/oracle/oradata/ORCL/temp01.dbf' ORA-27037: unable to obtain file status
Which two actions would you take to recover the temporary tablespace? (Choose two.)

• A. Drop the tenp01.dbf file, and then re-create the temp file.
• B. Add a new temp file to the temporary tablespace and drop the temp01.dbf file.
• C. Shut down the database instance, start up the database instance in mount state, create a new temporary tablespace, and then open the database.
• D. Take the temporary tablespace offline, recover the missing temp file, and then bring the temporary tablespace online.
• E. Create a new temporary tablespace and assign it as the default to the user.

Answer: BE

NEW QUESTION 5
Your multitenant container database (CDB) CDB1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command:
SQL> STARTUP
Which two statements are true about the successful execution of the command? (Choose two.)

• A. All redo log files are opened.
• B. The root, the seed, and all the PDBs are opened in read-write mode.
• C. All the PDBs are opened in read-write mode.
• D. All the PDBs are in closed state.
• E. Only the root database is opened in read-write mode.

Answer: AE

NEW QUESTION 6
You accidentally drop the CUSTOMERS table, and then recover it by using the FLASHBACK TABLE command.
Which two statements are true about the dependent objects of the CUSTOMERS table? (Choose two.)

• A. Only the primary key constraint created for the table is flashed back, whereas all other indexes must be retrieved separately.
• B. All the constraints defined on the table, except the referential integrity constraints, are flashed back.
• C. All the triggers associated with the table are flashed back but are disabled.
• D. Materialized views that use the CUSTOMERS table are flashed back.
• E. LOB segments associated with the CUSTOMERS table are flashed back.

Answer: BE

Explanation: B: Oracle Database retrieves all indexes defined on the table except for bitmap join indexes, and all triggers and constraints defined on the table except for referential integrity constraints that reference other tables.

NEW QUESTION 7
You want to create a guaranteed restore point for your database by executing the command: SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Identify two prerequisites for the successful execution of this command. (Choose two.)

• A. The database must be running in ARCHIVELOG mode.
• B. Flashback Database must be enabled.
• C. Fast Recovery Area must be enabled.
• D. The recyclebin must be enabled for the database.
• E. Undo retention guarantee must be enabled.
• F. A database backup must be taken.

Answer: AC

NEW QUESTION 8
A telecom company wishes to generate monthly bills to include details of customer calls, listed in order of time of call.
Which table organization allows for generating the bills with minimum degree of row sorting?

• A. a hash cluster
• B. an index cluster
• C. a partitioned table
• D. a sorted hash cluster
• E. a heap table with a rowid column

Answer: D

NEW QUESTION 9
Your database has a table CUSTOMERS that contains the columns CUST_NAME, AMT_DUE, and OLD_STATUS.
Examine the commands executed and their output:

Why is it that only one update is listed by the Flashback Version Query?

• A. Supplemental logging is not enabled for the database.
• B. The undo data that existed for versions of rows before the change to the table structure is invalidated.
• C. The DB_FLASHBACK_RETENTION_TARGET parameter is set to a lower value and the undo data pertaining to the first transaction is flushed out.
• D. Undo retention guarantee is not enabled.
• E. Flashback Data Archive is full after the first update statement.

Answer: B

NEW QUESTION 10
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 11
Which three conditions must be met before you create a Virtual Private Catalog (VPC)? (Choose three.)

• A. A base recovery catalog should exist.
• B. The owner of VPC cannot own recovery catalog.
• C. At least one target database should be registered in the recovery catalog.
• D. The register database privilege should be granted to the virtual catalog owner.
• E. The recovery_catalog_owner role should be granted to the virtual catalog owner.

Answer: ADE

NEW QUESTION 12
You execute the commands to configure settings in RMAN:

Then, you issue the following command to take a backup:

Which statement is true about the execution of these commands?

• A. The backup terminates because the backup destination for disk is not specified in the BACKUP command.
• B. It backs up two copies each of the data files to disk and media, and two copies of archived logs to media.
• C. It backup up the data files and archived logs, making one copy of each data file and archived log on disk and media.
• D. It backs up the data files and archived logs to media, making two copies of each data file and archived logs.

Answer: D

NEW QUESTION 13
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 14
Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

• A. The ADR base is shared across multiple instances.
• B. The ADR base keeps all diagnostic information in binary format.
• C. The ADR can be used to store statspack snapshots to diagnose database performance issues.
• D. The ADR can be used for problem diagnosis even when the database instance is down.
• E. The ADR is used to store Automatic Workload Repository (AWR) snapshots.

Answer: AD

NEW QUESTION 15
Which two are prerequisites for performing Flashback Transaction? (Choose two.)

• A. A supplemental log must be enabled for the primary key.
• B. Undo retention guarantee must be configured for the database.
• C. Fast Recovery Area must be enabled for the database.
• D. The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.
• E. Row movement must be enabled.

Answer: AD

NEW QUESTION 16
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 both jobs by using Scheduler raised events.
• B. Create both jobs using application raised events.
• C. Create one job to rebuild indexes using application raised events and another job to perform bulk load using Scheduler raised events.
• D. Create one job to rebuild indexes using Scheduler raised events and another job to perform bulk load by using events raised by the application.

Answer: C

NEW QUESTION 17
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

NEW QUESTION 18
Which two statements are true regarding the Oracle Data Pump export and import operations? (Choose two.)

• A. You cannot export data from a remote database.
• B. You can rename tables during import.
• C. You can overwrite existing dump files during export.
• D. You can compress data but not metadata during export.

Answer: BC