02 February, 2022

The Renew Guide To 1Z0-063 Actual Test

Realistic of 1Z0-063 exam price materials and training tools for Oracle certification for customers, Real Success Guaranteed with Updated 1Z0-063 pdf dumps vce Materials. 100% PASS Oracle Database 12c: Advanced Administration exam Today!

Online Oracle 1Z0-063 free dumps demo Below:

Page: 1 / 19

Total 235 questions Full Exam Access

Question 1

- (Exam Topic 1)
Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined.
You execute this command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;
Which statement is true?

The minimum size for the standard buffer cache is 100 MB.

The maximum size for the standard buffer cache is 100 MB.

The minimum space guaranteed in the buffer cache for any server process is 100 MB.

The maximum space in the buffer cache that can be released for dynamic distribution is 100 MB.

The minimum size for all buffer caches is 100 MB.

Question 2

- (Exam Topic 2)
In your database, there are tablespaces that were read-only when the last backup was taken. These tablespaces have not been made read/write since then. You want to perform an incomplete recovery on the database by using a backup control file.
What precaution must you take for the read-only tablespaces before performing an incomplete recovery?

All the read-only tablespaces should be taken offline.

All the read-only tablespaces should be restored separately.

All the read-only tablespaces should be renamed to have the MISSINGnnnn format.

All the read-only tablespaces should be made online with logging disabled.

Question 3

- (Exam Topic 1)
Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)? (Choose three.)

A PDB opened in restricted mode allows only local users to connect.

When a CDB is open in restricted mode, PDBs must also be opened in restricted mode.

When a CDB is in MOUNT state, PDBs are automatically placed in MOUNT state.

All PDBs must be shut down before shutting down a CDB instance.

When a CDB instance is started, PDBs can be placed in OPEN state by using database triggers or by executing the ALTER PLUGGABLE DATABASE command.

Question 4

- (Exam Topic 2)
Which two statements are true about encrypted backups performed by using RMAN? (Choose two.)

Transparent encryption of backups uses an encryption wallet.

A database uses the same encryption key for every encrypted backup.

A password encryption of backups uses the password while creating and restoring backups.

Image copy backups can be created by using password encryption.

Encrypted backups can only be written to disk.

Question 5

- (Exam Topic 2)
You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The default format of which two data types would be affected by this setting? (Choose two.)

DATE

TIMESTAMP

INTERVAL YEAR TO MONTH

INTERVAL DAY TO SECOND

TIMESTAMP WITH LOCAL TIME ZONE

Question 6

- (Exam Topic 2)
Your database is running in archivelog mode. You are taking a backup of your database by using RMAN with a recovery catalog. Because of a media failure, one of the data files and all the control files are lost.
Examine the steps to recover the database:
1. Restore the control files by using the RMAN restore controlfile command.
2. Mount the database.
3. Restore the data files by using the RMAN restore database command.
4. Open the database with the resetlogs option.
5. Recover the data files by using the RMAN recover using backup controlfile command.
6. Start the database instance in nomount state.
7. Connect to the target database by using a recovery catalog.
8. Open the database.
9. Restore the data file.
10. Recover the data file.
Identify the required steps in the correct order.

7, 6, 1, 2, 3, 5, 4

7, 2, 1, 3, 5, 8

7, 6, 1, 2, 9, 10, 8

7, 6, 1, 2, 9, 10, 4

Question 7

- (Exam Topic 1)
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:
1Z0-063 dumps exhibit

Which two statements are true? (Choose two.)

C##ADMIN can create and select any table, and grant the C##ROLE1 role to users only in the root container.

B_ADMIN can create and select any table in both the root container and HR_PDB.

C##ADMIN can create and select any table in the root container and all the PDBs.

B_ADMIN can create and select any table only in HR_PDB.

The GRANT c##role1 TO b_admin command returns an error because CONTAINER should be set to ALL.

Question 8

- (Exam Topic 1) Evaluate these statements: CREATE TABLE purchase_orders (po_idNUMBER(4),
po_dateTIMESTAMP, supplier_idNUM8ER(6),
po_totalNUMBER(8,2), CONSTRAINT order_pk PRIMARY KEY(po_id)) PARTITION BY RANGE(po_date)
(PARTITIONQ1 VALUES LESS THAN (TO_DATE('01-apr-2007','dd-mm-yyyy')), PARTITIONQ2VALUESLESSTHAN(TO_DATE('01-jul-2007','dd-mm-yyyy')), PARTITIONQ3VALUESLESSTHAN (TO~DATE('01-oct-2007','dd-mm-yyyy')), PARTITIONQ4VALUESLESSTHAN (TO_DATE('Ol-jan-2008','dd-mm-yyyy')));
CREATE TABLE purchase_order_items (po_idNUM3ER(4)NOT NULL,
product_idNUMBER(6)NOT NULL, unit_price NUMBER(8,2),
quantity NUMBER(8), CONSTRAINT po_items_f k
FOREIGN KEY(po_id)REFERENCES purchase_orders(po_id)) PARTITION BY REFERENCE(po_items_fk);
Which two statements are true? (Choose two.)

Partitions of purchase_order_items are assigned unique names based on a sequence.

The purchase_orders and purchase_order_items tables are created with four partition each.

purchase_order_items table partitions exist in the same tablespaces as the purchase_orders table partitions.

The purckase_order_:teks table inherits the partitioning key by duplicating the key columns from the parent table.

Partition maintenance operations on the purchase_order_items table require disabling the foreign key constraint.

