1Z1-052試験無料問題集（285題）「Oracle Database 11g: Administration I 認定」

出題：1

You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order:
1) Shut down the instance.
2) Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value.
3) Execute the ALTER DATABASE FLASHBACK OFF command.
4) Start up the instance and mount the database.
5) Execute the ALTER DATABASE FLASHBACK ON command.
6) Open the database.
Select the correct order in which these tasks need to be performed.

A. 1, 4, 2, 6, 3, 5

B. 3, 2, 1, 4, 5, 6

C. 1, 4, 3, 2, 6, 5

D. 2, 1, 4, 3, 5, 6

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

Which two are true about data dictionary views? (Choose two.)

A. DBA prefixed views are accessible when a database is in mount state

B. A user can query the DBA prefixed with DBA or ALL or USER

C. ALL or USER prefixed views display output that are subsets of the output from the DBA prefixed data views

D. All data dictionary views are prefixed with DBA or ALL or USER

E. A user may not necessarily be the owner of all objects that can be viewed by using the ALL prefixed views

正解：D,E 解答を投票する

出題：3

Which two are true about the Fast Recovery Area (FRA)? (Choose two.)

A. Only consistent backups can be stored in the FRA

B. It should be larger than the database

C. A database must be in ARCHIVELOG mode to use the FRA

D. It must reside on the same file system as the database data files

E. Space management in the FRA is controlled by the database backup retention policy

正解：B,E 解答を投票する

出題：4

Identify the logical structure that will never have more than one data segment created for it.

A. partitioned index

B. external table

C. nonclustered table

D. global temporary table

E. partitioned table

正解：C 解答を投票する

出題：5

The session of user SCOTT receives the following error after executing an UPDATE command on the EMP table:
ERROR at line 1:
ORA-00060: deadlock detected while waiting for resource
On investigation, you find that a session opened by user JIM has a transaction that caused the deadlock.
Which two statements are true regarding the session of SCOTT in this scenario? (Choose two.)

A. SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.

B. The session is rolled back after receiving the error and JIM can continue with his transaction.

C. The session is terminated after receiving the error and JIM can continue with his transaction.

D. SCOTT has to reexecute the last command in the transaction after he commits the transaction.

正解：A,D 解答を投票する

出題：6

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

A. You cannot export data from a remote database.

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

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

D. You can rename tables during an import operation.

正解：C,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

You are managing an Oracle Database 11g database with the following backup strategy:
1. On Sunday, an incremental level 0 tape backup is performed
2. Monday through Saturday, a cumulative incremental level 1 tape backup is performed Which two statements are true regarding the backups performed? (Choose two.)

A. The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup

B. The backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup

C. The backup performed in step 2 backs up all blocks that have changed since the most recent incremental backup at level 1

D. The backup performed in step 1 backs up all blocks that have ever been in use in the database

正解：A,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：8

Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enabled?

A. It is the time period after which the committed undo data would be transferred to a temporary tablespace.

B. It is the minimum time period up to which the committed undo data would be retained if free undo space is available.

C. It is the time period after which the undo data is transferred to the Flash Recovery Area to provide read consistency.

D. It is the time period after which the undo data becomes obsolete.

正解：B 解答を投票する

出題：9

View the Exhibit and examine the output.

Which two statements are true regarding the LISTENER2 listener? (Choose two.)

A. The number of current client connections handled by the service handler is two.

B. The ORCL instance is registered dynamically with the listener.

C. The ORCL instance is registered statically in the listener.ora file.

D. The total number of client connections handled so far by the service handler is two.

正解：C,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：10

Which two statements about the background process of the database writer are true?
(Choose two.)

A. It is possible to have multiple database writers in an Oracle instance.

B. It writes dirty buffers, if any, to data files before the log writer (LGWR) writes.

C. It writes dirty buffers, if any, to data files whenever a transaction commits.

D. It writes dirty buffers, if any, to data files whenever a checkpoint occurs.

正解：A,D 解答を投票する

出題：11

You executed the following commands in an RMAN session for your database instance that has failures:
RMAN> LIST FAILURE;
After some time, you executed the following command in the same session:
RMAN> ADVISE FAILURE;
But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?

A. It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored.

B. It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.

C. It produces a warning for new failures before advising for CRITICAL and HIGH failures.

D. It ignores new failures and considers the failures listed in the last LIST FAILURE command only.

正解：C 解答を投票する

1Z1-052試験無料問題集「Oracle Database 11g: Administration I 認定」