최신 1Z1-052 무료덤프 - Oracle Database 11g: Administration I

문제1

Your database is down. You log in as the user SYS and issue the following command:
SQL>STARTUP
Which steps occur and in what order as a result of executing this command?

A. Instance is started, then the database is mounted and finally opened.

B. Instance is started, then the database is opened and finally mounted.

C. Instance is started and then database is mounted but not opened.

D. Only the instance is started.

정답: A

문제2

Which are three of the various resources that must be accessible to keep a database open?

A. SYSTEM tablespace

B. spfile

C. control file

D. all members of a redo log group

E. SYSAUX tablespace

정답: A,C,E

문제3

Archivelog mode is enabled for your database and DB_CREATE_FILE_DEST is set to
'/u01/oracle/db01'.
The parameters, DB_CREATE_ONLINE_LOG_DEST_n and
DB_RECOVERY_FILE_DEST, are not specified.
Which four are stored in the location specified by DB-CREATE_FILE_DEST? (Choose four.)

A. temp files

B. audit files

C. data files

D. audit logs

E. control files

F. redo logs

G. archived redo logs

H. RMAN backups

정답: C,D,E,F

설명: (DumpTOP 회원만 볼 수 있음)

문제4

You executed the following command to perform a backup of the USERS tablespace:
SQL> ALTER TABLESPACE users BEGIN BACKUP;
ALTER TABLESPACE users BEGIN BACKUP
* ERROR at line 1:
ORA-01123: cannot start online backup; media recovery not enabled
What could be the reason for this error?

A. The MTTR Advisor is disabled.

B. The Flash Recovery Area is not configured.

C. The database is in NOARCHIVELOG mode.

D. The tablespace is already in backup mode.

정답: C

문제5

You are using Enterprise Manager to schedule backups for your database.
Which type of script would be generated by the backup scheduler?

A. Operating system script

B. XML script

C. PL/SQL script

D. Recovery Manager (RMAN) script

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

문제6

Which two are true about undo tablespaces? (Choose two.)

A. Single instance databases can have only one active undo tablespace

B. They can be recovered only when an instance is in MOUNT state

C. They must have only one data file

D. Tables can be created in undo tablespaces by SYS

E. They always retain undo for the time period defined by UNDO_RETENTION

정답: D,E

문제7

Which two are true about roles? (Choose two.)

A. A role can be password-protected.

B. A role can be granted to another role.

C. Only one default role can be granted to a user.

D. A role can be granted only multiple system privileges not multiple object privileges.

E. A role can be created only by a user with the SYSDBA privilege.

정답: A,B

문제8

The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in your database instance. At a certain point of time, the maintenance window closes before the statistics are gathered for all objects.
Which statement is true in this scenario?

A. The job is terminated and the statistics for the remaining objects are collected the next time that the maintenance window is opened.

B. The statistics collection continues until all objects are processed.

C. This produces an error and the statistics collected are locked until the next time that the maintenance window is opened.

D. The job is terminated and the statistics collected are restored to a time before the job started.

정답: A

문제9

Which two are true about Optimizer Statistics? (Choose two.)

A. They do not persist across instance restarts

B. They can be gathered by executing the PL/SQL procedures in the DBMS_STATS package

C. They are automatically updated when DDL statements execute

D. They are gathered by the Manageability Monitor (MMON) background process

E. They can be used to determine the events on which a database instance waited

F. They provide information to the Optimizer so that it can determine optimal execution plans for SQL statements

정답: B,F

설명: (DumpTOP 회원만 볼 수 있음)

최신 1Z1-052 무료덤프 - Oracle Database 11g: Administration I

우리와 연락하기

유용한 링크

최신 업데이트