1Z0-053 Questions Answers

QUESTION NO : 12

Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors:ORA-00313:
open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\REDO01.LOG'
You discover that the online redo log file of the current redo group is corrupted.Which statement should you use to resolve this issue?

A. ALTER DATABASE DROP LOGFILE GROUP 1;
B. ALTER DATABASE CLEAR LOGFILE GROUP 1;
C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
D. ALTER DATABASE DROP LOGFILE MEMBER 'D:\REDO01.LOG';

Answer : C

1Z0-053 Questions Answers

QUESTION NO : 11

You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold.Which statement factors in this consideration while increasing the size of the moving window.?

A. The collection level for the AWR should be set to BASIC.
B. The moving window size must be less than Undo Retention.
C. The moving window size should be greater than the Automatic Workload Repository (AWR) retention period.
D. The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period.

Answer : D

Oracle Rolls Out New Unified Communications Suite

The communications service providers now have the ability to quickly provide secure Communications and enterprise level through a series of updated products this week by Oracle.Oracle Communications Unified Communications Suite 7.6 to enable suppliers communication services in order to increase (CSP) market opportunities, treat effectively with customers and increase loyalty.The suite has a number of unified communications and collaboration, including offers click-to-call, video call and share the screen.

Cloud Power

As companies move to all IP networks and cloud-based applications, CSP face increased competition from providers to deliver content over the Internet, regardless of the CSP. To keep pace, CSPs need to offer cloud-based communication and collaboration that are scaled for small, medium and large enterprises and public sector organizations integrated solutions.

The latest version of Oracle Communications Unified Communications Suite allows them to do just that,the company said.In addition, when integrated with Oracle session controller Communications WebRTC, the suite can quickly add CSP integrated real time and near real-features security services time,across the enterprise,Oracle said.

The session handler function connects WebRTC-enabled applications and other unified business communications based on Session Initiation Protocol (SIP) communication systems and contact center ones.The endpoints of the control signals WebRTC, dynamic media provides anchor supports standards-based identity management provides complete functionality session rehydration and offers a transparent gateway Web-to-SIP with reliability and security of enterprise level,according to Oracle.

Communications service providers have to offer attractive services if they want to regain control of communications experience, Bhaskar Gorti said senior vice president and general manager,Oracle Communications.Oracle Communications Unified Communications Suite provides CSP with a cloud-ready solution that allows to extend its brand value and income,especially through the use of existing network resources to provide an integrated set of tools for collaboration and communication for companies any Size.

Contact Management Muscle

Oracle said the suite of communications and Scalable Oracle Secure Unified Communications 7.6 is based on the existing messaging, chat, calendar and contact management functions.One of the characteristics,the product is used to accomplish this integration out of the box with the driver sitting Oracle Communications WebRTC.Driver active session services in real time,such as one-to-one audio and video telephony,conferencing,Session Initiation Protocol (SIP) public switched network (PSTN) phone interoperability,meeting audio transfer the web screen sharing and CSP solving multi-tenant and deployment architecture allowed us to offer differentiated scale services,while helping the utilization of network resources and contacts service CardDAV enabled to optimize provides users with secure access to their contacts,regardless of their location or use them in parallel to the device, new features create a seamless user experience, so the application defects and care related to various types of communication such as email,instant messaging and SMS.

1Z0-053 Questions Answers

QUESTION NO : 10

While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences? (Choose two.)

A. The plan baselines can be evolved over time to produce better performance.
B. The newly generated plans are directly placed into the SQL plan baseline without being verified.
C. The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.
D. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.

Answer: AC

Oracle Gives HR Tool To Track Your Fitness

Oracle has appointed a new tool for human resources departments announced employee wellness and seems to be suggesting that you would be willing to follow their leader how exercise.The tools,a new module for the software and the promises of the company Human Capital Management for the chance that you can keep track of your physical activity,goal setting,and tell you if you upgrade or hitting milestones.

