Oracle 1Z0-063 Dumps Questions 2021

NEW QUESTION 1
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 2
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 3
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 4
You are administering a multitenant container database (CDB) CDB1 that has multiple pluggable databases (PDBs). As the SYS user on CDB$ROOT, you execute the commands:
SQL> CREATE USER C##ADMIN IDENTIFIED BY orc1123;
SQL> GRANT CREATE SESSION to C##ADMIN CONTAINER=ALL; SQL> GRANT CREATE USER TO C##ADMIN CONTAINER=ALL;
Which two statements are true about the c##ADMIN user that is created in all PDBs? (Choose two.)

• A. It can create only local users in all the PDBs.
• B. It has a common schema for all the PDBs.
• C. It can create common users only when it is logged in to the CDB.
• D. It can create only local users in the CDB.
• E. It can be granted only common roles in the PDBs.

Answer: AC

NEW QUESTION 5
Your database is running on the host OUSERVER. You back up your database regularly using RMAN and the backups are cataloged in a recovery catalog. For testing purposes, you want to replicate your database to another host, OUSERVER1, with the same directory structure. So, you copy the backups to the new host.
What must you do to make the database operational in OUSERVER1?

• A. Restore the control file from the backup by using the CATALOG option, restore the data files by using the SET NEWNAME command, and recover the data files.
• B. Restore the data files by using the NOCATALOG option and use the SET NEWNAME command to change the location.
• C. Restore the control file from the backup by using the NOCATALOG option, and then restore and recover the data files.
• D. Restore the data files from the backup by using the recovery catalog, use the SWITCH command to change the location, and recover the data files.

Answer: A

Explanation: Catalog any backups not recorded in the repository with the CATALOG command.
Restore the data files to their original locations. If volume names have changed, then run SET NEWNAME commands before the restore operation and perform a switch after the restore operation to update the control file with the new locations for the data files, as shown in the following example.
Note: One way to name duplicate data files is to use the SET NEWNAME command before executing the DUPLICATE command. RMAN supports the following commands, listed in order of precedence:
References: https://docs.oracle.com/database/121/BRADV/rcmadvre.htm

NEW QUESTION 6
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 7
Examine the initialization parameter that is set in the PFILE:
DB_CREATE_FILE_DEST ='/u01/app/oracle/oradata/'
You execute the following command to create CDB1 container database (CDB): SQL>CREATE DATABASE CDB1
DEFAULT TABLESPACE users DEFAULT TEMPORARY TABLESPACE
temp
UNDO TABLESPACE
Undotbsl ENABLE
PLUGGABLE DATABASE SEED
SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED SYSAUX DATAFILES SIZE 100M;
Which three statements are true? (Choose three.)

• A. It creates a multitenant container database with a root and a seed pluggable database (PDB) that are opened in read-write and read-only modes, respectively.
• B. The files created for both the root and seed databases use Oracle Managed Files (OMF).
• C. It creates a multitenant container database with the root and seed databases opened and one PDB mounted.
• D. It sets the users tablespace as the default for both the root and seed databases.
• E. undotbs1 is used as the undo tablespace for both the root and seed databases.
• F. It creates a multitenant container database with the root database opened and the seed database mounted.

Answer: ABE

NEW QUESTION 8
In the SPFILE, UNDO TABLESPACE is 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

NEW QUESTION 9
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 10
You execute the RMAN commands:
RMAN> BACKUP VALIDATE DATABASE; RMAN> RECOVER CORRUPTION LIST;
Which task is performed by these commands?

• A. Corrupted blocks, if any, are repaired in the backup created.
• B. Only those data files that have corrupted blocks are backed up.
• C. Corrupted blocks in the data files are checked and repaired before performing the database backup.
• D. The database is checked for physically corrupt blocks and any corrupted blocks are repaired.

Answer: D

NEW QUESTION 11
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 owner of the 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 DBA role must be granted to the virtual catalog owner.

Answer: ABE

NEW QUESTION 12
Examine the command:

Which statement is true about the execution of the command?

• A. It fails because the log file parameter is not specified.
• 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 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 13
Examine the RMAN commands executed in your database: RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET; RKAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
You issue the command:
RMAN> BACKUP DATABASE;
Which two statements are true about the command? (Choose two.)

• A. It performs a log switch.
• B. It creates compressed backup sets by using binary compression by default.
• C. It backs up only the used blocks in data files.
• D. It backs up data files, the control file, and the server parameter file.
• E. It creates a backup of only the control file whenever the database undergoes a structural change.

Answer: CD

NEW QUESTION 14
Which two statements are true about scheduling operations in a pluggable database (PDB)? (Choose two.)

• A. Scheduler jobs for a PDB can be defined only at the container database (CDB) level.
• B. A job defined in a PDB runs only if that PDB is open.
• C. Scheduler attribute setting is performed only at the CDB level.
• D. Scheduler objects created by users can be exported or imported using Data Pump.
• E. Scheduler jobs for a PDB can be created only by common users.

Answer: BD

NEW QUESTION 15
Which three statements are true about Oracle Restart? (Choose three.)

• A. It can be configured to automatically attempt to restart various components after a hardware or software failure.
• B. While starting any components, it automatically attempts to start all dependencies first and in proper order.
• C. It can be configured to automatically restart a database in case of normal shutdown of the database instance.
• D. It can be used to only start Oracle components.
• E. It runs periodic check operations to monitor the health of Oracle components.

Answer: ABE

NEW QUESTION 16
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 17
Examine these Data Pump commands to export and import objects from and to the same database. The dba has not yet created users hr1 and oe1.
$expdp system/manager schemas = hr.oe directory = EXP_DIR dumpfile = export.dat include = table
$ impdpsysten/manager schemas = hr1,oe1 directory = EXP_DIR dumpfile = export.dat
remap_schena=hr:hrl, oe:oe1
What will happen when running these commands?

• A. expdp will fail because no path has been defined for the dumpfile.
• B. expdp will succeed but impdp will fail because the users do not exist.
• C. inpdp will create two users called hr1 and oe1 and import all objects to the new schemas.
• D. impdp will create two users called hr1 and oe1 and import only the tables owned by hr and oe schemas to ht1 and oe1 schemas, respectively.

Answer: B

NEW QUESTION 18
In which three scenarios is media recovery required? (Choose three.)

• 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: ACE

NEW QUESTION 19
You are administering a multitenant container database (CDB) that has no startup triggers and contains three pluggable databases (PDBs).
You execute the command to start up the CDB. SQL> STARTUP
Which statement is true?

• A. CDB$ROOT, PDB$SEED, and the PDBs are opened in read-only mode.
• B. CDB$ROOT and PDB$SEED are opened in read-only mode, but the PDBs are in closed mode.
• C. CDB$ROOT is opened in read/write mode, but PDB$SEED and the PDBs are in closed mode.
• D. CDB$ROOT is opened in read/write mode, PDB$SEED in read-only mode, and the PDBs in MOUNT state.
• E. CDB$ROOT, PDB$SEED, and the PDBs are opened in read/write mode.

Answer: D

Explanation: If neither READ WRITE nor READ ONLY is specified, a PDB will be opened in READ ONLY if a CDB to which it belongs is used as a physical standby database, otherwise the PDB will be opened READ WRITE.
Prerequisites for a PDB STARTUP
When the current container is a pluggable database (PDB), the STARTUP command can only be used if:
* The PDB is in MOUNTED mode, excluding the use of the FORCE option.
* The PDB must be in READ ONLY or READ WRITE mode to be in mounted mode. Etc.
References: https://docs.oracle.com/database/121/SQPUG/ch_twelve045.htm

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

Answer: A