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

Question 1

Examine the following output:

Which two statements about the above index are true? (Choose two.)

A. The index cannot be rebuilt, and has to be re-created.

B. It is not used while the index is being rebuilt.

C. The index is automatically rebuilt when used the next time.

D. It is ignored by the query optimizer.

Correct Answer: B,D

Question 2

Examine the following steps performed on a database instance:
1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION
2 . The SKD user creates a table
3 . The SKD user grants the CREATE TABLE system privilege to the HR user
4 . The HR user creates a table
5 . The DBA revokes the CREATE TABLE system privilege from SKD
Which statement is true after step 5 is performed?

A. The tables created by SKD and HR remain, but both cannot create new tables

B. The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users

C. The table created by SKD is not accessible and SKD cannot create new tables

D. The table created by HR remains and HR still has the CREATE TABLE system privilege

Correct Answer: D

Question 3

Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The initialization parameters for the components that are managed by ASMM are not set. After observing the effects of ASMM, you executed the following command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;
Which statement is true in this scenario?

A. The minimum memory size allocated for a server process in the database buffer cache in dedicated mode is set to 100 MB.

B. The minimum memory size for the database buffer cache is set to 100 MB.

C. The maximum memory size that can be obtained by the database buffer cache during ASMM is set to 100 MB.

D. The maximum memory size from the database buffer cache that can be released for dynamic distribution during ASMM is set to 100 MB.

Correct Answer: B

Question 4

You have statistics collected for some selected tables. Your requirement is that the statistics for the tables and all dependent indexes must not be overwritten by further statistics collection until a certain point of time. How would you achieve this?

A. Set the STATISTICS_LEVEL parameter to BASIC.

B. Change STALE_PERCENT to zero for the tables.

C. Set the OPTIMIZER_USE_PENDING parameter statistics to TRUE.

D. Set the TIMED_STATISTICS parameter to TRUE.

E. Lock statistics for the tables.

Correct Answer: E

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

Question 5

Which two statements are true about standard database auditing? (Choose two.)

A. Only one audit record is ever created for a session per audited statement even though it is executed more than once.

B. Statements that refer to standalone procedure can be audited.

C. DDL statements can be audited.

D. Operations by the users logged on as SYSDBA cannot be audited.

Correct Answer: B,C

Question 6

Note the following points describing various utilities in Oracle Database 11g:
1. It enables the high-speed transfer of data from one database to another
2. It provides a complete solution for the backup, restoration and recovery needs of the entire database
3 . It enables the loading of data from an external file into table of an Oracle Database
4 . It provides a tape backup management for the Oracle ecosystem
Which point describes Oracle Secure Backup?

A. 2

B. 1,2,3, and 4

C. 1

D. 3

E. 4

F. 1,2 and 4

Correct Answer: E

Question 7

While observing the index statistics, you find that an index is highly fragmented, thereby resulting in poor database performance. Which option would you use to reduce fragmentation without affecting the users who are currently using the index?

A. Change the block space utilization parameters using the ALTER INDEX command

B. Validate the index structure using the ANALYZE .... INDEX command

C. Deallocate the unused space in the index using the ALTER INDEX ... DEALLOCATE UNUSED command

D. Rebuild the index using the ALTER INDEX ..... REBUILD ONLINE command

Correct Answer: D

Question 8

Examine the following statement that is used to modify the primary key constraint on the SALES table:
SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE;
Which three statements are true regarding the above command? (Choose three.)

A. It allows the loading of data into the table using SQL *Loader.

B. It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

C. The constraint remains valid.

D. New data conforms to the constraint, but existing data is not checked.

E. The index on the constraint is dropped.

Correct Answer: A,C,E

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

Question 9

SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;
What is the effect of this command?

A. One audit record is created for every session of any other user in which a table owned by SCOTT is dropped successfully

B. One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned by SCOTT

C. One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users

D. One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session

E. One audit record is created for every successful DROP TABLE command executed in the session of SCOTT

Correct Answer: D

Question 10

Your database is using Automatic Memory Management.
Which two SGA components must be managed manually? (Choose two)

A. large pool

B. keep buffer pool

C. shared pool

D. default buffer cache

E. redo log buffer

Correct Answer: B,E

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

Question 11

The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the procedure to many database users:
CREATE OR REPLACE PROCEDURE create_dept ( v_deptno NUMBER, v_dname
VARCHAR2, v_mgr NUMBER, v_loc NUMBER)
BEGIN
INSERT INTO hr.departments VALUES (v_deptno, v_dname, v_mgr, v_loc);
END;
The users having permission to execute the procedure are able to insert records into the DEPARTMENTS table even though they do not have the INSERT privilege on the table.
You want only those users who have privileges on the DEPARTMENTS table to be able to execute the procedure successfully.
What would you suggest to the PL/SQL developers to achieve this?

A. Create the procedure with definer's right.

B. Create the procedure as part of a PL/SQL package and grant the EXECUTE privilege on the package to selected users.

C. Create the procedure with invoker's right.

D. Grant the EXECUTE privilege with GRANT OPTION on the procedure to selected users.

Correct Answer: C

Question 12

You executed the following commands to find the location of the alert log file:

Where is the alert log file stored? (Choose all that apply.)

A. in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in text format

B. in the BACKGROUND_DUMP_DEST location; in XML format

C. in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in both text and XML format

D. in the BACKGROUND_DUMP_DEST location; in text format

E. in the BACKGROUND_DUMP_DEST location; in both text and XML format

F. in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in XML format

Correct Answer: D,F

Question 13

database, DEVDB, to the production database, PRODDB. A database link
devdb.us.oracle.com is created between PRODDB and DEVDB. You execute the following command on the PRODDB database server:
$ impdp system/manager directory = DB_DATA
dumpfile = schemas.dat
schemas = hr
flashback_time = "TO_TIMESTAMP('25-08-2007 14:35:00', 'DD-MM-YYYY HH24:MI:SS')" The command fails displaying the following error:
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA-
27037: unable to obtain file status
What would you do to overcome the error?

A. Replace the schemas option with the network_link = devdb.us.oracle.com

B. Add the user, SYSTEM, to the schemas option.

C. Change the dumpfile option to [email protected].

D. Replace the dumpfile option with the network_link = devdb.us.oracle.com

E. Add the network_link = devdb.us.oracle.com option.

Correct Answer: D

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

Question 14

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

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

B. You can rename tables during an import operation.

C. You cannot export data from a remote database.

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

Correct Answer: A,B

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

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

Latest Update

Useful Links

Contact Us