Verified 1Z0-063 Exam Questions 2021

NEW QUESTION 1
As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single-instance database.
Which step should you perform next to start the upgrade of the database?

• A. Start up the database instance by using the new location of the server parameter file and run the catuppst.sqi script to generate informational messages and log files during the upgrade.
• B. Start up the database instance by using the new location of the server parameter file and run the cact1.pl script from the new Oracle home to use parallel upgrade options that reduce down time.
• C. Start up the database instance by using the STARTUP UPGRADE command and gather fixed object statistics to minimize the time needed for recompilation.
• D. Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade operations.

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 are true about tablespaces in multitenant container databases (CDBs)? (Choose two.)

• A. Default permanent tablespaces can be shared across pluggable databases (PDBs).
• B. The current container must be set to root to create or modify the default temporary tablespace or tablespace group for a CDB.
• C. Each PDB can have its own default temporary tablespace.
• D. The default permanent tablespace for a PDB can be changed only by a local user with the required permissions.
• E. The amount of space that each PDB can use in a shared temporary tablespace must be set at the CDB level.

Answer: BC

NEW QUESTION 4
You want to move your existing recovery catalog to another database. Examine the steps:
1) Export the catalog data by using the Data Pump Export utility in the source database.
2) Create a recovery catalog user and grant the necessary privileges in the target database.
3) Create a recovery catalog by using the CREATE CATALOG command.
4) Import the catalog data into the new recovery catalog by using the Data Pump Import utility in the target database.
5) Import the source recovery catalog schema by using the IMPORT CATALOG command.
6) Connect to the destination database.
7) Connect as CATALOG to the destination recovery catalog schema. Identify the option with the correct sequence for moving the recovery catalog.

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

Answer: C

NEW QUESTION 5
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 6
Which parameter must be set to which value to implement automatic PGA memory management?

• A. Set memory_target to zero.
• B. Set STATISTICS_LEVEL to BASIC.
• C. Set pga_aggregate_target to a nonzero value.
• D. Set pga_aggregate_target and sga_target to the same value.
• E. Set sgajtarget to zero.

Answer: C

NEW QUESTION 7
Which three methods can be used to create a pluggable database (PDB) in an existing multitenant container database (CDB)? (Choose three.)

• A. Use PDB$SEED for creating a PDB.
• B. Use the DBMS_PDB package to plug a non-CDB into an existing CDB.
• C. Clone the existing PDB.
• D. Use Enterprise Manager Database Express to create a PDB in an existing CDB.
• E. Use the DBMS_PDB package to plug a pre-Oracle 12c database into an existing CDB.

Answer: BCD

NEW QUESTION 8
Examine the resources consumed by a database instance whose current Resource Manager plan is displayed. SQL> SELECT name, active_sessions, queue_length,
consumed_cpu_time, cpu_waits, cpu_wait_time FROM v$rsrc_consumer_group;

Which two statements are true? (Choose two.)

• A. An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.
• B. An attempt to start a new session by a user belonging to OTHE_GROUPS fails with an error.
• C. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.
• D. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue contention.
• E. A user belonging to the DSS_QUERIES resource consumer group can create a new session but the session will be queued.

Answer: CE

NEW QUESTION 9
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. Control file autobackups
• D. Server parameter file (SPFILE)
• E. Recovery Manager (RMAN) backup pieces

Answer: BCE

NEW QUESTION 10
You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter resumable_timeout to 3600. Which two statements are true? (Choose two.)

• A. A resumable statement can be suspended and resumed only once during execution.
• B. Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.
• C. A suspended statement will report an error if no corrective action has taken place during a timeout period.
• D. Before a statement executes in resumable mode, the alter session enable resumable statement must be issued in its session.
• E. Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.

Answer: CD

NEW QUESTION 11
Examine the list of possible steps to transport a tablespace across platforms that have the same compatibility level, character sets, and endian format:
1. Make the tablespace read-only at the source database.
2. Export metadata from the source database.
3. Import metadata into the target database.
4. Transfer the dump file and data files to the target machine.
5. Convert data files by using Recovery Manager (RMAN).
6. Make the tablespace read-write at the target database. Identify the required steps in the correct order.

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

Answer: D

Explanation: Step 1 (1): To copy tablespaces from one database to another using transportable tablespace, the source tablespaces are first kept in READ-ONLY mode (to ensure data consistency). Once the tablespaces are in READ-ONLY mode, the actual datafiles belonging to the source tablespaces are copied from source database to target database (using any available methods like scp, sftp, rcp, etc).
Step 2 (2): Once the tablespace is kept in READ-ONLY mode, we need to generate the metadata export of the tablespaces that needs to transported using the DataPump export utility.
Step 3 (4): Once the metadata export is generated on the source database for all the tablespaces that needs to be transported, we need to copy the Export Dump file as well as all the datafiles belonging to the tablespaces to be transported to the target database server.
References:
http://www.oraclebuffer.com/oracle/migrate-oracle-database-using-transportable-tablespace/

