1Z1-052 Exam Training Practice Tests (Oracle Database 11g: Administration I)]

Question 1

Which two operations can be performed on an external table? (Choose two.)

A. Delete rows in the table using the DELETE command B. Create an index on the table C. Add a virtual column to the table D. Create a synonym on the table E. Update the table using the UPDATE statement F. Create a view on the table

Correct Answer: D,F

Question 2

In which situation would you use static database registration for a listener?

A. When users need to connect the database instance using the host naming method B. When the database instance that is to be registered with the listener is configured in shared server mode C. When multiple databases are to be registered with the listener D. When DBAs need to connect remotely to start up the database instance

Correct Answer: D

Question 3

A database user SMITH tries to query the V$SESSION view and fails to access it as follows:

Which solution will enable SMITH to query the data in V$SESSION?

A. asking the user SMITH to run the catalog.sql script B. setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE C. granting SELECT privilege to SMITH on V$SESSION D. granting SELECT privilege to SMITH on V_$SESSION E. granting SELECT privilege to SMITH on V$FIXED_TABLES

Correct Answer: D

Question 4

Identify the memory component from which memory may be allocated for:
Session memory for the shared serverBuffers for I/O slavesOracle Database Recovery Manager (RMAN) backup and restore operations

A. Redo Log Buffer B. Database Buffer Cache C. Large Pool D. Program Global Area (PGA)

Correct Answer: C

Question 5

In which of the scenario will the DBA perform recovery? (Choose all that apply.)

A. The alert log file is corrupted B. One of the redo log members is corrupted C. The hard disk on which the data files is stored is corrupted D. A tablespace is accidentally dropped E. A database user terminates the session abnormally

Correct Answer: C,D

Question 6

Which four are true about the tools used to administer Oracle databases? (Choose four.)

A. DBCA can be used to upgrade databases B. SQL *Plus can be used to create databases C. SRVCTL can be used to shut down Oracle instances D. RMAN can be used to start up Oracle instances E. Data Pump can be used to load data from text files F. SQL *Plus can be used to start up Oracle instances

Correct Answer: A,B,D,F

Question 7

The database instance is currently using SPFILE. View the Exhibit and examine the error that you received while running the DB Structure Integrity check. Given below are the steps to recover from the error in random order:
1 . Shut down the instance, if not already done.
2 . Copy one of the remaining control files to a new location.
3 . Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of the control files.
4. Start up the database instance to the NOMOUNT stage.
5. Recover the database to the point of failure of the control file.
6. Open the database.
Identify the correct sequence of steps?
Exhibit:

A. 2, 4, 3, 5, 6; 1 not required B. 1, 2, 4, 3, 5, 6 C. 5, 2, 3, 4; 1 and 6 not required D. 4, 5, 6, 2, 3; 1 not required

Correct Answer: B

Question 8

You have decided to implement the principle of least privilege and separation of duties.
Which two actions must you take? (Choose two.)

A. Assign the DBA role to application schema owners B. Assign different O/S groups to the OSOPER and OSDBA credentials C. Grant access to the Oracle software owner O/S account to all database administrators D. Grant SYSOPER to application schema owners E. Assign the OSOPER and OSDBA groups to the Oracle software owner O/S account

Correct Answer: A,B

Question 9

Note the following structures in your database server:
1 . Extents
2 . OS Blocks
3 . Tablespace
4 . Segments
5 . Oracle Data Block
Which option has the correct arrangement of these structures from the smallest to the largest?

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

Correct Answer: D

Question 10

The database is running in ARCHIVELOG mode. Examine the initialization parameters and their values set to enable archiving on your database server:

Which statement is true regarding the archived redo log files?

A. It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the default location $ORACLE_HOME/dbs. B. It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and location specified by the DB_RECOVERY_FILE_DEST parameter. C. It will be created on the local file system in the location specified LOG_ARCHIVE_DEST_1 parameter. D. It will be created only in the flash recovery area (fast recovery area).

Correct Answer: C

Question 11

User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, or any data definition language (DDL) command:
SQL> SELECT ename FROM emp
2 WHERE job='CLERK' FOR UPDATE OF empno;
SCOTT has opened another session to work with the database instance.
Which three operations would wait when issued in SCOTT's second session? (Choose three.)

A. INSERT INTO emp(empno,ename) VALUES (1289,'Harry'); B. LOCK TABLE emp IN SHARE MODE; C. LOCK TABLE emp IN EXCLUSIVE MODE; D. SELECT ename FROM emp WHERE job='CLERK' FOR UPDATE OF empno; E. UPDATE emp SET sal=sal*1.2 WHERE job='MANAGER'

Correct Answer: B,C,D

Question 12

User A executes the following command to drop a large table in your database:
SQL> DROP TABLE trans;
While the drop table operation is in progress; user B executes the following command on the same table; SQL> DELETE FROM trans WHERE tr_type='SL'; Which statement is true regarding the DELETE command?

A. It fails to delete the records because the records are locked in the SHARE mode B. It fails to delete the records because the table is locked in EXCLUSIVE mode C. It deletes the rows successfully because the table is locked in the SHARE mod D. It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode

Correct Answer: B

Question 13

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 has to reexecute the last command in the transaction after he commits the 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 should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.

Correct Answer: A,D

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