|Exam Name||:||Oracle Database 11g: Administration I|
|Questions and Answers||:||205 Q & A|
|Updated On||:||November 20, 2017|
|PDF Download Mirror||:||[1Z0-052 Download Mirror]|
|Get Full Version||:||Pass4sure 1Z0-052 Full Version|
D. Functionbased index
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?
The command fails because SCOTT still has privileges.
The command succeeds and privileges are revoked from JIM.
The command fails because HR cannot revoke the privileges from JIM.
The command succeeds and only HR has the privilege to perform the SELECT, INSERT, and UPDATE operations on the EMP table.
Which statement describes the effect on an index, when the indexed column for the rows is updated in the base table?
An update in a leaf row takes place.
The index becomes invalid after the update.
The leaf block containing the row to be updated is marked as invalid.
A row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted.
You are managing an Oracle Database 11g database running in ARCHIVELOG mode. The Flash Recovery Area is specified as the destination for the archived redo log files. You notice this warning in the alert log file: ORA19815: WARNING:
db_recovery_file_dest_size of 3221225472 bytes is 100.00% used, and has 0 remaining bytes available. What would you do to reclaim the used space in the Flash Recovery Area? (Choose two.)
Back up the Flash Recovery Area.
Decrease the retention time for the database backup and flashback log files.
Manually delete all the archived log files from the Flash Recovery Area by using operating system (OS) commands.
Manually delete all the expired backup sets from the Flash Recovery Area by using operating system (OS) commands.
View the Exhibit and examine the setting for a table.
Which statement is true about the PCTFREE setting for the table?
It sets the minimum percentage of a data block to be reserved to contain chained rows from other blocks.
It sets the minimum percentage of a data block to be reserved as free space before the server prevents inserts into the block.
It sets the minimum percentage of a data block to be reserved to contain the bitmap used to maintain the free block information.
It sets the minimum percentage of a block that can be used for row data plus overhead before new rows are added to the block.
Which tablespaces are mandatory in an Oracle database for it to be operational? (Choose all that apply.)
You executed the following commands in an RMAN session for your database instance that has failures: RMAN> LIST FAILURE; After some time, you executed the following command in the same session: RMAN> ADVISE FAILURE; But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?
It produces a warning for new failures before advising for CRITICAL and HIGH failures.
It ignores new failures and considers the failures listed in the last LIST FAILURE command only.
It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored.
It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.
View the Exhibit and examine the initialization parameter settings.
Which three initialization parameters are to be set manually as they are not automatically tuned? (Choose three.)
In your database, the current status of a PL/SQL procedure has become INVALID. Which action would fix the problem and make the PL/SQL procedure usable?
Recompile the PL/SQL procedure.
Modify the procedure to run with a definer's right.
Modify the procedure to run with an invoker's right.
Grant the EXECUTE privilege on the PL/SQL procedure to PUBLIC.
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?
It will be created on the local file system.
It will be created only in the Flash Recovery Area.
It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the default location $ORACLE_HOME/dbs.
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.
In which situations does the Oracle Data Pump use external tables and not the direct path load while exporting a table? (Choose all that apply.)
if a table is not in a cluster
if a table has an active trigger
if a table has an encrypted column
if a table has a column of data type LONG defined on it
if a table has a referential integrity constraint defined on it
Your database instance is currently configured to support 1,500 connections. The Web application that uses the database allows a large number of users to work with the database simultaneously. Some users of the Web application do not interact with the server all the time. You want to increase the scalability by configuring the database instance to handle more connections. As a DBA, which configuration would you set to support more than 1,500 connections at a time?
You would configure more listeners for the database.
You would configure the database in shared server mode to use the connection pooling feature.
You would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that assigns more session memory to users.
You would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the users to accommodate more session information.
Which two statements describe good practices for an application developer to reduce locking conflicts in Oracle database? (Choose two.)
Avoid coding unnecessary longrunning transactions.
Allow the database to handle locks in default locking mode.
Always explicitly code the locks as per the requirement of the application.
Allow escalation of row locks to block locks if too many row locks cause problem.
These are points that describe the contents of different memory components:
1: Descriptive information or metadata about schema objects that are queried by using SQL statements
2: The runtime area for data manipulation language (DML) or data definition language (DDL) statements
3: Results of SQL queries and PL/SQL functions
4: Executable forms of SQL cursors, PL/SQL programs, and Java classes
5: The information necessary to reconstruct changes made to the database by a transaction Which of these will be stored in the Shared Pool if the necessary configurations are done?
1 and 2
2 and 5
1,3, and 4
3,4 and 5
1,2,3 and 4
View the Exhibit and note the files available in the $ORACLE_HOME/dbs folder. The ASM instance is already running. You used the following steps to start the database instance and open the database:
Which file is used to start the instance in this case? Exhibit:
Examine the commands executed in the following sequence:
Which statement is true about the above commands?
The commands execute successfully.
Command 6 produces an error because of circular role grant.
Command 5 produces an error because a role cannot be granted to another role.
Command 3 produces an error because the MGRROLE role already contains system privileges. The table created by HR remains and HR still has the CREATE TABLE system privilege.
The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
Get Unlimited Access to all ExamCollection's PREMIUM files!
Enter Your Email Address to Receive Your 30% Off Discount Code
Please enter a correct email to Get your Discount Code
Download Free Demo of VCEExam Simulator
Experience Avanset VCE Exam Simulator for yourself.
Simply submit your e-mail address below to get started with our interactive software demo of your free trial.
Database books are hard to write, and very rarely is it written in a way that is warm and easy to understand. The many concepts discussed in technical books require the student to concentrate on many obtuse factors at one time.
The following books included in this list of the top 10 Oracle certification books for Database Administrators present material in a clear and concise fashion that is enjoyable to read, including plenty of great examples.
Whether you are brushing up on new features in newer versions or are preparing for the certification exam, make the best investment you have made in a long time by purchasing any of the following books.
Top 10 Oracle Certification Books for Database Administrators
1.OCAOCP Oracle Database 11g All-in-One Exam Guide with CD-ROM: Exams 1Z0-051, ">1Z0-052, 1Z0-053 (Oracle Press) by John Watson, Roopesh Ramklass and Bob Bryla
This Oracle certification book is enormously helpful for your prep time and for getting familiar with Oracle. It includes a wide range of highly relevant practice questions that ensure your knowledge is harnessed in the best way for the exam. It gradually builds on the material that is introduced in a clear and detailed manner.
2. OCA Oracle Database 11g SQL Fundamentals I Exam Guide: Exam 1Z0-051 (Oracle Press) by John Watson and Roopesh Ramklass
Ideas contained in this Oracle certification book are well-explained, and it includes plenty of pictures as well. This book even deeply discusses simple SQL statements in a manner that is extremely user-friendly. Advanced users are able brush-up and identify gaps in their knowledge.
3. OCA Oracle Database SQL Expert Exam Guide: Exam 1Z0-047 (Oracle Press) by Steve O’Hearn
Recommended for You
Webcast, November 30th: Content was King in 2016, Will it Reign in 2017?
If you want to take the SQL Expert exam, this Oracle certification book offers you all the answers you require. It is well-written, and it covers all of the syllabus included in the exam. Although it is long, it is easy to read and filled with information. A thoroughly-structured review book, it is clear and succinct, covering all the exam topics. There are also helpful questions at the end of each chapter.
4. OCA Oracle Database 11g Administration I Exam Guide (Exam ">1Z0-052) by John Watson
This comes highly-recommended if you would like to achieve certification on a self-study pace. This is an extremely comprehensive Oracle certification book, both from the standpoint of the ">1Z0-052 certification and in terms of the knowledge that an Oracle DBA requires. It covers all the topics, with clear explanations, as well as important tips and points for exams.
5. OCA: Oracle Database 11g Administrator Certified Associate Study Guide: (Exams1Z0-051 and ">1Z0-052) by Biju Thomas
Simple and well organized, this Oracle certification book has everything including examples. A great companion for beginners as well as seasoned DBAs, it is a must-read for anyone looking to learn and get an Oracle certification. The book makes use of sample databases, including Oracle software.
6. OCA Oracle Database 11g: SQL Fundamentals I: A Real World Certification Guide (1ZO-051) by Steve Ries
This book is an awesome general reference for non-Oracle 11g database administrators as it explains how databases function in a simple, comprehensive fashion. It only goes into 11g-specific areas only when needed. Any Oracle 11g novice needs to have this Oracle certification book in their hands at all times. It is an in-depth and excellently written training guide geared towards passing the Oracle 1Z0-051 exam.
7. Solaris 10 System Administration Exam Prep: CX-310-200, Part I (2nd Edition) (Pt. 1) by Bill Calkins
This text delves into the depth needed to pass the exam. The test requires more than just knowledge of commands, it also needs you to know what switches are required to achieve the proper outcome. The wealth of knowledge gained from reading this book not only allows you to pass the exam, but it also increases your skills on areas that you do not normally use as a system administrator.
8. OCP Oracle Database 11g New Features for Administrators Exam Guide (Exam 1Z0-050) (Oracle Press) by Sam Alapati
This kind of guide is an important milestone in helping you focus on both the examination, as well as in discovering new features to help those who would like to upgrade their certification. Well-organized, this Oracle certification job does an excellent job in covering all the needed subject matter for the exam, and its content is structured around what is on the test.
9. Oracle Certified Professional Financial Applications Consultant Exam Guide (BookCD-ROM package) by Christopher Allen and Vivian Chow
This is the most complete treatment of Financials you will ever see. It is a top-notch Oracle certification book all the way around, and it will get you through all five (5) exams. This book really aids in clarifying how Financials work. Complete and to the point, it covers all the necessary points, with no time wasted.
10. OCP: Oracle 10g Certification Kit (1Z0-042 and 1Z0-043) by Tim Buterbaugh, Chip Dawes, Bob Bryla and Doug Stuns
Overall, this Oracle certification book does a great job of introducing you to the aspects, features, and functionality of Oracle 10gR1. Its topics are organized in logical order, well-written, clear and easy to read, with plenty of sample tests, exercises, practical scenarios, and tips from DBA experts that are accurate and helpful in getting you ready for the real thing.
Any of the following books will help you outperform at the workplace whenever you need it most. A great investment, you may soon find yourself on track for a promotion. Which book have you found most helpful? Leave a comment and let me know.
Article by ArticleForge
Select type of offense:
Offensive: Sexually explicit or offensive language
Spam: Advertisements or commercial links
Disruptive posting: Flaming or offending other users
Illegal activities: Promote cracked software, or other illegal content
Comments: (optional) Submit cancelArticle by ArticleForge
Page 4 of 6
You must retain the committed undo data in the undo tablespace for 10 minutes without hampering the uncommitted transactions in the database. Which action can you take to achieve this objective?
A. Set the UNDO_RETENTION parameter to 600 and do not guarantee the undo retention. B. Set the UNDO_RETENTION parameter to 10 and do not guarantee the undo retention. C. Set the UNDO_RETENTION parameter to 600 and guarantee the undo retention. D. Set the UNDO_RETENTION parameter to 10 and guarantee the undo retention.
Exam ">1Z0-052: Oracle Database 11g Administrator is primarily for Oracle Database administrators. The exam covers topics such as, Oracle Database Architecture, Database Backups, Oracle Network Environment, Intelligent Infrastructure, User Security, etc. The total duration of the Exam ">1Z0-052 is arround 90 Mins for 70 questions and one have to score more than 60% to pass the test.
Prior taking Exam ">1Z0-052, ohe has to pass the Exam 1Z0-051 or must have sound knowledge about the Fundamentals of Oracle 11g. One can also take "Oracle Database 11g Administrator Certified Associate" exam after passing the Exam ">1Z0-052.
For more and detailed information on Exam ">1Z0-052 please visit Official Exam ">1Z0-052 Page