Unlock your Full 1z0-063 Oracle Stable Exam

Oracle Database 12c: Advanced Administration Questions and Answers

Question 1

Which three statements are true about common roles? (Choose three.)

Options:

A common role can be granted only to a common user.

Only system privileges can be granted to a common role in a container database (CDB).

Object privileges can be granted to a common role in a pluggable database (PDB).

A common user that is granted a common role can grant the role to other common and local users in a PDB.

A common role cannot be created by a local user.

Question 2

One of your database runs in ARCHIVELOG mode.

Examine these initialization parameter settings:

Question # 2

Which statement is true based on these settings?

Options:

An online redo log will not be overwritten only if an archived log cannot be created in at least two of the non-mandatory destinations and LOG_ARCHIVE_DEST_4.

An online redo log will not be overwritten only if an archived log cannot be created in at least two of the non-mandatory destinations.

An online redo log will not be overwritten only if an archived log cannot be created in at least one of the non-mandatory destinations and LOG_ARCHIVE_DEST_4.

An online redo log will not be overwritten only if an archived log cannot be created in LOG_ARCHIVE_DEST_4.

Question 3

In an Oracle 12c database, you attempt to load data into the HR.EMPLOYEES table in a pluggable database (PDB):

$> sqlldr hr/hr@pdb table=employees

Which three are true? (Choose three.)

Options:

It creates the HR.EMPLOYEES table in the PDB and loads data into it if the table does not exist in the PDB to which HR connects.

It succeeds if HR is a local user in the PDB to which HR connects.

It loads data into HR.EMPLOYEES if the table exists in the PDB to which HR connects.

It succeeds if HR is a common user.

It loads data into HR.EMPLOYEES if the table exists in CDB$ROOT.

Question 4

Your database is running in ARCHIVELOG mode. You use RMAN to take image copies and you update these copies incrementally every six hours. After a regular maintenance task, when you attempt to restart the instance, it halts in MOUNT state with an error indicating that one of the data files belonging to the EXAMPLE tablespace is lost.

You want to recover the data file as quickly as possible while maximizing availability for the database.

Examine the possible steps involved in the recovery process:

1. Mount the database.

2. Take the data file offline.

3. Bring the tablespace online.

4. Use the RMAN SWITCH command to switch to the image copy.

5. Recover the tablespace.

6. Open the database.

7. Use the RMAN RESTORE command to switch to the image copy.

Identify the correct sequence of the required steps.

Options:

2, 6, 4, 5, 3

2, 4, 5, 3, 6

1, 2, 4, 6, 3

1, 2, 7, 5, 3, 6

2, 7, 5, 3

Question 5

Which three types of failures are detected by the Data Recovery Advisor (DRA)? (Choose three.)

Options:

loss of a non-critical data file

loss of a control file

physical data block corruption

logical data block corruption

loss of an archived redo log

Question 6

Your database is running in ARCHIVELOG mode and a nightly backup of the database, along with an autobackup of the control file, is taken by using RMAN. Because of a media failure, the SPFILE and the control files are lost.

Examine the steps to restore the SPFILE and the control file to mount the database:

1. Set DBID of the target database in RMAN.

2. Start the database instance by using the STARTUP FORCE NOMOUNT command in RMAN.

3. Restore the control files from the backup.

4. Mount the database.

5. Restore the SPFILE from the autobackup.

6. Create a PFILE from the recovered SPFILE.

7. Restart the instance in NOMOUNT state.

Identify the required steps in the correct order.

Options:

1, 2, 5, 3, 6, 4

1, 2, 3, 5, 6, 4

2, 1, 5, 7, 3, 4

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

Question 7

You create a new database by using the CREATE DATABASE command in SQL*Plus, with the ENABLE PLUGGABLE DATABASE clause specified.

Which statement is true about the database that is created?

Options:

It is created as a container database (CDB) with CDB$ROOT, PDB$SEED, and a pluggable database (PDB).

It is created as a non-CDB that becomes a CDB after the first PDB is plugged in.

It is created as a PDB that must be plugged into an existing CDB.

It is created as a CDB with the CDB$ROOT and PDB$SEED databases.

Question 8

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

Options:

It can be configured to automatically attempt to restart various components after a hardware or software failure.

While starting any components, it automatically attempts to start all dependencies first and in proper order.