Question 9

- (Exam Topic 2)
RMAN is configured to create backupset backups for your database. You issue the command to back up the database:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which two statements are true about the backup performed by the command? (Choose two.)

Only the used blocks in the data files are backed up.

It backs up all the data files and deletes obsolete backups after the backup is complete.

It backs up only those archived log files that are not backed up at least once.

It backs up all the archived log files and deletes the ones that were just backed up.

It backs up all archived redo log files and online log files and deletes the archived log files after the backup is complete.

Question 10

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

connecting to the target database and a recovery catalog to execute the DUPLICATE command

creating a password file for an auxiliary instance

connecting to an auxiliary instance

matching the database identifier (DBID) of the source database and the duplicate database

creating an SPFILE for the target database

Question 11

- (Exam Topic 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?

Execute catproc.sql to recompile invalid PL/SQL modules.

Open the database with the RESETLOGS option.

Set a new database identifier (DBID) for the newly restored database.

Use the RMAN SET NEWNAME and SWITCH commands to switch to new files.

Question 12

- (Exam Topic 2)
You plan to duplicate the multitenant container database (CDB) cdb1 that contains the pluggable database (PDB) SALES:
1Z0-063 dumps exhibit

Which two statements are true? (Choose two.)

The root and seed databases are included in the duplication.

Only the SALES PDB is duplicated as the non-CDBCDBDUP.

A backup of the SALES PDB must exist before the execution of the command.

An auxiliary instance must have been started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.

RMAN must be connected to a recovery catalog for the execution of the command.

Question 13

- (Exam Topic 1)
You are connected to a pluggable database (PDB) as a common user with the SYSDBA privilege. The PDB is open and you issue the SHUTDOWN IMMEDIATE command.
What is the outcome?

The PDB is closed.

The PDB is placed in mount state.

The command executes only if the common user is granted the SET CONTAINER privilege for the PDB.

The command results in an error because the PDB can be shut down only by a local user.

Question 14

- (Exam Topic 1)
For your database, an incremental level 1 backup is taken every week day. On Tuesday, before the backup is performed, you add a new tablespace.
You execute the command:
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY DATABASE;
Which statement is true about the execution of the command?

It returns an error because there is no level 0 backup available for new data files.

It performs an image copy backup of new data files, and a level 1 incremental backup of all other data files.

It performs a level-0 backup of all data files including those that belong to the new tablespace.

It performs an image copy backup of all data files including those that belong to the new tablespace.

It performs a backup as a backup set of all data files including those that belong to the new tablespace.

Question 15

- (Exam Topic 2)
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.

1, 6, 4

2, 3, 7, 5

1, 2, 6, 4

1, 2, 3, 6, 5

Question 16

- (Exam Topic 2)
Which two statements are true about unified auditing? (Choose two.)

A unified audit trail captures audit information from unified audit policies and audit settings.

Unified auditing is enabled by executing make –f ins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME.

Audit records are created for all users except sys.

Audit records are created only for the DML and DDL operations performed on database objects.

Unified auditing is enabled by setting the audit_trail parameter to db, extended.

A unified audit trail resides in a read-only table in the audsys schema in the system tablespace.

Question 17

- (Exam Topic 1)
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?

TYPE

LOCATION

PARALLEL

DEFAULT DIRECTORY

ORGANIZATION EXTERNAL

Question 18

- (Exam Topic 2)
Which two statements are true about Flashback Version Query? (Choose two.)

The result of a query can be used as part of a DML statement.

It can be used to create views.

It can be used only if Flashback Data Archive is enabled for a table.

It retrieves all versions of rows that exist in a time interval, including the start time and end time.

It can be used to retrieve the SQL that is required to undo a row change and the user responsible for the change.

Question 19

- (Exam Topic 2)
Which three statements are true about Flashback Data Archive? (Choose three.)

Flashback Data Archive prevents flashback queries from getting a snapshot-too-old error.

A table enabled for Flashback Data Archive cannot be dropped unless Flashback Data Archive is disabled or disassociated first.

To enable Flashback Data Archive for a table, it is mandatory to have a default Flashback Data Archive for a database.

While enabling Flashback Data Archive for a table, if no name is provided for Flashback Data Archive, it is enabled using the default Flashback Data Archive.

To use Flashback Data Archive, users must have unlimited quota on the Flashback Data Archive tablespace.

Question 20

- (Exam Topic 1)
Which two statements are true when row-archival management is enabled? (Choose two.)

Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter.

The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active.

The row archival visibility session parameter defaults to all rows.

The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.

The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active.

Question 21

- (Exam Topic 1)
Your database supports a Decision Support System (DSS) workload that involves the execution of complex
queries. Currently, the database is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache.
What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?

SQL Performance Analyzer

SQL Access Advisor

SQL Tuning Advisor

Automatic Workload Repository (AWR) report

Automatic Database Diagnostic Monitor (ADDM)

Question 22

- (Exam Topic 1)
Which three RMAN persistent settings can be set for a database? (Choose three.)

backup retention policy

default backup device type

default section size for backups

default destinations for backups

multiple backup device types for a single backup

Question 23

- (Exam Topic 2)
Which two are prerequisites for performing Flashback Transaction? (Choose two.)

A supplemental log must be enabled for the primary key.

Undo retention guarantee must be configured for the database.

Fast Recovery Area must be enabled for the database.

The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.

Row movement must be enabled.

Page: 1 / 19

Total 235 questions Full Exam Access