NEW QUESTION 12
You are performing regular backups of your production database by using a recovery catalog.
You add two new tablespaces to your production database after performing a backup. They must be included in future backups.
Which action should you perform?

• A. Synchronize the recovery catalog with the target database control file.
• B. Create a new database incarnation record.
• C. Add the tablespaces in the recovery catalog by using the CATALOG command.
• D. Synchronize all the physical data files with the logical records in the recovery catalog by using theCROSSCHECK command.

Answer: A

NEW QUESTION 13
user_data is a non-encrypted tablespace containing tables with data. You must encrypt all data in this tablespace.
Which three methods can do this? (Choose three.)

• A. Use Data Pump.
• B. Use ALTERTABL
• C. . .MOVE
• D. Use CREATE TABLE AS SELECT
• E. Use alter tablespace to encrypt the tablespace after enabling row movement on all its disk space
• F. Use altertablespace to encrypt the tablespace.

Answer: ABC

NEW QUESTION 14
You have a production Oracle 12c database running on a host.
You want to install and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c database.
The steps in random order:
1. Create directory structures similar to the production database on all new machines.
2. Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.
3. Create a database clone template for the database.
4. Run the Database Configuration Assistant (DBCA) to create the database.
5. Run OUI in graphical mode on each machine.
6. Run OUI in silent mode using the OUI response file.
Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention.

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

Answer: D

NEW QUESTION 15
You want to capture column group usage and gather extended statistics for better cardinality estimates for the customers table in the SH schema. Examine the following steps:
1. Issue the SELECTDBMS_STATS. CREATE_EXTENDED_STATS (‘SH’, 'CUSTOMERS') from dual
statement.
2. Execute the dbms_stats.seed_col_usage (null, ‘SH’, 500) procedure.
3. Execute the required queries on the customers table.
4. Issue the select dbms_stats.reportwcol_usage (‘SH’, 'customers') from dual statement. Identify the correct sequence of steps.

• A. 3, 2, 1, 4
• B. 2, 3, 4, 1
• C. 4, 1, 3, 2
• D. 3, 2, 4, 1

Answer: B

Explanation: Step 1 (2). Seed column usage
Oracle must observe a representative workload, in order to determine the appropriate column groups. Using the new procedure DBMS_STATS.SEED_COL_USAGE, you tell Oracle how long it should observe the workload.
Step 2: (3) You don't need to execute all of the queries in your work during this window. You can simply run explain plan for some of your longer running queries to ensure column group information is recorded for these queries.
Step 3. (1) Create the column groups
At this point you can get Oracle to automatically create the column groups for each of the tables based on the usage information captured during the monitoring window. You simply have to call the DBMS_STATS.CREATE_EXTENDED_STATS function for each table.This function requires just two arguments, the schema name and the table name. From then on, statistics will be maintained for each column group whenever statistics are gathered on the table.
Note:
* DBMS_STATS.REPORT_COL_USAGE reports column usage information and records all the SQL operations the database has processed for a given object.
* The Oracle SQL optimizer has always been ignorant of the implied relationships between data columns
within the same table. While the optimizer has traditionally analyzed the distribution of values within a column, he does not collect value-based relationships between columns.
* Creating extended statistics
Here are the steps to create extended statistics for related table columns withdbms_stats.created_extended_stats:
1 - The first step is to create column histograms for the related columns.
2 – Next, we run dbms_stats.create_extended_stats to relate the columns together.
Unlike a traditional procedure that is invoked via an execute (“exec”) statement, Oracle extended statistics are created via a select statement.

NEW QUESTION 16
Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs). In the PDB HR_PDB, the common user C##ADMIN and the local user B_ADMIN have only the CONNECT privilege.
You create a common role C##ROLE1 with the CREATE ANY TABLE and SELECT ANY TABLE privileges.
You then execute the commands:

Which two statements are true? (Choose two.)

• A. C##ADMIN can create and select any table, and grant the C##ROLE1 role to users only in the root container.
• B. B_ADMIN can create and select any table in both the root container and HR_PDB.
• C. C##ADMIN can create and select any table in the root container and all the PDBs.
• D. B_ADMIN can create and select any table only in HR_PDB.
• E. The GRANT c##role1 TO b_admin command returns an error because CONTAINER should be set to ALL.

Answer: CD