You executed this command to create a password file:
$ orapwd file = orapworcl entries = 10 ignorecase = N
Which two statements are true about the password file?

• A.It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.
• B.It contains username and passwords of database users who are members of the OSOPER operating system group.
• C.It contains usernames and passwords of database users who are members of the OSDBA operating system group.
• D.It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.
• E.It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.

Comment: *

Name: *

Email: *

Verification: *

To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message:

SQL > startup
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.
Identify the reason the instance failed to start.

• A.The PGA_AGGREGATE_TARGET parameter is set to zero.
• B.The STATISTICS_LEVEL parameter is set to BASIC.
• C.Both the SGA_TARGET and MEMORY_TARGET parameters are set.
• D.The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about RMAN compressed backups?

• A.Compression creates some performance overhead during backups to disk.
• B.Compressed backups can be written to media only if using proxy copies.
• C.File system compression should be enabled if compressed backups are being written to disk.
• D.Compression creates some performance overhead during backups to tape.
• E.Media manager compression should not be enabled if compressed backups are being written to tape.

Comment: *

Name: *

Email: *

Verification: *

You must configure Oracle Data Redaction for the EMP table to satisfy the following requirements:
* RANDOM redaction on the SAL and COMM columns
* PARTIAL redaction on the HIREDATE column
* FULL redaction on the MGR column
What would you define to implement this?

• A.several redaction policies, with one redaction policy for each data type defined for the table that must be redacted
• B.several redaction policies, with each redaction policy specifying the redaction for table columns of that redaction type
• C.one redaction policy on the table, which specifies the redaction types for all table columns that must be redacted
• D.several redaction policies, with one redaction policy for each table column that must be redacted

Comment: *

Name: *

Email: *

Verification: *

Examine the query and its output executed In an RDBMS Instance:

Which three statements are true about the users (other than sys) in the output? (Choose three.)

• A.The C # # B_ADMIN user can perform all backup and recovery operations using RMAN only.
• B.The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.
• C.The C # # A_ADMIN user can perform wallet operations.
• D.The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).
• E.The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.

Comment: *

Name: *

Email: *

Verification: *