Oracle database 10g:Administration I 認定 1Z0-042 試験問題:

1. Users of HR schema complain about slower-than-normal performance. On investigation the DBA found that maintenance was recently performed on some of the tables. The DBA traced the query that takes longer than normal to execute.
View the Exhibit exhibit_before.
After the DBA resolves the problem, the query performs normally.
View the Exhibit exhibit_after.
What action would the DBA have taken to resolve the performance problem?

A) analyzed the EMPLOYEES table to collect the current statistics
B) reorganized the associated indexes for the EMPLOYEES table that were in an unusable state
C) moved the EMPLOYEES table to another location in the same tablespace
D) moved the indexes associated with the EMPLOYEES table to the same tablespace where the EMPLOYEES table exists
E) moved the EMPLOYEES table in to a locally managed tablespace

2. Which two statements are true regarding a PL/SQL package body? (Choose two.)

A) It can contain only the subprograms defined in the package specification.
B) It can be changed and recompiled without making the package specification invalid.
C) It cannot invoke subprograms defined in other packages.
D) It cannot be created without a package specification.

3. You find that the database performance degrades while you backup the PROD database using Recovery Manager (RMAN). The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation?

A) Configure Streams Pool to enable parallel processing.
B) Increase Database Buffer Cache size to increase cache hits.
C) Increase Shared Pool size to cache more PL/SQL objects.
D) Configure Large Pool to be used by RMAN and shared server.
E) Increase the total System Global Area (SGA) size to increase memory hits.
F) Configure Java Pool to cache the java objects.

4. Your database is started by using the server parameter file (SPFILE). You issued this command to change the value of the LOG_BUFFER initialization parameter:
ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH;
What would be the outcome of this command?

A) You need to restart the database so that parameter changes can come into effect.
B) The command would return an error because LOG_BUFFER is a static parameter.
C) The parameter value would be changed and it would come into effect immediately.
D) The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.

5. Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario? (Choose two.)

A) The instance aborts.
B) The database can be recovered by restoring the control files from the backup.
C) The database cannot be recovered.
D) The database remains opened and you have to shut it down with the ABORT option.
E) The database can be restored till the point of the last closed whole database backup.

質問と回答：