Oracle Database 11g: Administration I (1Z1-052) Free Practice Test

Question 1

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

A. global temporary table

B. nonclustered table

C. external table

D. partitioned table

E. partitioned index

Correct Answer: B

Question 2

You plan to install Oracle Grid Infrastructure and Oracle Database
Which two mandatory tasks must be completed before you perform these installations?
(Choose two.)

A. setting the ORACLE_SID environment variable

B. creating the Oracle Inventory and OSDBA groups in the operating system

C. setting the ORACLE_BASE environment variable to an existing directory

D. creating the oper and asmdba operating system groups

E. creating an operating system user to be the owner of the Oracle installation

Correct Answer: B,E

Question 3

View the Exhibit and examine the privileges granted to the SL_REP user.

The EMP table is owned by the SCOTT user. The SL_REP user executes the following command: SQL> GRANT SELECT ON scott.emp TO hr; Which statement describes the outcome of the command?

A. The command produces an error because SL_REP does not have the SELECT privilege with GRANT_OPTION on the EMP table

B. The command executes successfully

C. The command produces an error because SL_REP has the GRANT ANY OBJECT PRIVILEGE without ADMIN_OPTION

D. The command produces an error because the EMP table is owned by SCOTT

Correct Answer: B

Question 4

See the Exhibit to observe the roles assigned to the SL_REP user.

Which statement is true about the assignment of the SELECT_CATALOG_ROLE role to the SL_REP user?

A. The user must enable the role explicitly

B. The user can grant the role to other users

C. The user can start using the role immediately without any changes

D. The user cannot user the role until the DBA enables it explicitly

Correct Answer: A

Question 5

Which is true about the Automatic Diagnostic Repository (ADR)?

A. Its location is always set by the ORACLE_BASE variable

B. It is used only if the DISGNOSTIC_DEST parameter is manually configured

C. It only contains the alert log and trace files for background processes

D. It includes diagnostic data for critical errors for each server and background process

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 6

You executed the following command to create a password file in the database server:
$ orapwd file = orapworcl entries = 5 ignorecase=N
Which statement describes the purpose of the above password file?

A. It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating groups

B. It is used by Oracle to authenticate users for remote database administrator

C. It records usernames and passwords of users when granted the DBA role

D. It contains usernames and passwords of users for whom auditing is enabled

Correct Answer: B

Question 7

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

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

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

C. A role can be granted to another role.

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

E. A role can be password-protected.

Correct Answer: C,E

Question 8

Examine the values for the following initialization parameters:
FAST_START_MTTR_TARGET=0
LOG_CHECKPOINT_INTERVAL=0
Which two will be the implications of these values in your database? (Choose two.)

A. The MTTR advisor will be disabled

B. Automatic checkpoint tuning will be disabled

C. Checkpoint information will not be written to the alert log file

D. The SGA advisor will be disabled

Correct Answer: A,B

Question 9

You want to install an Oracle 11g database and deploy it on ASM.
Your plan is to install both Oracle database and Grid Infrastructure.
Which two are true in this scenario? (Choose two.)

A. Both products must be of the same version

B. Grid Infrastructure must be installed first

C. Both products must be installed by the same OS user

D. Both products can share the OS group assigned to their OSDBA and OSOPER privileged groups

E. Both products must be installed by using the same ORACLE_BASE

F. Each product must be installed in a different ORACLE_HOME

Correct Answer: D,F

Question 10

View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour that performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives the following error:
ORA-01555: snapshot too old What could be the reason for this error?
Exhibit:

A. There is not enough free space in the flashback archive.

B. There is not enough space in Flash Recovery Area.

C. The query is unable to place data blocks in undo tablespace.

D. The query is unable to get a read-consistent image.

Correct Answer: D

Welcome to TestSimulate

Oracle Database 11g: Administration I (1Z1-052) Free Practice Test