♥♥ 2017 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-052 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
1Z0-052 Product Description:
Exam Number/Code: 1Z0-052 vce
Exam name: Oracle Database 11g: Administration I
n questions with full explanations
Certification: Oracle Certification
Last updated on Global synchronizing
Tested of 1Z0-052 exam fees materials and testing engine for Oracle certification for customers, Real Success Guaranteed with Updated 1Z0-052 pdf dumps vce Materials. 100% PASS Oracle Database 11g: Administration I exam Today!
2016 May 1Z0-052 Study Guide Questions:
Q121. You receive complaints from users regarding the high waiting time for their transactions. On investigation, you find that some users are not committing their transactions though they are not performing any activity for a long time. As a result, SQL statements need to wait for rowlevel locks.
Which two actions could you take to prevent this locking problem in the future? (Choose two.)
A. Decrease the IDLE_TIME resource limit in the profile assigned to the blocking users.
B. Use Database Resource Manager to automatically log out sessions that block others and are idle
C. Set the limit in the profile of blocking users to control the number of blocks to be accessed in a session.
D. Decrease the maximum number of interested transaction list (ITL) slots for the segments on which the blocking user performs the transaction.
Q122. 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. The session is terminated after receiving the error and JIM can continue with his transaction.
B. SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
C. The session is rolled back after receiving the error and JIM can continue with his transaction.
D. SCOTT has to reexecute the last command in the transaction after he commits the transaction.
Q123. You are working on a new Oracle Database 11g server, where only the software is installed and no database is created. You plan to create a database on this server using the Database Configuration Assistant (DBCA).
Some of the requirements set for your database creation task are:
1. Configure the database to operate in shared server mode.
2. Disable automatic maintenance tasks such as optimizer statistics collection.
3. Configure a naming method to help the remote user connect to the database instance.
4. Use Automatic Storage Management (ASM) for storing the database files.
5. Configure daily database backup to flash recovery area.
6. Configure Enterprise Manager Database Control to manage the database.
Which of these requirements can be met while creating the database?
A. 4 and 6
B. 2, 3, 4, and 6
C. 1, 2, 4, 5, and 6
D. 1, 2, 3, 4, 5, and 6
Latest 1z0-052 dumps 2012:
Q124. Identify the two situations in which you use the alert log file in your database to check the details. (Choose two.)
A. Running a query on a table returns "ORA-600: Internal Error."
B. Inserting a value in a table returns "ORA-01722: invalid number."
C. Creating a table returns "ORA-00955: name is already used by an existing object."
D. Inserting a value in a table returns "ORA-00001: unique constraint (SYS.PK_TECHP) violated."
E. Inserting a row in a table returns "ORA-00060: deadlock detected while waiting for resource."
Q125. Observe the information in the columns:
Which option has the correct match between the memory areas and their contents?
A. 1-c, 2-b, 3-d, 4-a
B. 1-b, 2-c, 3-d, 4-a
C. 1-a, 2-b, 3-c, 4-d
D. 1-a, 2-b, 3-d, 4-c
Q126. For which database operation would you need the database to be in the MOUNT state?
A. Renaming the control files
B. Re-creating the control files
C. Dropping a user in your database
D. Dropping a tablespace in your database
E. Configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes
Tested 1z0-052 dumps 2012:
Q127. View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has experienced workloads of different capacities:
SQL> SELECT substr(component, 0, 10) COMP, current_size CS, user_specified_size US
What do you infer from this?
A. The database instance is running with manual PGA management.
B. The database instance is running with manual shared memory management.
C. The database instance has the MEMORY_TARGET value set to a nonzero value.
D. All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel query operations have been performed.
Q128. The database instance has the following parameter setting:
OS_AUTHENT_PREFIX = OPS$
OS_ROLES = FALSE
REMOTE_OS_AUTHENT = FALSE
REMOTE_OS_ROLES = FALSE
TIMED_OS_STATISTICS = 0
You have a local operating system user SKD. You create a database user OPS$SKD, and then assign external authentication. The user OPS$SKD has the CREATE SESSION privilege.
What would you achieve by the above process?
A. The database user OPS$SKD will be able to administer the database.
B. The authentication detail for the database user OPS$SKD is recorded in the password file.
C. The local operating system user SKD will be able to access the database instance without specifying the username and password.
D. The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.
Q129. Which statement describes the effect on an index, when the indexed column for the rows is updated in the base table?
A. An update in a leaf row takes place.
B. The index becomes invalid after the update.
C. The leaf block containing the row to be updated is marked as invalid.
D. A row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted.
Q130. You want to configure and schedule offline database backups to run automatically.
Which tool or utility would you use to achieve this?
A. The XML script
B. The PL/SQL script
C. The DBMS_SCHEDULER package
D. Enterprise Manager to schedule the backup
see more Oracle Database 11g: Administration I