Nothing to worry about there a number of devices and services they do for you. But things interesting when you consider that Oracle says The application advice to employees on behaviors that can increase the life of well-being as well as their links between welfare and work.In other words,human resources it can apply to fire,pies and three beer lunches.Things get even more interesting as Oracle suggests "professional benefits can promote the games and contests for adoption and to increase participation in wellness programs,allowing employees to create benefit providers and joint venture participants provide and take responsibility for personal wellness.

If the "benefits" under consideration are employer-provided gym memberships and the intention is to help benefits professionals to assess if they're a good investment,fair enough.And there are worse ways to generate esprit de corps than internal competitions.

If the benefits are health insurance, and the application can collect data an organisation could use to drive down health insurance premiums and perhaps mean lazy lardies find themselves rated insufficiently committed to wellness during performance reviews then this is very scary stuff indeed.

Oracle says it's currently doing usability testing for the application. Let's hope they choose a workplace with a well-organised workforce for those tests: this one has a high “what could possibly go wrong with that” quotient that may well justify a bit of push-back.

Oracle Database Certifications Are Permanent No More

Oracle is requiring database administrators to upgrade their certifications if the ones they hold are for older versions of its platform.Earning an Oracle certification is a well-respected achievement, the company said on its website. However, as products age and are removed from Oracle standard support maintenance,the technology becomes less relevant, devaluing the associated credential(s).

Data integration is often underestimated and poorly implemented,taking time and resources.Yet it. While that may seem like a reasonable enough conclusions, one question in a FAQ page on the site notes that Oracle has stated that certification is permanent and the policy change seems to go against that.

The change helps maintain the integrity of our certification program and the value of your certification, the site states.The policy reflects certifications for Oracle database versions ranging from 7.3,which dates to the mid-1990s,up to 10g,which was released in 2003.


Certified DBAs in many versions must certify in a new version of the database, either in November 2015 or March 2016 if they want to maintain their credentials in an active state.Oracle recommends that database administrators to update their certification to 11g or later, the site states.

Oracle provides economic benefits re-certifications, given the fees charged to take the tests.However one long-time Oracle DBA, who asked to remain anonymous,praised the decision to Oracle.

It was never a good idea that certifications were permanent, aid the DBA via email.Changes in the characteristics and architecture,for example multi-tenant 12c,must be held null and void previous certifications. Are you going to ruffle some feathers? Yes,probably.Keep it? No.In my opinion certifications be performed with a single release and nothing more.There may be more news to come on this front.The decision on whether to require all certificates to be re certified product is currently being discussed,according to the Oracle FAQ.

Oracle Continues To Bolster Cloud Stack, Starting At Database Level

You return to the inner city of San Francisco during the week, opened recently-minted CTO Oracle Larry Ellison, Oracle’s annual Open World Expo on Sunday. How many analysts expect until this weekend,Oracle cloud puts your business in the first outbreak. 

 Ellison began by describing 2014 as a turning point for Oracle in particular its business in the cloud. He admitted that he and the rest of the Oracle dawned a few years ago that the giant hardware would have to provide the three layers of cloud services. 

We had no choice. We had to SaaS, PaaS and Infrastructure-as-a-Service because of a promise we made 30 years ago to bring together our customers, it was Ellison. In the SaaS layer, Ellison said Oracle has the largest portfolio of industry self-developed this year or in the acquisition of many of which either brought. He boasted that Oracle is the only support high-level competitors who are fighting to various service applications.

Ellison said that Oracle touts the difference is that their cloud services and marketing campaigns and sales support engineers to go out and find new ways of reference databases and all the tools that will have your sales representative. 

In this sense, previously released Oracle Field Services, of 113 products with 14 new SaaS applications in the cloud service together. Another new area for Oracle cloud touches on social campaigns and listening through your-as-a-Service recently data layer, consisting of 49 SaaS and DaaS products at the moment of which 36 are new this year. 

                                                                                     

Ellison went to list dozens and dozens of new cloud applications, which were launched last year, adding that the company has added more than 2,000 new customers in the last year also sold in a short time SaaS HCM core more than any other. We are successful for the first time in competition with the dominant, said.But large changes Ellison unveiled at OpenWorld on Sunday, where they come-Oracle is best known the database level.

