Note! Following 1z0-063 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

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

Go to page:

Question # 33

Examine the commands executed in the root container of your multitenant container database (CDB) that has multiple pluggable databases (PDBs):

SQL> CREATE USER c##a_admin IDENTIFIED BY orcl123;

SQL> CREATE ROLE c##role1 CONTAINER=ALL;

SQL> GRANT CREATE VIEW TO C##roleI CONTAINER=ALL;

SQL> GRANT c##role1 TO c##a_admin CONTAINER=ALL;

SQL> REVOKE c##role1 FROM c##a_admin;

What is the result of the revoke command?

It executes successfully and the c##role1 role is revoked from the c##a_admin user only in the root container.

It fails and reports an error because the container=all clause is not used.

It executes successfully and the c##rocl1 role is revoked from the c##a_admin user in the root database and all the PDBs.

It fails and reports an error because the container=current clause is not used.

Full Access

Question # 34

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.

Full Access

Question # 35

Examine the command:

Which statement is true about the execution of the command?

It fails because the log file parameter is not specified.

It fails because no absolute path is specified for the log file and dump file.

It succeeds and exports the full database, simultaneously creating three copies of dump files at three different locations.

It succeeds and exports the full database, simultaneously creating three dump files at three different locations, but the total number of dump files can exceed three.

Full Access

Question # 36

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

a PDB

CDB$ROOT

PDB$SEED

a non-CDB

an Application Root

Full Access

Question # 37

In which three situations must you use a recovery catalog? (Choose three.)

when you want to store RMAN global scripts that can be used across multiple databases

when you want to restrict the amount of space used by backups

when you want to perform incremental backups by using a block change tracking file

when you want to list data files that were in a target database at a given time by using the AT clause with the REPORT SCHEMA command

when you want to maintain backup metadata longer than the period specified by the CONTROL_FILE_RECORD_KEEP_TIME parameter

Full Access

Question # 38

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.

Full Access

Question # 39

One of your databases is in ARCHIVELOG mode and take nightly RMAN backups.

The USERS and IDX tablespaces are missing due to storage array errors.

Which four actions would recover the tablespaces and their contents while the database remains open? (Choose four.)

Bring both tablespaces ONLINE.

Recover both tablespaces.

Take both tablespaces OFFLINE NORMAL.

Take both tablespaces OFFLINE IMMEDIATE.

Restore both tablespaces from the most recent backup.

Bring both tablespaces ONLINE and rebuild all the instances in the IDX tablespace.

Full Access

Question # 40

You set the following parameters in the parameter file and restart the database instance:

NEMORY_MAX_TARGET=0

MEMORY__TARGET=500M

PGA_AGGREGATE_TARGET=90M

SGA_TARGET=270M

Which two statements are true? (Choose two.)

The memory_max_target parameter is automatically set to 500 MB.

The pga_aggregate_target and sga_target parameters are automatically set to zero.

The value of the memory_max_target parameter remains zero for the database instance.

The lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and 270 MB respectively.

The instance does not start up because Automatic Memory Management (AMM) is enabled but pga_aggregate_target and sga_target parameters are set to nonzero values.

Full Access

Go to page: