30 January, 2022

How Many Questions Of 1Z0-063 Free Exam Questions

Want to know Actualtests 1Z0-063 Exam practice test features? Want to lear more about Oracle Oracle Database 12c: Advanced Administration certification experience? Study Pinpoint Oracle 1Z0-063 answers to Rebirth 1Z0-063 questions at Actualtests. Gat a success with an absolute guarantee to pass Oracle 1Z0-063 (Oracle Database 12c: Advanced Administration) test on your first attempt.

Check 1Z0-063 free dumps before getting the full version:

Page: 1 / 19

Total 235 questions Full Exam Access

Question 1

- (Exam Topic 2)
Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?

The PDB is closed and the temp file is re-created automatically when the PDB is opened.

The PDB is closed and requires media recovery at the PDB level.

The PDB does not close and the temp file is re-created automatically whenever the container database (CDB) is opened.

The PDB does not close and starts by using the default temporary tablespace defined for the CDB.

Question 2

- (Exam Topic 1)
You want to create a guaranteed restore point for your database by executing the command: SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Identify two prerequisites for the successful execution of this command. (Choose two.)

The database must be running in ARCHIVELOG mode.

Flashback Database must be enabled.

Fast Recovery Area must be enabled.

The recyclebin must be enabled for the database.

Undo retention guarantee must be enabled.

A database backup must be taken.

Question 3

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

CDB$ROOT, PDB$SEED, and the PDBs are opened in read-only mode.

CDB$ROOT and PDB$SEED are opened in read-only mode, but the PDBs are in closed mode.

CDB$ROOT is opened in read/write mode, but PDB$SEED and the PDBs are in closed mode.

CDB$ROOT is opened in read/write mode, PDB$SEED in read-only mode, and the PDBs in MOUNT state.

CDB$ROOT, PDB$SEED, and the PDBs are opened in read/write mode.

Question 4

- (Exam Topic 1)
You execute the RMAN commands:
RMAN> BACKUP VALIDATE DATABASE; RMAN> RECOVER CORRUPTION LIST;
Which task is performed by these commands?

Corrupted blocks, if any, are repaired in the backup created.

Only those data files that have corrupted blocks are backed up.

Corrupted blocks in the data files are checked and repaired before performing the database backup.

The database is checked for physically corrupt blocks and any corrupted blocks are repaired.

Question 5

- (Exam Topic 1)
In which situation can you use Flashback Database?

when undoing a shrink data file operation

when retrieving a dropped tablespace

when returning to a point in time before the restoration or re-creation of a control file

when returning to a point in time before the most recent OPEN RESETLOGS operation

Question 6

- (Exam Topic 2)
You issue the RMAN command:
RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;
Which statement is true about the execution of the command?

The resulting backupset has backup pieces that cannot exceed 300 MB.

RMAN uses multiplexing to perform the backup.

RMAN always performs this type of backup in parallel.

The backup succeeds only if the USERS tablespace is locally managed.

The backup set size is limited to 300 MB.

Question 7

- (Exam Topic 2)
You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). RMAN is connected to CDB$ROOT.
Examine the command:
RMAN> LIST FAILURE;
Which statement is true about this command?

It lists failures only for the CDB root database.

It lists failures for a PDB only when RMAN is connected to a recovery catalog.

It lists failures for the CDB and all the PDBs in this CDB.

It lists failures only if RMAN is connected to a PDB.

Question 8

- (Exam Topic 2)
Which three conditions must be met before you create a Virtual Private Catalog (VPC)? (Choose three.)

A base recovery catalog should exist.

The owner of 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 recovery_catalog_owner role should be granted to the virtual catalog owner.

Question 9