Ellison described the development of this release to be the fourth generation of computers, multi-tenant cloud database services. In short framed, Oracle promises to update the Oracle cloud platform that customers can move databases and cloud applications without Oracle single dull click of a button and do not have to change a single line of code. 

Not only does it move, but modernized, and that's a big deal, Ellison said. You can use any application in our database Infrastructure-as-a-move service. the upgrade Oracle Database Platform-as-a-Service, Java-based WebLogic provides functionality identical to the Oracle database on the premises, means customers get their own OS to calculate and VM instances with the capacity and-demand.Automation,is a big plus also. PaaS database includes automated backup, recovery, patching, monitoring and more.

Promising more details during his second start on Tuesday, Ellison renowned customers also have the opportunity to make a difference, back or anywhere else. Lamenting backup devices are not designed for databases Ellison led recovery without data loss Appliance. Acknowledging the awkward name and even screaming I called them before these two guys have been promoted in relation to the new co-CEOs Safra Catz and Mark Hurd, Ellison described briefly, that the name of this automated system explanatory. 

More updates in store for the portfolio including Oracle Exadata platform improvements in memory, including performance enhancements for query acceleration engines at the silicon level for Oracle Database 12c.Putting all this in silicon, Ellison said what these processes 10 times faster. Answering preventive why Oracle is doing these things, back now and not in 2012 when it first unveiled its cloud platform, Ellison shrugged shoulders is hard to do.

Oracle Database 11g Administration II (1Z0-053) Series

Summary:

Prepare for the Oracle Database 11g Administration II exam and learn everything you need to pass it on your first try This study guide series covers some of the more in-depth database administration topics, such as database structure and Oracle Automatic Storage Management,Oracle Recovery Manager (RMAN) Oracle Flashback, disk space and resource management,and database globalization. Practice exams are part of the series,containing questions using the same format as the exam and including in-depth instructional feedback.

Certification:

The test that this series prepares students to take is a part of earning the Oracle Database 11g Administrator Certified Associate certification.

Audience:

This series is for anyone who is preparing for the Oracle Database 11g Administration II (1Z0-053) exam.

Features:

• Audio accompanies each lesson page throughout the course.
• MindNotes provide printable quick-reference sheets and other files to be used as learners apply their skills on the job.
• Instructional audio with graphics highlighting key points.
• Activities allow learners to apply course concepts in an interactive questioning environment.
• Exercises allow learners to practice in the actual application being studied.
• A Course Topics list contains active hyperlinks, permitting quick access to specific topics.
• Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary. In addition, it lets them find other occurrences of the term in the same course.
• Search text enables learners to rapidly search all text within a course to easily retrieve information required.
• Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
• A skill assessment generates a customized learning path based on the results of a pre-test.
• A glossary provides a reference for definitions of unfamiliar terms.
• Bookmarking tracks the learner's progress in a course.

Oracle Database Express

A useful and powerful database that was especially designed to provide a means of developing, deploying and distributing applications:

 Database development and management are activities that are intended only for the professionals, because of their complexity.Nonetheless most experienced specialists will certainly even need the most powerful tools to make their job successfully and easily perform tasks related.One of the packages in this category more efficient supply Oracle Database to create and deploy databases and related applications Express.Geared,this tool facilitates the development and management of such software.

It also goes by the name of Oracle Database XE,this piece of kit comes with extensive support for a variety of network protocols,including IPC, TCP / IP, TCP / IP with SSL, and SDP applications Pipes.Developing name can be done in one of the rooms that is compatible with Oracle Database Express. These are Oracle SQL Developer, Oracle Application Express.NET and Visual Studio, PHP and Java.

An important references relating to the installation of Oracle Database XE is that it requires the user is part of the distribution group.It administrators can configure as a domain user,but only if you are connected to the network before starting the procedure.From the Administration Console Oracle Database Express users will be able to view the status of storage used at present, the database sessions and to parameters.In initialization to create database objects,a user has to be created and configured,a task that, like many others,will have to be performed through the command line. 