It can be configured to automatically restart a database in case of normal shutdown of the database instance.

It can be used to only start Oracle components.

It runs periodic check operations to monitor the health of Oracle components.

Question 9

Which three conditions must be met before you Virtual Private Catalog (VPC) can be created and used by an Administrator? (Choose three.)

Options:

A base recovery catalog must exist.

The owner of the VPC cannot own recovery catalog.

At least one target database should be registered in the recovery catalog.

The REGISTER DATABASE privilege should be granted to the virtual catalog owner.

The DBA role must be granted to the virtual catalog owner.

Question 10

You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).

Examine the steps required to perform the migration:

1. Use Data Pump export to perform a full transportable export on the source database with the export parameter VERSION=12.

2. Place all tablespaces in read-only mode on the source database.

3. Upgrade the source database to Oracle Database 12c.

4. Copy the dump file and data files to the desired location in the target database.

5. Create a new PDB in the target CDB.

6. Synchronize the PDB on the target CDB.

7. Use Data Pump import on the new PDB by using the full transportable import options.

Identify the required steps in the correct order.

Options:

1, 5, 4, 7, and 6

3, 2, 5, 1, 4, and 7

2, 5, 1, 4, 7, and 6

2, 1, 3, 5, 7, and 6

Question 11

You take your database backups by using the RMAN media management interface (MMI).

Which two are true about the use of the RMAN MMI? (Choose two.)

Options:

You can use it to create image copies for entire file systems.

You can use it to create image copies for database files.

You can use it to create backup sets for database files.

You can use it to create proxy copies for database files.

You can use it to create proxy copies for entire file systems.

Question 12

You are administering a multitenant container database (CDB).

Identify two ways to access a pluggable database (PDB) that is open in read-only mode. (Choose two.)

Options:

by using the CONNECT statement as a local user having only the SET CONTAINER privilege

by using easy connect

by using external authentication

as a common user with the SET CONTAINER privilege

by executing the ALTER SESSION SET CONTAINER command as a local user

Question 13

Examine the probable steps involved in the basic backup process of RMAN and Oracle Secure Backup (OSB):

1. RMAN initiates backup and passes the database backup storage selector to OSB.

2. RMAN creates the backup job.

3. OSB creates the backup job with an OSB user.

4. RMAN updates its repository.

5. RMAN executes the job and transfers data from a client to media.

6. OSB executes the job and transfers data from a client to media.

7. OSB updates its repository.

Identify the required steps in the correct order.

Options:

1, 3, 6, 7, 4

2, 1, 6, 4, 7

1, 3, 5, 7, 4

1, 3, 6, 4, 7

Question 14

Which two are true about incremental backups? (Choose two.)

Options:

A backup set can be used as the baseline for an incremental backup.

Differential backups can be taken at level 0.

An image copy can be used as the baseline for an incremental backup.

A tablespace incremental level 1 backup always backs up all blocks in the backed up tablespace.

Incremental backups are not permitted when using block change tracking.

A database incremental level 0 backup always backs up all database blocks.

Question 15

While performing database backup to tape via the media manager interface, you notice that tape streaming is not happening because RMAN is not sending data blocks fast enough to the tape drive.

Which two actions would you take for tape streaming to happen during the backup? (Choose two.)

Options:

Configure backup optimization.

Configure the channel to increase maxopenfiles.

Configure a backup policy by using incremental backups.

Configure the channel to increase capacity with the rate parameter.

Configure the channel to adjust the tape buffer size by using the 3LKSIZE option.

Configure large_pool, if not done already. Alternatively, you can increase the size of large_pool.

Question 16

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

Options:

Flashback data archives (FDA)

Archived redo log files

Control file autobackups

Server parameter file (SPFILE)

Recovery Manager (RMAN) backup pieces

Question 17

Which three are true about RMAN duplexed backup sets or image copies? (Choose three.)

Options:

A backup set may be duplexed with both copies written to disk.

An image copy on sbt can be copied to disk.

A backup set may be duplexed with both copies written to sbt.

An image copy on disk can be copied to sbt.

An image copy on disk can be copied to disk.

A backup set may be duplexed so that one copy is written to sbt and the other to disk.

Question 18

You are connected to a recovery catalog and target database. You execute the command:

RMAN> CATALOG START WITH ‘/disk1/backups’;

