This preview shows page 1. Sign up to view the full content.
Unformatted text preview: terprise Manager can generate database reports.
Which three statements are true about this feature? (Choose three)
A. It can generate bar chart diagrams.
B. It generates HTML reports of database objects.
C. You can extend the reports with your own SQL selects.
D. It can be run stand-alone, without a repository or agent.
Answer: B, C, D
Which statement correctly describes setup of a server-persistent parameter file
(SPFILE) when used with Real Application Clusters?
A. One SPFILE, created from a text parameter file (PFILE), is required for each
B. You must create a separate text parameter file (PFILE) for each instance and
merge them with the CREATE SPFILE FROM PFILE =(
list_of_files ); command to create one common SPFILE.
C. You can add the instance-specified parameters to a common SPFILE with the
ALTER SYSTEM _ SCOPE=SPFILE SID=name ; command.
D. One common SPFILE is required for instances: it has a parameter
INSTANCE_name_SPFILE, which in turn points to the instance-specific
At a minimum, from what point should you leave the
RESOURCE_MANAGER_PLAN initialization parameter set to an existing plan, in
order to be able to issue the ALTER SYSTEM QUIESCE RESTRICTED command?
A. Since instance startup.
B. Since database creation.
C. Since it was set using the ALTER SYSTEM command.
D. Since the TIMED_STATISTICS initialization parameter was set.
You are using Oracle Shared Server. If the large pool is not configured, which two
are stored in the shared pool instead of in private user memory? (Choose two.) Actualtests.com - The Power of Knowing 1Z0-030
B. user sort results
C. user session information
D. cursor state information
Answer: C, D
Which two pieces of information are in the alert log and can be effectively used for
database performance tuning? (Choose two.)
A. process ID of PMON
B. System Change Number
C. non-default initialization parameters
D. operating system authentication prefix
E. statements that contain such keywords as ALTER, STARTUP, SHUTDOWN,
ARCHIVE LOG, and RECOVER
Answer: C, E
You word for a manufacturing company that frequently runs its production lines 24
hours a day. The accounting department is working with the development staff on
plans to create an application to track manufacturing costs at the shop floor level.
As a senior DBA, you have been assigned the task of ensuring that the new
application will run with sub-second response time as information is entered into
the application via terminals installed in the manufacturing area. Daily, weekly and
monthly reports will also be run overnight detailing the previous period's activity.
The reports must run during a time of high user interaction with the database.
Choose two tasks that you should perform to make sure that the new application
meets its sub-second response time requirement. (Choose two.)
A. Help design the screen layout used to input the data into the application.
B. Help with the design of the tables used in the application...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09