- (Exam Topic 1)
Examine the command to create a pluggable database (PDB): SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1
FILE_NAME-_CONVERT = ('/disk1/oracle/pdb1/', '/disk2/oracle/pdb2/’) PATH_PREFIX = '/disk2/oracle/pdb2';
Which two statements are true? (Choose two.)

The pluggable database pdb2 is created by cloning pdb1 and is in mount state.

Details about the metadata describing pdb2 are stored in an XML file in the '/disk2/oracle/pdb2/' directory.

The tablespace specifications of pdb2 are the same as pdb1.

All database objects belonging to common users in PDB1 are cloned in PDB2.

pdb2 is created with its own private undo and temp tablespaces.

Question 10

- (Exam Topic 2)
Which three requirements should be successfully met by an Oracle Secure Backup (OSB) user so that OSB performs RMAN backup or restore requests? (Choose three.)

RMAN preauthorization on the host

OSB encryption for data in transport and on tape

matching the OS user identity of the Oracle instance associated with the database username

assigned to a class with rights to back up or restore Oracle database

scheduling of the RMAN backup to occur automatically at user-defined intervals

assigned to a class with rights to browse all directories and catalogs

Question 11

- (Exam Topic 2)
Which two statements are true about a common user? (Choose two.)

A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs.

A common user with the CREATE USER privilege can create other common users, as well as local users.

A common user can be granted only a common role.

A common user can have a local schema in a PDB.

A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace.

Question 12

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

Flashback data archives (FDA)

Archived redo log files

Control file autobackups

Server parameter file (SPFILE)

Recovery Manager (RMAN) backup pieces

Question 13

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

2, 4, and 3

2, 4, 3, and 5

1, 5, 2, 4, 3, and 6

1, 2, 4, 3, and 6

Question 14

- (Exam Topic 2)
You use RMAN to take regular backups for your database. Examine the RMAN commands:
RMAN> CROSSCHECK BACKUP; RMAN> DELETE EXPITED BACKUP;
Which statement is true?

All backups and archived redo log files that are not required for the recovery are deleted and the repository is updated.

All metadata, for backups and archived redo log files that are recorded in the repository but do not exist on disk or media, is deleted.

All backups that have exceeded the age set by the RMAN retention policy are deleted.

All metadata pertaining to backups and archived redo log files that have exceeded the age set by the RMAN retention policy are deleted from the repository.

Question 15

- (Exam Topic 1)
Your database is running in NOARCHIVELOG mode. One of the data files belonging to the SYSTEM tablespace is corrupted. You notice that all online redo logs have been overwritten since the last backup.
Which method would you use to recover the data file?

Shut down the instance if not already shut down, restore all data files belonging to the SYSTEM tablespace from the last backup, and restart the instance.

Shut down the instance if not already shut down, restore the corrupted data file belonging to the SYSTEM tablespace from the last backup, and restart the instance.

Shut down the instance if not already shut down, restore all data files for the entire database from the last backup, and restart the instance.

Mount the database, restore all data files belonging to the SYSTEM tablespace from the last backup, and open the database.

Question 16

- (Exam Topic 1)
Because of logical corruption of data in a table, you want to recover the table from an RMAN backup to a specified point in time.
Examine the steps to recover this table from an RMAN backup:
1. Determine which backup contains the table that needs to be recovered.
2. Issue the RECOVER TABLE RMAN command with an auxiliary destination defined and the point in time specified.
3. Import the Data Pump export dump file into the auxiliary instance.
4. Create a Data Pump export dump file that contains the recovered table on a target database. Identify the required steps in the correct order.

1, 4, 3

1, 2

1, 4, 3, 2

1, 2, 4

Question 17

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

1, 3, 6, 7, 4

2, 1, 6, 4, 7

1, 3, 5, 7, 4

1, 3, 6, 4, 7

Question 18

- (Exam Topic 2)
Consider the following scenario for your database: Backup optimization is enabled in RMAN.
The recovery window is set to seven days in RMAN.
The most recent backup to disk for the tools tablespace was taken on March 1, 2013. The tools tablespace is read-only since March 2, 2013.
On March 15, 2013, you issue the RMAN command to back up the database to disk. Which statement is true about the backup of the tools tablespace?

The RMAN backup fails because the tools tablespace is read-only.

RMAN skips the backup of the tools tablespace because backup optimization is enabled.

RMAN creates a backup of the tools tablespace because backup optimization is applicable only for the backups written to media.

RMAN creates a backup of the tools tablespace because no backup of the tablespace exists within the seven-day recovery window.

Question 19

- (Exam Topic 1)
Which three statements correctly describe the relationship amongst jobs, programs, and schedules within the Oracle Job Scheduler? (Choose three.)

A job is specified as part of a program definition.

A program can be used in the definition of multiple jobs.

A program and job can be specified as part of a schedule definition.

A program and schedule can be specified as part of a job definition.

A program and window can be specified as part of a job definition.

Question 20

- (Exam Topic 1)
You are administering a database that supports 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. You want to recover the data file.
Examine the steps involved in the recovery process:
1. Shut down the database instance.
2. Start up the database instance in NOMOUNT state.
3. Mount the database.
4. Take the data file offline.
5. Put the data file online.
6. Restore the control file.
7. Restore the database.
8. Restore the data file.
9. Open the database with the RESETLOG option.
10. Recover the database with the NOREDO option.
11. Recover the data file with the NOREDO option. Identify the required steps in the correct order.

4, 8, 11, 5

1, 3, 8, 11, 9

1, 2, 6, 3, 7, 10, 9

1, 3, 7, 10, 9

1, 2, 6, 3, 8, 11, 9

Question 21

- (Exam Topic 2)
Your database is running in archivelog mode and Automatic Undo Management is enabled. Which two tasks should you perform before enabling Flashback Database? (Choose two.)

Enable minimal supplemental logging.

Ensure that the db_flashback_retention_target parameter is set to a point in time (in minutes) to which the database can be flashed back.

Enable the recyclebin.

Enable undo retention guarantee.

Enable Fast Recovery Area.

Question 22

- (Exam Topic 2)
You create two Resource Manager plans, one for night time workloads, the other for day time. How would you make the plans switch automatically?

Use job classes.

Use scheduler windows.

Use the mapping rule for the consumer groups.

Set the switch_time plan directive for both plans.

Use scheduler schedules.

Question 23

- (Exam Topic 1)
Examine the command to back up the ASM metadata: ASMCMD>md_backup /backup/ASM_backup
In which three situations can you use the backup? (Choose three.)

when one or more disks in an ASM disk group are lost

when the data file on an ASM disk group gets corrupted

when one of the disks in a disk group is accidentally unplugged

when one or more file directory paths are accidentally deleted from an ASM disk group

when all the ASM disk groups for the ASM instance are lost

Page: 1 / 19

Total 235 questions Full Exam Access