Which statement is true?

Options:

Only valid data file copies, existing in the /disk1/backups directory, are cataloged.

Only valid backup pieces and archived logs, existing in the /disk1/backups directory, are cataloged.

It lists all the data file copies, backup pieces, and achieved logs cataloged in the recovery catalog in the /disk1/backups directory and its subdirectories.

It lists and catalogs all valid data file copies, backup pieces, and archived logs that exist in all directory paths with the prefix /disk1/backups and their subdirectories.

Question 19

Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled? (Choose two.)

Options:

Reduced logical I/O

Reduced virtual memory utilization

Improved Serial Execution performance

Reduced physical I/O

Reduced CPU utilization

Question 20

Which three statements are true about automated maintenance tasks? (Choose three.)

Options:

Predefined maintenance tasks consist of automatic optimizer statistics collection, running Automatic Segment Advisor, and running Automatic SQL Tuning Advisor.

A repository is maintained in the SYSTEM tablespace to store the history of execution of all tasks.

They run at predefined time intervals that are intended to occur during a period of low system loads.

An Oracle Scheduler job is created for each maintenance tasks that is scheduled to run in a maintenance window.

A maintenance window is automatically extended until all the maintenance tasks defined are completed.

Question 21

Which two statements are true about Flashback Version Query? (Choose two.)

Options:

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 22

In which two locations does the USER_DATA TABLESPACE clause create a tablespace? (Choose two.)

Options:

a PDB

CDB$ROOT

PDB$SEED

a non-CDB

an Application Root

Question 23

You issue the command:

SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

Which statement is true about the command?

Options:

It creates a copy of the control file and stores it in the location specified in the diagnostic_dest initialization parameter.

It creates a file that contains the SQL statement, which is required to re-create the control file.

It updates the alert log file with the location and contents of the control file.

It creates a binary backup of the control file.

Question 24

Which three statements are true about unplugging a pluggable database (PDB)? (Choose three.)

Options:

A PDB must be in closed state before it can be unplugged.

A PDB must have been opened at least once after creation.

A PDB must be in MOUNT state before it can be unplugged.

PDB data files are automatically removed from disk.

An unplugged PDB can be plugged into the same or another container database (CDB).

Question 25

Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)? (Choose three.)

Options:

tracking the most recent read time for a table segment in a user tablespace

tracking the most recent write time for a table segment in a user tablespace

tracking insert time by row for table rows

tracking the most recent write time for each block in a table segment

tracking the most recent read time for a table segment in the sysaux tablespace

tracking the most recent write time for a table segment in the sysaux tablespace

Question 26

Which two components are contained only in CDB$ROOT? (Choose two.)

Options:

the unified audit trail

database links between PDBs in the CDB

PDB service names

resource manager plans for each PDB in the CDB

the default TEMP tablespace for the entire CDB

Question 27

Which three conditions must be true for unused block compression to be used automatically while performing backups by using RMAN? (Choose three.)

Options:

The COMPATIBLE initialization parameter is set to 10.2 or higher.

There are no guaranteed restore points defined for the database.

The default device for the backup must be set to disk.

The tablespaces are locally managed.

The fast recovery area is less than 50 percent free.

Question 28

Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

Options:

By default, EM express is available for a database after database creation.

You can use EM express to manage multiple databases running on the same server.

You can perform basic administrative tasks for pluggable databases by using the EM express interface.

You cannot start up or shut down a database instance by using create and configure pluggable databases by using EM express.

You can create and configure pluggable databases by using EM express.

Question 29

Examine the RMAN command:

RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;

RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

Which prerequisite must be met before accomplishing the backup?

Options:

The password for the encryption must be set up.

Oracle wallet for the encryption must be set up.

All the tablespaces in the database must be encrypted.

Oracle Database Vault must be enabled.

Question 30

Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)? (Choose three.)

Options:

A DBA can check specific tables with the DMU

The database to be migrated must be opened read-only.

The release of the database to be converted can be any release since 9.2.0.8.

The DMU can report columns that are too long in the converted characterset

The DMU can report columns that are not represented in the converted characterset

Question 31

Your multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode contains two pluggable databases (PDBs), PDB2_1 and PDB2_2, both of which are open. RMAN is connected to the target pluggable database PDB2_1.

RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

Which statement is true about the execution of this command to back up the database?

Options:

All data files belonging to PDB2_1 are backed up and all archive log files are deleted.

All data files belonging to PDB2_1 are backed up along with the archive log files.

Only the data files belonging to pdb2_1 are backed up.

This command gives an error because archive log files can be backed up only when RMAN is connected to the root container database.

Question 32

Which two statements are true regarding Oracle Data Pump? (Choose two.)

Options:

EXPDP and IMPDP are the client components of Oracle Data Pump.

DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.

Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.

Oracle Data Pump imports can be done from the export files generated in the Original Export Utility.

EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.

Question 33

You execute the command to recover your database:

Question # 33

Which statement is true?

Options:

It restores all data files from the specified time, and then applies the redo logs.

It restores all data files, redo log files, and control files, and then applies the redo logs up to the specified time.

It restores all data files and control files from the most recent backup taken before the “until time”, and then recovers up to the “until time” using any restored archive logs that are needed to complete the task.

It restores the control file and all data files from the most recent backups, and then applies the redo logs up to the “until time”.

Question 34

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

Options:

ALTER TABLESPACE adtbs RESI2E 20G;

ALTER TABLESPACE adtbs ADD DATAFILE;

ALTER TABLESPACE adtbs AUTOEXTEND ON;

ALTER TABLESPACE adtbs ADD DATAFILE '/proddb/data/adtbsl.dbf' SIZE 1QG;

ALTER TABLESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf AUTOEXTEND ON;

Question 35

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

Options:

Use Data Pump.

Use ALTERTABLE. . .MOVE

Use CREATE TABLE AS SELECT

Use alter tablespace to encrypt the tablespace after enabling row movement on all its disk space

Use altertablespace to encrypt the tablespace.

Question 36

Which four are true about Consolidated Database Replay? (Choose four.)

Options:

The workload capture and replay servers must run the same operating system (OS).

Multiple workload captures from multiple databases can be replayed simultaneously.

A subset of the captured workload can be replayed.

The number of captured workloads must be the same as the number of PDBs in a multitenant CDB.

Multiple replay schedules can be defined for a consolidated replay.

A single replay schedule can be defined for a consolidated replay.

A superset of the captured workload can be replayed.

Question 37

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

Question # 37

Which statement is true?

Options:

The command executes successfully, enabling the C##A_ADMIN user to create a tablespace only in the root database.

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

The command fails because the CONTAINER clause is not used.

The command fails because system privileges cannot be granted to a common user.

Question 38

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?

Options:

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.

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.

Start up the database instance by using the STARTUP UPGRADE command and gather fixed object statistics to minimize the time needed for recompilation.

Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade operations.

Question 39

Which three are true about Transparent Data Encryption (TDE)? (Choose three.)

Options:

It stores the current and all past master keys in the keystore.

It replaces secure application roles.

Master encryption keys are managed by Oracle Database Vault.

It can encrypt data at the column level.

It uses a single master key for a database.

It encrypts only data on the client.

Question 40

You create a default Flashback Data Archive FLA1 and enable it for the EMPLOYEES table in the HR schema.

After a few days, you want to alter the EMPLOYEES table by executing the command:

SQL> ALTER TABLE EMPLOYEES ADD PHONE NUMBER(12);

Which statement is true about the execution of the command?

Options:

It gives an error because DDL statements cannot be executed on a table that is enabled for Flashback Data Archive.

It executes successfully and all metadata related to the EMPLOYEES table before altering the table definition is purged from Flashback Data Archive.

It executes successfully and continues to store metadata related to the EMPLOYEES table.

It executes successfully but Flashback Data Archive is disabled for the EMPLOYEES table.

Question 41

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?

Options:

Synchronize the recovery catalog with the target database control file.

Create a new database incarnation record.

Add the tablespaces in the recovery catalog by using the CATALOG command.

Synchronize all the physical data files with the logical records in the recovery catalog by using the CROSSCHECK command.

Load More 1z0-063 Questions

Summer Sale- Special Discount Limited Time 65% Offer - Ends in 0d 00h 00m 00s - Coupon code: netdisc

Activedumpsnet Logo

Activedumpsnet Navigation

Activedumpsnet Slider

Oracle 1z0-063 Oracle Database 12c: Advanced Administration Exam Practice Test

Oracle Database 12c: Advanced Administration Questions and Answers

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer: