1.
The following parameters are set in your instance:
SGA_TARGET=3G
HASH_AREA_SIZE=100M
SORT_AREA_SIZE=100M
WORKAREA_SIZE_POLICY=AUTO
PGA_AGGREGATE_TARGET=600M A user session executes a SQL statement that performs a large sort operation. What can be determined from these settings? (Select the best two answers.)
HASH_AREA_SIZE=100M
SORT_AREA_SIZE=100M
WORKAREA_SIZE_POLICY=AUTO
PGA_AGGREGATE_TARGET=600M A user session executes a SQL statement that performs a large sort operation. What can be determined from these settings? (Select the best two answers.)
- A.The operation will be allocated 100MB.
- B.The operation will be allocated a minimum of 100MB.
- C.The *_AREA_SIZE parameters will be ignored.
- D.The *_AREA_SIZE parameters will not be ignored.
- E.The amount of memory allocated is not known.
- Answer & Explanation
- Report
Answer : [C, E]
Explanation :
Explanation :
| When the WORKAREA_SIZE_POLICY parameter is set to AUTO (the default setting), APMM will dynamically size the SQL work area. Therefore, the amount of memory actually allocated is unknown. The *_AREA_SIZE parameters have no meaning unless the WORKAREA_SIZE_ POLICY is set to MANUAL. |
2.
While performing routine management tasks on your database, you discover a high concentration
of ORA-01169 messages in the listener log. What might be the cause?
- A.Invalid setting in the sqlnet.ora file.
- B.Mismatched parentheses in the listener.ora file.
- C.Valid node checking has denied connection requests based on their host addresses.
- D.A brute force password attack has been attempted.
- E.The database is down.
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| The ORA-01169 message indicates a failed password attempt. Repeated occurrences of the message likely indicate that someone is trying to hack the password through a brute force attack. |
3.
Dirty blocks in the database buffer cache are tracked by which component?
- A.Dirty block list
- B.Block list
- C.LRU list
- D.Write list
- E.Dirty list
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| Dirty blocks in the database buffer are tracked in the write list. The write list is accessed by the DBWR process to write dirty blocks back to disk. |
4.
You want to change the password for your listener. The listener.ora file contains the following entries:
PASSWORDS_LISTENER=64F4692D9E6443F
LOGGING_LISTENER=ON
ADMIN_RESTRICTIONS=ON
Which of the following methods can you use to change the password?
PASSWORDS_LISTENER=64F4692D9E6443F
LOGGING_LISTENER=ON
ADMIN_RESTRICTIONS=ON
Which of the following methods can you use to change the password?
- A.lsnrctl
- B.EM Database Control
- C.Manually editing the listener.ora file
- D.netmgr
- E.netca
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| When the ADMIN_RESTRICTIONS option is enabled, all changes to the listener are disabled, except through manually editing the listener.ora file. This protects from changes being made remotely by unauthorized individuals. |
5.
Which of the following operations is not impacted by the size of the SQL work area? (Select the
best answer.)
- A.Index lookups
- B.Sort operations
- C.Bitmap merges
- D.Bitmap creation
- E.Bulk load operations
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| Index lookups are not memory intensive, whereas sort operations, bitmap merges, bitmap creation, and bulk load operations tend to be very memory intensive. Therefore, the SQL work area size has a major impact on their performance. |
|
|
||||||||||||||||||||||||||||
