1z0-067 무료 덤프문제 온라인 액세스

You execute the commands to configure settings in RMAN:
RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1;
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;
RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2;
RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2;
RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DRVICE TYPE DISK TO 2;
Then you issue the following command to take a backup:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which statement is true about the execution of these commands?
Choose the best answer.

• A.The backup terminates because the backup destination for disk is not specified in the BACKUP command.
• B.It backs up two copies each of the data files to disk and media, and two copies of archived logs to media.
• C.It backs up the data files and archived logs, making one copy of each data file and archived log on disk and media.
• D.It backs up the data files and archived logs to media, making two copies of each data file and archived logs.

What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?

• A.statistics recommendations
• B.SQL statement restructure recommendations
• C.creation of materialized views to improve query performance
• D.SQL profile recommendations

A redaction policy was added to the SAL column of the SCOTT.EMP table:
BEGIN
DBMS_REDACT.ADD_POLICY(
OBJECT_SCHEMA => 'SCOTT',
OBJECT_NAME => 'EMP',
POLICY_NAME => 'SCOTT_EMP',
COLUMN_NAME => 'SAL',
EXPRESSION => 'SYS_CONTEXT (''SYS_SESSION_ROLES'', ''MGR'') = ''FALSE'''); END;
/
All users have their default set of system privileges.
For which three situations will data not be redacted? (Choose three.)

• A.SCOTT sessions, only if the MGR role is granted to SCOTT
• B.SYSTEM sessions, regardless of the roles that are set in the session
• C.SCOTT sessions, because he is the owner of the table
• D.SCOTT sessions, only if the MGR role is set in the session
• E.SYS sessions, regardless of the roles that are set in the session

Your multitenant container database (CDB) contains multiple pluggable databases (PDBs). You execute the command to create a common user:
SQL> CREATE USER c##a_admin
IDENTIFIED BY password
DEFAULT TABLESPACE users
QUOTA I00M ON users
TEMPORARY TABLESPACE temp;
Which statement is true about the execution of the command?

• A.The command succeeds and sets the default permanent tablespace of a PDB as the default tablespace for the c##a_admin user if the users tablespace does not exist in that PDB.
• B.The command succeeds only if all the PDBs have the users and temp tablespaces.
• C.The common user is created in the CDB and all the PDBs, and uses the users and temp tablespaces of the CDB to store schema objects.
• D.The command gives an error because the container=all clause is missing.

Which parameter must be set to which value to implement automatic PGA memory management?

• A.Set pga_aggregate_target to a nonzero value.
• B.Set sgajtarget to zero.
• C.Set pga_aggregate_target and sga_target to the same value.
• D.Set memory_target to zero.
• E.Set STATISTICS_LEVEL to BASIC.