In one of your databases, unified auditing is enabled and an SH.SALES table exists.
You can successfully execute these commands:

Which statement is true about SALES_POL?

• A.It is only enabled for SH.
• B.It is enabled for all users having SELECT privilege on SH.SALES.
• C.Audit records are always stored in an external audit file.
• D.Only successful queries of SH.SALES are written to the audit trail.

Comment: *

Name: *

Email: *

Verification: *

You Execute the Following command to create a password file in the database server:
$ orapwd file = '+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12' Which two statements are true about the password file? (Choose two.)

• A.It records the usernames and passwords of users when granted the DBA role.
• B.It contains the usernames and passwords of users for whom auditing is enabled.
• C.Is used by Oracle to authenticate users for remote database administration.
• D.It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.
• E.It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.

Comment: *

Name: *

Email: *

Verification: *

Which set of statements is true about data dictionary views?
1. They are stored in the SYSTEM tablespace.
2. They are based on virtual tables.
3. They are owned by the SYS user.
4. They can be queried by a normal user only if the 07_DICTIONARY_ACCESSIBILITY parameter is set to TRUE.
5. The V$FIXED_TABLE view can be queried to list the names of these views.
6. They are owned by the SYSTEM user.

• A.2, 5, and 6
• B.1, 2, and 3
• C.1 and 3
• D.2, 3, 4, and 5

Comment: *

Name: *

Email: *

Verification: *

An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out
of the default buffer cache.
How would you guarantee that the blocks for the table never age out?

• A.Configure the KEEP buffer pool and alter the table with the corresponding storage clause.
• B.Increase the database buffer cache size.
• C.Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.
• D.Configure Automata Shared Memory Management.
• E.Configure Automatic Memory Management-

Comment: *

Name: *

Email: *

Verification: *

You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute the following script:
SQL > @utlrp.sql
Which two actions does the script perform? (Choose two.)

• A.Parallel compilation of only the stored PL/SQL code
• B.Sequential recompilation of only the stored PL/SQL code
• C.Parallel recompilation of any stored PL/SQL code
• D.Sequential recompilation of any stored PL/SQL code
• E.Parallel recompilation of Java code
• F.Sequential recompilation of Java code

Comment: *

Name: *

Email: *

Verification: *