In conclusion, it is safe to say that Oracle Database Express (Oracle Database XE) is, in fact, one of the reference tools in its category. Highly specialized and requires a little knowledge in this area of expertise, this software solution can also serve as a training ground for those interested in learning the intricacies of database management, implementation and development.

Oracle Database:Administration II

QUESTION NO: 1

An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace.What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?

A. TEST_TBS is a small file tablespace.
B. TEST_TBS is a bigfile tablespace (BFT).
C. TEST_TBS is the default temporary tablespace.
D. TEST_TBS is a dictionary-managed tablespace.

Answer: D

QUESTION NO: 2

A database is running In ARCHIVBXXMS mode.It has two online redo log groups and each group has one member.A LGWR Input/output (I/O) fells due to permanent media failure that has resulted In the loss of redo log file and the LWGR terminates causing the instance to crash.The steps to recover from the loss of a current redo log group member in the random order are as follow.

1) Restore the corrupted redo log group.
2) Restore from a whole database backup.
3) Perform incomplete recovery.
4) Relocate by renaming the member of the damaged online redo log group to a new location.
5) Open the database with the RESETLOGS option.
6) Restart the database instance.
7) Issue a checkpoint and clear the log.

Identify the option with the correct sequential steps to accomplish the task efficiently.

A. 1, 3, 4, and 5
B. 7, 3, 4. and 5
C. 2, 3, 4, and 5
D. 7, 4, 3. and 5
E. Only 6 is required

Answer: B

Reference: http://docs.oracle.com/cd/B10501_01/server.920/a96572/recoscenarios.htm#11771

QUESTION NO: 3

Which of the following Oracle features utilize the undo tablespace? (Choose all that apply)

A. Flashback Query
B. Flashback Drop
C. Flashback Table
D. Flashback Database
E. Transaction Processing
F. Recycle Bin

Answer: A,C,E

QUESTION NO: 4

The RECYCLEBIN parameter is set to ON for your database.You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the outcome of this action? (Choose two)

A. All the related indexes and views are automatically dropped
B. The flashback drop feature can recover only the table structure
C. Only the related indexes are dropped whereas views are invalidated
D. The flashback drop feature can recover both the table structure and its data

Answer: C,D

QUESTION NO: 5

Which statements are true regarding the concept of problems and incidents in the fault diagnosability infrastructure for Oracle Database 11g? (Choose all that apply.)

A. Only the incident metadata and dumps are stored in the Automatic Diagnostic Repository
(ADR).
B. The problem key is the same as the incident number.
C. The database sends an incident alert to the Oracle Enterprise Manager Database Home page.
D. Every problem has a problem key, which is a text string that describes the problem.
E. The database makes an entry into the alert log file when problems and incidents occur.

Answer: C,D,E

QUESTION NO: 6

During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly.You selected the option to create a database as part of the installation.How would this environment variable setting affect the installation?

A. The installation terminates with an error.
B. The installation proceeds with the default value without warnings and errors.
C. The installation proceeds with the default value but it would not be an OFA-compliant database.
D. The installation proceeds with the default value but a message would be generated in the alert
log file.

Answer: D

QUESTION NO: 7

RMAN provides more granular catalog security through which feature?

A. Virtual private database
B. Virtual private catalog
C. RMAN virtual database
D. RMAN secure catalog
E. Oracle Database Vault

Answer: B

QUESTION NO: 8

How is block-change tracking enabled?

A. With alter database enable block change tracking
B. With alter system enable block change tracking
C. With an init.ora parameter change
D. With an spfile parameter change

Answer: A

QUESTION NO: 9

At the request of a user, you issue the following command to restore a dropped table:flashback table “BIN$F2JFfMq8Q5unbC0ceE9eJg==$0” to before drop;Later, the user notifies you that the data in the table seems to be very old and out of date.What might be the problem?

A. Because a proper range of SCNs was not specified, the wrong data was restored.
B. A proper range of timestamps was not specified, so the wrong data was restored.
C. A previous Flashback Drop operation had been performed, resulting in multiple versions of the table being stored in the Recycle Bin.
D. Either option A or B could be correct. Not enough information was provided to determine which.
E. None of the above.

Answer: C