we provide Refined Oracle oracle database 11g administration i 1z0 052 free practice exam which are the best for clearing 1z0 052 dumps test, and to get certified by Oracle Oracle Database 11g: Administration I. The 1z0 052 pdf Questions & Answers covers all the knowledge points of the real 1z0 052 dumps exam. Crack your Oracle 1z0 052 dumps Exam with latest dumps, guaranteed!


2026 New 1Z0-052 Exam Dumps with PDF and VCE Free: https://www.2passeasy.com/dumps/1Z0-052/

Q1. In a new installation of Oracle Database 11g, you perform these activities:

1. Organize software and data on different subdirectories to avoid poor performance.

2. Use consistent naming conventions for database files.

3. Separate administrative information pertaining to the database in different directories.

Which option corresponds to the type of activities you performed?

A. Oracle Managed Files

B. Oracle Grid Architecture

C. Optimal Flexible Architecture

D. Oracle database architecture

E. Automatic Storage Management

Answer: C

Q2. View the Exhibits and examine lock waits. Users HR and SH complain that their transactions on one of the application tables, EMP, are waiting for response.

Which action would you take to release the lock and enable users HR and SH to continue with their transactions?

07 (exhibit):

A. Kill the session of the user SCOTT with session ID118.

B. Issue manual checkpoint using the ALTER SYSTEM command.

C. Modify the profile used by user SCOTT to reduce the CONNECT_TIME limit.

D. Flush the Shared Pool to remove the SQL statement causing "wait" in memory.

Answer: A

Q3. Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener by using the command: LSNRCTL> STOP

What happens to the sessions that are presently connected to the database instance?

A. The sessions are able to perform only queries

B. The sessions are not affected and continue to function normally

C. The sessions are terminated and the active transactions are rolled back

D. The sessions are not allowed to perform any operations till the listener is started

Answer: B

Q4. Automatic Shared Memory Management is disabled for your database instance. You realize that there are cases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation of performance.

What would be your next step to improve performance?

A. Run the SQL Access Advisor

B. Run the memory Advisor for the SGA

C. Run the memory Advisor for the PGA

D. Run the memory advisor for the shared pool

E. Run the memory advisor for the buffer cache

Answer: D

Q5. Identify three situations in which you would NOT be able to drop a tablespace. (Choose three.)

A. when the tablespace is online

B. when the tablespace has segments with data in it

C. when the tablespace is a default permanent tablespace for the database

D. when the tablespace contains a table that is currently being used by transactions

E. when the tablespace contains undo data that is needed to rollback an uncommitted transaction

Answer: CDE

Q6. 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. Add the user, SYSTEM, to the schemas option.

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

C. Change the dumpfile option to schema.dat@devdb.us.oracle.com.

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

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

Answer: E

Q7. 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.

Answer: C

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

A. DDL statements can be audited.

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

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

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

Answer: AB

Q9. Which is the correct description of a pinned buffer in the database buffer cache?

A. The buffer is currently being accessed

B. The buffer is empty and has not been used

C. The contents of the buffer have changed and must be flushed to the disk by the DBWn process

D. The buffer is a candidate for immediate aging out and its contents are synchronized with the block contents on the disk

Answer: A

Q10. 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. Lock statistics for the tables.

B. Change STALE_PERCENT to zero for the tables.

C. Set the TIMED_STATISTICS parameter to TRUE.

D. Set the STATISTICS_LEVEL parameter to BASIC.

E. Set the OPTIMIZER_USE_PENDING parameter statistics to TRUE.

Answer: A