Top Tips Of Up To The Minute 1Z0-063 Test

NEW QUESTION 1

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 2

LDAP_DIRECTORY_SYSAUTH is set to YES.
Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory (OID). SSL has been configured for the database and OID and the password file has been configured for the database. User scott with sysdba privilege tries to connect remotely using this command:
$sqlplusscott/tiger@DB0l As sysdba where DB01 is the net service name. Which authentication method will be attempted first?

• A. authentication by password file
• B. authentication by using certificates over SSL
• C. authentication by using the Oracle Internet Directory
• D. authentication by using the local OS of the database server

Answer: A

NEW QUESTION 3

In CDB$ROOT of your multitenant container database (CDB), you create a common user, C##A_ADMIN, and then execute the command:

Which statement is true?

• A. The command executes successfully, enabling the C##A_ADMIN user to create a tablespace only in the root database.
• B. The command executes successfully, enabling the C##A_ADMIN user to create tablespaces in the root database, as well as in the pluggable databases (PDBs).
• C. The command fails because the CONTAINER clause is not used.
• D. The command fails because system privileges cannot be granted to a common user.

Answer: A

NEW QUESTION 4

Examine the command to duplicate a database: RMAN> DUPLICATE TARGET DATABASE TO cdb PLUGGABLE DATABASE pdb1, pdb5;
Which two statements are true about the DUPLICATE command? (Choose two.)

• A. The SPFILE is copied along with the data files of the pluggable databases (PDBs).
• B. A backup of pdb1 and pdb5 must exist before executing the command.
• C. The DUPLICATE command first creates a backup, and then duplicates the PDBs by using the backup.
• D. The root and the seed database in the container database (CDB) are also duplicated.
• E. An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.

Answer: BD

NEW QUESTION 5

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 6

In which situation can you use Flashback Database?

• A. when undoing a shrink data file operation
• B. when retrieving a dropped tablespace
• C. when returning to a point in time before the restoration or re-creation of a control file
• D. when returning to a point in time before the most recent OPEN RESETLOGS operation

Answer: B

NEW QUESTION 7

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 8

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 9

Which Oracle Database component is audited by default if the Unified Auditing option is enabled?

• A. Oracle Data Pump
• B. Oracle Recovery Manager (RMAN)
• C. Oracle Label Security
• D. Oracle Database Vault
• E. Oracle Real Application Security

Answer: B

NEW QUESTION 10

You want to create a database with a block size other than the default 8 KB by using the Database Configuration Assistant (DBCA).
Which option should you use?

• A. A custom database template
• B. AData Warehouse database template
• C. Automatic Storage Management (ASM) for storage of data files
• D. A file system for storage of data files

Answer: A

NEW QUESTION 11

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 12

Examine the steps to configure Oracle Secure Backup (OSB) for use with RMAN:
1. Create media families for data files and archived redo log files.
2. Configure database backup storage selectors or RMAN media management parameters.
3. Create an OSB user preauthorized for RMAN operations.
4. Configure RMAN Access to the OSB SBT.
5. Disable Non-Uniform Memory Access (NUMA) awareness by setting the ob_ignore_numa parameter to 0. Identify the steps in the correct order.

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

Answer: C

NEW QUESTION 13

RMAN is connected to the target database PROD1 and an auxiliary instance in NOMOUNT state. Examine the command to create a duplicate database:

Which two statements are true about the execution of the DUPLICATE command? (Choose two.)

• A. All archive redo log files are automatically copied to the duplicate database.
• B. The duplicate database has the same directory structure as the source database.
• C. The duplicate database is created by using the backups created during the execution of the DUPLICATE command.
• D. The password file and SPFILE for the duplicate database DUP1 are created in their respective default locations.
• E. The duplicate database is created without using RMAN backups and PROD: is allowed to remain open during duplication.

Answer: BE

NEW QUESTION 14

Examine the statements that use flashback technologies:
1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP (‘2013-02-04 09:30:00’, ‘YYYY-MM-DD HH:MI:SS’);
2. SELECT * FROM customers AS OF SCN 123456;
3. FLASHBACK TABLE customers TO BEFORE DROP;
4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP (‘2013-02-04 09:30:00’, ‘YYYY-MM-DD HH:MI:SS’);
5. SELECT * FROM customers VERSIONS BETWEEM SCN 123456 AND 123999;
6. ALTER TABLE customer FLASHBACK ARCHIVE;
Which set of statements depends on the availability of relevant undo data in the undo tablespace?

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

Answer: A

NEW QUESTION 15

Which three statements are true about the SQL*Loader utility? (Choose three.)

• A. It can be used to load data from multiple external files into multiple tables.
• B. It can be used to extract and reorganize data from external files, and then load it into a table.
• C. It can be used to load data from external files using direct path only.
• D. It can be used to create tables using data that is stored in external files.
• E. It can be used to generate unique sequential values in specified columns while loading data.

Answer: ABE

NEW QUESTION 16

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 17

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 18

Which two are prerequisites for creating a backup-based duplicate database? (Choose two.)

• A. connecting to the target database and a recovery catalog to execute the DUPLICATE command
• B. creating a password file for an auxiliary instance
• C. connecting to an auxiliary instance
• D. matching the database identifier (DBID) of the source database and the duplicate database
• E. creating an SPFILE for the target database

Answer: AB

NEW QUESTION 19

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 20

You must unload data from the orders, order_items, and products database tables to four files using the External Tables.
CREATE TABLE orders_ext
(order_id, order_date, product_id, product_name,quantity) ORGANIZATION EXTERNAL
(
TYPE ORACLE_DATAPUMP DEFAULT DIRECTORY ext.dir
LOCATION (‘ordersl.dmp','orders2.dmp’,’orders3.dmp’,’lorders4.dmp')
) PARALLEL AS
SELECT o.order_id,o.order_date,p.product_id,p.product_name,i.quantity FROM orders o,productsp,order_items
WHERE o.orderid = i.order_id and i.product_id = p.product_id;
You execute the command shown in the Exhibit, but only two files are created. Which parameter must be changed so that four files are created?

• A. TYPE
• B. LOCATION
• C. PARALLEL
• D. DEFAULT DIRECTORY
• E. ORGANIZATION EXTERNAL

Answer: C

NEW QUESTION 21

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. Use the DBMS_PDB package to plug the Oracle 11g database into the existing CDB as a PDB.
• B. Use the CREATE DATABASE ... ENABLE PLUGGABLE DATABASE statement to create a PDB by copying data files from PDB$SEED and use data pump to load data from the Oracle 11g database into the newly created PDB.
• C. 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.
• D. Pre-create a PDB in CDB and use the NETWORK_LINK and PARALLEL parameters with data pump import to import data from the Oracle 11g database to the newly created PDB.
• E. Upgrade the Oracle 11g database to a 12c non-CDB and use the DBMS_PDB.DESCRIBE procedure to plug the database as a new PDB into the CDB.

Answer: DE

NEW QUESTION 22

Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)? (Choose two.)

• A. If no PDB plan is enabled for a pluggable database, all sessions for that PDB are treated to an equal share of resources.
• B. To enable a resource plan for a PDB, a CDB resource plan must be created and enabled.
• C. If a PDB plan is enabled for a pluggable database, Resource Manager uses the resource allocation at the PDB level and ignores the limits set at the CDB level.
• D. If no PDB plan is enabled for a pluggable database, the PDB uses the CDB plan.
• E. If a PDB plan is enabled for a pluggable database, resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

Answer: AE

Explanation:
A: ACDB resource plan determines the amount of resources allocated to each PDB. A PDB resource plan determines how the resources allocated to a specific PDB are allocated to consumer groups within that PDB.
Resource Manager allocates the resources in two steps:
E: A PDB resource plan allocates resource among the consumer groups within a PDB. References: https://docs.oracle.com/database/121/ADMIN/cdb_dbrm.htm

NEW QUESTION 23

You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:

Which statement is true about the execution of the last command?

• A. It succeeds and displays all the tablespaces that belong to the root database.
• B. It fails and returns an error because a connection is not made by using the SYSDBA privilege.
• C. It succeeds and displays all the tablespaces that belong to the root and pluggable databases.
• D. It fails and returns an error because SQL commands cannot be executed at the RMAN prompt.

Answer: C

NEW QUESTION 24

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. A most recent backup set of the PROD database must exist.
• D. Flashback must be enabled for the PROD database.

Answer: B

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 25
......