1Z1-052 by Oracle Valid Free Exam Practice Test

Question 1

You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups.
Which three statements are true about these backups? (Choose three.)

A. The backups need to be restored and the database has to be recovered in case of a media failure. B. The backups would be consistent. C. The backups would be possible only if the database is running in NOARCHIVELOG mode. D. The backups would be inconsistent. E. The backups would be possible only if the database is running in ARCHIVELOG mode.

Correct Answer: A,D,E

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

Question 2

USER1 grants SELECT, INSERT, and UPDATE privileges on USER1, EMP to USER2.
SYS executes this command:
SQL>REVOKE UPDATE ON user1.emp FROM user1;
What will be the outcome?

A. It will fail because USER1 is the owner of USER1.EMP B. It will succeed and only USER2 will be unable to perform SELECT, INSERT, or UPDATE on USER1.EMP C. It will succeed but neither USER1 nor USER2 will be able to perform SELECT, INSERT, or UPDATE on USER1.EMP D. It will succeed and neither USER1 nor USER2 will be able to perform INSERT or UPDATE on USER1.EMP, but both will be able to query USER1.EMP E. It will succeed and only USER1 will be unable to perform SELECT, INSERT, or UPDATE on USER1.EMP

Correct Answer: A

Question 3

Which two are true about transactions, UNDO segments, and UNDO tablespaces?
(Choose two.)

A. All transactions belonging to a single session use the same UNDO segment B. UNDO tablespaces are brought ONLINE or OFFLINE as required C. UNDO segments grow or shrink automatically D. UNDO tablespaces are created and dropped automatically E. UNDO segments are created and dropped automatically

Correct Answer: C,D

Question 4

See the Exhibit:

Which statements are true regarding the USERS tablespace? (Choose all that apply.)

A. Free extents information is managed within the tablespace B. The data dictionary tables are updated when extents are allocated or deallocated C. Free extents information is managed in the SYSAUX tablespace D. A bitmap is used to record free extents

Correct Answer: A,D

Question 5

The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command:

Which statement is true after HR issues the REVOKE command?

A. The command fails because SCOTT still has privileges. B. The command succeeds and privileges are revoked from JIM. C. The command fails because HR cannot revoke the privileges from JIM. D. The command succeeds and only HR has the privilege to perform the SELECT, INSERT, and UPDATE operations on the EMP table.

Correct Answer: C

Question 6

You have issued a SHUTDOWN ABORT command to bring down your database instance.
Consider the steps that will be performed later when you open the database:
1 . SGA is allocated.
2 . Control file is read.
3 . Redo log files are opened.
4 . Instance recovery is started.
5 . Background processes are started.
6 . Data file headers are checked for consistency.
7. Server parameter file or the initialization parameter file is read.
Which option has the correct order in which these steps occur?

A. 1, 7, 5, 4, 2, 3, 6 B. 7, 1, 4, 5, 2, 3, 6 C. 7, 1, 5, 2, 3, 6, 4 D. 1, 2, 3, 7, 5, 6, 4

Correct Answer: C

Question 7

In which three situations does the Oracle Data Pump use external tables and not the direct path load while exporting a table? (Choose three.)

A. If a table has an active trigger B. If a table has a VARCHAR2 column in it C. If a table has an encrypted column D. If a table has a referential integrity constraint defined on it E. If a table is not in a cluster

Correct Answer: A,C,D

Question 8

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. creating the Oracle Inventory and OSDBA groups in the operating system B. setting the ORACLE_BASE environment variable to an existing directory C. setting the ORACLE_SID environment variable 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: A,E

Question 9

Note the functionalities of various background processes:
1 : Perform recovery at instance startup.
2 : Free the resources used by a user process when it fails.
3 : Cleanup the database buffer cache when a process fails.
4 : Dynamically register database services with listeners.
5 : Monitor sessions for idle session timeout.
6 : Cleanup unused temporary segments.
7 : Record the checkpoint information in control file.
Which option has the correct functionalities listed for a background process?

A. Database Writer (DBWR): 1, 3, 4 B. Process Monitor (PMON): 4, 6, 7 C. Checkpoint (CKPT): 1, 2, 5 D. System Monitor (SMON): 1, 6

Correct Answer: D

Question 10

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 SGA advisor will be disabled B. The MTTR advisor will be disabled C. Automatic checkpoint tuning will be disabled D. Checkpoint information will not be written to the alert log file

Correct Answer: B,C

Question 11

Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee:
SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;
What affect would this command have on the database?

A. The extents containing committed data in the undo tablespace are not overwritten until the instance is shut down B. The extents containing committed undo in the undo tablespace are not overwritten for at least 15 minutes C. The extents in the undo tablespace retain data until the next full database backup D. The extents containing committed undo in the undo tablepace are transferred to Flash Recovery Area before being overwritten

Correct Answer: B

Question 12

Your database instance is in the open state with uncommitted transactions.
You plan to execute these commands:

Which is true about the STARTUP command?

A. It performs an instance recovery before opening the database in read/write mode B. It opens the database in read/write mode only if an spfile is used C. It opens the database in read-only mode D. It performs an instance recovery and leaves the database instance in mount state

Correct Answer: C

Question 13

You used the IMMEDIATE option to shutdown your database instance. Consider the steps that will be performed later when you open the database:
1 . SGA is allocated.
2 . Control file is read.
3 . Redo log files are read.
4 . Instance recovery is started.
5 . Background processes are started.
6 . Data files are checked for consistency.
7 . Server parameter file or the initialization parameter file is read.
Which option has the correct order in which these steps occur?

A. 1, 5, 7, 2, 3, 6; step 4 is not required B. 7, 1, 5, 2, 3, 6, 4 C. 1, 2, 3, 5, 6, 4; step 7 is not required D. 7, 1, 5, 2, 3, 6 step 4 is not required

Correct Answer: D

Question 14

In a database, EXAMPLE is the default tablespace and
DEFERRED_SEGMENT_CREATION is FALSE.
Examine these commands executed by SYS:

What will be the outcome and why?

A. It will fail because U1 does not have the CREATE SESSION privilege B. It will fail because U1 has no default tablespace C. It will fail because U1 has no quota on EXAMPLE D. It will fail because U1 does not have the CREATE TABLE privilege E. U1.TAB1 will be created

Correct Answer: D

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

Oracle Database 11g: Administration I - 1Z1-052 Exam Practice Test