最新的11g認證 1Z1-052考試題庫

問題1

Which two statements are true regarding listeners? (Choose two.)

A. The listener-related errors can be traced only at the administrative level.

B. Listeners use only the TCP/IP protocol.

C. Multiple listener processes can run simultaneously on a host.

D. Multiple database instances can be registered with a single listener.

E. Only one database instance can be registered with a single listener at any time.

正確答案: C,D

問題2

Table EMP resides in the USERS tablespace.
Examine this command:
SQL> DROP TABLE emp PURGE;
Which two methods would you use to recover EMP? (Choose two.)

A. Flashback Table

B. re-creating the table and reinserting the rows

C. Flashback Transaction Backout

D. performing a tablespace point in time recovery of USERS

E. Flashback Drop

正確答案: B,D

問題3

You want to configure and schedule offline database backups to run automatically.
Which tool or utility would you use to achieve this?

A. The PL/SQL script

B. The XML script

C. Enterprise Manager to schedule the backup

D. The DBMS_SCHEDULER package

正確答案: C

問題4

The instance abnormally terminates because of a power outage.
Which statement is true about redo log files during instance recovery?

A. Inactive and current redo log files are required to accomplish recovery

B. Online and archived redo files are required to accomplish instance recovery

C. All redo log entries recorded in the current log file until the checkpoint position are applied to data files

D. All redo log entries after the last checkpoint are applied from redo log files to data files

正確答案: D

問題5

View the Exhibit to examine the error that occurred during the database startup.

You opened an RMAN session for the database. To repair the failure, you executed the following command as the first RMAN command:
RMAN> REPAIR FAILURE;
Which statement describes the consequence of this command?

A. The command only displays the advice and the RMAN script required for recovery

B. The command performs the recovery and closes the failure

C. The command produces an error because the ADVISE FAILURE command was not executed before the REPAIR FAILURE command

D. The command executes the RMAN script to repair the failure and remove the entry from the Automatic Diagnostic Repository (ADR)

正確答案: C

問題6

View the Exhibit to examine the output for the CROSSCHECK BACKUP command.

Which statement is true about the output of the command?

A. The backup piece is expired as the new backup is available

B. The backup piece is expired because the operating-system file was not found

C. The backup piece is expired because the backup set to which it belongs is not complete

D. The backup piece is expired because the retention period for the backup has expired

正確答案: B

說明：（僅 VCESoft 成員可見）

問題7

Your database is open in ARCHIVELOG mode.
LOG_ARCHIVE_DEST is set to Fast Recovery Area (FRA) and it is 100% full when a log switch takes place.
What is the outcome?

A. Obsolete backups are automatically deleted and new archivelogs are generated

B. All active sessions hang until the database administrator (DBA) makes space available in the FRA

C. No archivelogs are generated

D. All active sessions are disconnected and their transactions rolled back

E. The archivelog entries are made in the diagnostic destination and when space is available, new archivelogs are generated

正確答案: A

問題8

Your database instance is currently configured to support 1,500 connections. The Web application that uses the database allows a large number of users to work with the database simultaneously. Some users of the Web application do not interact with the server all the time. You want to increase the scalability by configuring the database instance to handle more connections. As a DBA, which configuration would you set to support more than 1,500 connections at a time?

A. You would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the users to accommodate more session information.

B. You would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that assigns more session memory to users.

C. You would configure the database in shared server mode to use the connection pooling feature.

D. You would configure more listeners for the database.

正確答案: C

問題9

Which two statements are true regarding the Oracle Data Pump export and import operations? (Choose two.)

A. You can compress the data during export but not the metadata because it is not supported.

B. You can overwrite existing dump files during an export operation.

C. You cannot export data from a remote database.

D. You can rename tables during an import operation.

正確答案: B,D

說明：（僅 VCESoft 成員可見）

問題10

Automatic Shared Memory Management is disabled for your database instance. You realize that there are cases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation of performance.
What would be your next step to improve performance?

A. Run the memory advisor for the buffer cache

B. Run the SQL Access Advisor

C. Run the memory Advisor for the SGA

D. Run the memory advisor for the shared pool

E. Run the memory Advisor for the PGA

正確答案: D

說明：（僅 VCESoft 成員可見）

最新的Oracle Database 11g: Administration I - 1Z1-052免費考試真題

最新更新

站內鏈接

聯系我們