Why Oracle is a Distant Leader in the Relational Database Market

The company is the leading player in the relational database market, with a revenue share of 48.3%. Oracle also claims that it holds larger revenue share than its four closest competitors combined. IBM (IBM), Microsoft (MSFT), SAP (SAP), and Teradata (TDC) are the four close competitors Oracle mentioned. This shows Oracle’s dominance in the relational database market. In the prior article of this series, we discussed how the cloud services market is undergoing rapid growth, and how Oracle is considered a laggard in this market. However, if we discuss the cloud database market specifically, we should consider that Oracle introduced its Database 12c version last year (the “c” in “12c” stands for “cloud”).

According to Oracle, Oracle Database 12c introduces a new multitenant architecture that simplifies the process of consolidating databases onto the cloud; enabling customers to manage many databases as one without changing their applications.

Database 12c is finding early adopters

During the company’s conference call to announce earnings, Larry Ellison, Oracle’s chief executive officer, mentioned how competitors such as (CRM) are showing interest in integrating their applications with Database 12c.

On the database Ellison explained there are two key aspects of 12c. One that came out with the initial release which is the multi-tenant feature, that’s why it’s called 12c for the cloud. It literally takes any application that you got, any Oracle application you’ve got and makes it a multi-tenant application. Even companies like  where it was a supplier and — with to  and a competitor.

Ellison further stated, I just recently got a note from Mark Benioff who is excited about bringing in Exadata and 12c and making in at the basis of salesforce.com’s cloud computing infrastructure that they put our application on. So we are seeing adopters with very, very high standards in terms of having to supply millions of users, reliably and cost effectively in the cloud. Talk about moving their entire business to 12c and Exadata. That’s just the tip of the iceberg of these hyperscale companies.

On adoption of the 12c, Ellison said, “We think virtually all of our customers are on their way to moving to 12c. Now some — they are the early adopters and then there is the rest of the guys who come down the road a bit later. But we think it’s very attractive to our conventional customers and to hyperscale customers like Salesforce and others.”

Oracle SQL Certification: 1Z0-051

The first of the Oracle certification exams to go into production is: Oracle Database : SQL Fundamentals. Oracle University has made this test in production almost simultaneously with the removal of the much older test : Introduction to Oracle9i SQL . However, version 11g SQL Fundamentals exam, 1z0 – 051 , is still available. Having two equivalent tests in production leads to great confusion among the candidates . In this article I discuss the two tests , what is different between them, and how to choose one over the other .

Or will satisfy the requirement for SQL “Oracle Database 11g Administrator Certified Associate ” or tracks “Oracle PL / SQL Developer Certified Associate ” . The requirement also can be satisfied by passing the SQL : Oracle Database SQL Expert . However, an examination is much more difficult than 1Z0 – 051 is an option that should only be considered if has worked extensively with Oracle SQL . This article focuses on the SQL Fundamentals exam.

12c and 11g SQL Fundamentals I exams are almost identical in their essence and satisfied the requirements for Oracle certifications . Oracle does not require the use of SQL Fundamentals 12c 12c in finding the track or track DBA 11g DBA exam in that version . Any review of Oracle SQL (including retired ) can be used for any Oracle certification path that has a requirement for SQL . For example , SQL test I took it for more than a decade was Introduction to Oracle : SQL and PL / SQL . This test has been retired for years, but could still be applied to the track 12c

While the content of the two tests are very similar, there are differences. Both 1Z0-051 contains forty-one subjects. Of these, thirty-six are common to both examinations. This means that the tests are around 88% in the number of community discussion. The last section of the exam 11g (creation of other schema objects), withdrew from the trial version 12c. The topics covered in that section are:

• Create simple and complex views
• Retrieve data from views
• Create, maintain, and use sequences
• Create and maintain indexes
• Create private and public synonyms

For the 1Z0-051 exam, Oracle University added a new ‘Introduction’ section with the following four topics:

• Describe the features of Oracle Database 12c
• Describe the salient features of Oracle Cloud 12c
• Explain the theoretical and physical aspects of a relational database
• Describe Oracle server’s implementation of RDBMS and object relational database management system (ORDBMS)
• They also added one more topic to the “Managing Tables using DML statements” section:
• Truncate data

