16.
You are working with Oracle Support to resolve a database issue. The support technician asks
you to forward any diagnostic files that might help them resolve the issue. Which two of the following
choices represent the best files to send?
- A.Alert log
- B.Trace files from the USER_DUMP_DEST directory
- C.Trace files from the BACKGROUND_DUMP_DEST directory
- D.Files from both the USER_DUMP_DEST directory and the BACKGROUND_DUMP_DEST directory
- E.External procedure files
- Answer & Explanation
- Report
Answer : [A,C]
Explanation :
Explanation :
| The alert log can be used to find error messages and other significant events, along with a timestamp. Trace files from background sessions may also be helpful to determine the cause of the problem. User trace files can be helpful to resolve errant SQL statements, but those are not classified as database problems. External procedure files do not exist. |
17.
You notice that a lot of disk space is being used up on one of your mount points. Upon investigating,
you find that SQL tracing is turned on for the instance. You issue an ALTER SYSTEM
statement to turn it off. In an SPFILE environment, how can you determine if it was turned on
at startup or if it was turned on using an ALTER SYSTEM statement? Select the best answer.
- A.User process trace file
- B.Alert log
- C.System log
- D.Background process trace file
- E.init.ora file
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| The alert log details all startup events, including listing all of the non-default initialization parameters that were set. |
18.
Your instance does not have a value set for the PGA_AGGREGATE_TARGET initialization parameter.
The server has 8GB of memory and the SGA is using 4GB. Which of the following statements is
true regarding APMM for this instance?
- A.It will not be enabled.
- B.It will use the default size of 10MB.
- C.It will always use the *_AREA_SIZE parameters.
- D.It will use the default size of 800MB.
- E.It will dynamically allocate unused SGA memory.
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| If the PGA_AGGREGATE_TARGET parameter is not explicitly set, it will default to the greater of 10MB or 20 percent of the SGA size (800MB). Therefore, it will default to 800MB. |
19.
Your junior DBA accidentally deleted the alert log file. How do you ensure that Oracle will
continue to function? Choose the best answer.
- A.Restore the most recent backup.
- B.Shut down the instance. A new file will be created on startup.
- C.Create a new alert log file using EM Database Control.
- D.Create a new alert log file using the ALTER SYSTEM statement.
- E.Do nothing.
- Answer & Explanation
- Report
Answer : [E]
Explanation :
Explanation :
| A new alert log will be created automatically the next time Oracle needs to write an alert log entry, so no action is required. You may indeed wish to restore the last backup of the alert log if you want it for historical purposes, but that has no effect on the Oracle instance itself. |
20.
You execute a Java stored procedure consisting of a single SQL statement using a large hash-join
operation and a large sort operation. Which memory structure will have the most impact on
your performance?
- A.Shared pool
- B.Java pool
- C.SQL work area
- D.Private SQL area
- E.Shared SQL area
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| Though Java stored procedures utilize Java pool memory, the usage is minimal. A large sort operation, on the other hand, is greatly impacted by the size of the SQL work area available to it. |
|
|
||||||||||||||||||||||||||||