Oracle University ‘s decision to put TRUNCATE (which is a DDL operation ) in a section specifically DML . This is not something that makes sense in a test designed for people who are new to SQL . I’m sure OU would be heartbroken to know my disapproval .

1Z0 -051 has more than nine questions 1Z0 – 051 (75 vs 66 ) and a passing score slightly higher ( 65 % vs 60%). This does not necessarily mean that the test is more difficult to overcome , however. The topics that have been added are the questions you might have are simpler than the issues that have been deleted . OU has a certain target candidates who want to pass all tests on the first attempt percentage. If they raised the passing score is because they felt it had updated test questions easier.

I must say that the choice of one test over the other is really a toss . The 11g exam is not particularly dated and all issues are still relevant. There may be some long-term benefit in view of the examination 12c disk instead of 11g , simply because it will be around 12C after retiring 11g. However, 11g is currently the standard database used in production environments.

Very few companies have moved to 12c yet. Furthermore, none of my employers have asked ( or care ) about the specific tests I took to earn my certifications Oracle. Select the test that makes more sense for you and you can be sure that you are not making a mistake. Whoever you choose good luck for the test.

Matthew is an experienced DBA and developer . Has Oracle DBA certifications for versions 7 , 8i , 9i , 10g and 11g , Oracle Expert certifications for SQL , SQL Tuning and Application Express, is a developer and advanced Oracle PL / SQL Certified Professional.

 

1z0-051 Study Material

QUESTION NO: 1

You are granted the CREATE VIEW privilege. What does this allow you to do?

A. Create a table view.
B. Create a view in any schema.
C. Create a view in your schema.
D. Create a sequence view in any schema.
E. Create a view that is accessible by everyone.
F. Create a view only of it is based on tables that you created.

Answer: C

QUESTION NO: 2

User Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES,DEPARTMENTS, and LOCATIONS tables. She has the privilege to create a public synonym, and would like to create a synonym for this view that can be used by all users of the database.Which SQL statement can Mary use to accomplish that task?

A. CREATE PUBLIC SYNONYM EDL_VU
ON emp_dept_loc_vu;
B. CREATE PUBLIC SYNONYM EDL:VU
FOR mary (emp_dept_loc_vu);
C. CREATE PUBLIC SYNONYM EDL_VU
FOR emp_dept_loc_vu;
D. CREATE SYNONYM EDL_VU
ON emp_dept_loc_vu
FOR EACH USER;
E. CREATE SYNONYM EDL_VU
FOR EACH USER
ON emp_dept_loc_vu;
F. CREATE PUBLIC SYNONYM EDL_VU
ON emp_dept_loc_vu
FOR ALL USERS;

Answer: C

QUESTION NO: 3

Which four are attributes of single row functions? (Choose four.)

A. cannot be nested
B. manipulate data items
C. act on each row returned
D. return one result per row
E. accept only one argument and return only one value
F. accept arguments which can be a column or an expression

Answer: B,C,D,F

QUESTION NO: 4

View the Exhibit and examine the structure of the PROMOTIONS table.
You need to generate a report of all promos from the PROMOTIONS table based on the following conditions:

1. The promo name should not begin with ‘T’ or ‘N’.
2. The promo should cost more than $20000.
3. The promo should have ended after 1st January 2001.
Which WHERE clause would give the required result?
A.WHERE promo_name NOT LIKE ‘T%’ OR promo_name NOT LIKE ‘N%’ AND promo_cost >
20000 AND promo_end_date > ‘1-JAN-01’
B.WHERE (promo_name NOT LIKE ‘T%’ AND promo_name NOT LIKE ‘N%’)OR promo_cost >
20000 OR promo_end_date > ‘1-JAN-01’
C.WHERE promo_name NOT LIKE ‘T%’ AND promo_name NOT LIKE ‘N%’ AND promo_cost >
20000 AND promo_end_date > ‘1-JAN-01’
D.WHERE (promo_name NOT LIKE ‘%T%’ OR promo_name NOT LIKE ‘%N%’) AND(promo_cost >
20000 AND promo_end_date > ‘1-JAN-01’)

Answer: C

QUESTION NO: 5

Which two statements are true regarding indexes? (Choose two.)

A. They can be created on tables and clusters.
B. They can be created on tables and simple views.
C. You can create only one index by using the same columns.
D. You can create more than one index by using the same columns if you specify distinctly different combinations of the columns.

Answer: A,D