Prior to the adoption of sql

Assignment Help PL-SQL Programming

Reference no: EM13705139

Question: Prior to the adoption of SQL as a standard by the American National Standards Institute (ANSI), each database management system (DBMS) had its own unique command language and syntax.

SQL was adopted as an ANSI standard in 1986. The International Standards Organization (ISO) adopted it in 1987. This standard enables database portability.

Most commercial database vendors support the ANSI standard. Thus, most of these vendors also extend the standard with the addition of proprietary features.

The Oracle version of SQL has differences from the ANSI standard version.

For case, Oracle does not support either the full OUTER JOIN or the NATURAL JOIN of ANSI SQL.

When you have a choice, the vendor specific proprietary solution may offer better performance or convenience. On the other hand, the proprietary feature also limits or eliminates portability.

Think about the weaknesses and strengths of both the standard ANSI and proprietary Oracle approach to SQL. In particular, think about the different ways Oracle and ANSI support joins.

With these thoughts in mind:

Suppose a situation where you would use a join to retrieve data from two tables in an Oracle database, such as the stock_count for an oil filter from the product table and the vendor for that oil filter from the vendor table. Would you prefer to use the proprietary Oracle SQL or ANSI standard SQL?

What factors influenced your decision?

Explain a situation where you would consider using the other option.

Solve these questions in details and provide examples to support your rationale.

Reference no: EM13705139

Questions Cloud

Implement a generic class set : Implement a generic class Set that maintains a set of items of generic type T using the class LinkedList in the Java API. Your Set class must provide the subsequent functionality:

Explain sensitivity of a spectrophotometer allows detection : Problem- The sensitivity of a spectrophotometer allows detection of 1 percent of one colored form of an indicator (for example HIn) in the presence of 99 percent of the other colored form (In-).

Write a test program that obtains from the user : Write a test program that obtains from the user the items to store in two sets A and B, and displays the union A u B, the inter- section A n B, and the dierence A \ B. The data type of the items is your choice. ( you can only store objects.)

Describe a polynomial-time algorithm : Describe a polynomial-time algorithm that solves the following decision problem:

Prior to the adoption of sql : What factors influenced your decision - Explain a situation where you would consider using the other option.

What accounts for the larger disorder in the kcl crystals : Problem- Crystalline KCl has S*=83J/mol K and crystalline CaO has S*= 55 J.mol k. What accounts for the larger disorder in the KCl crystals. a) Repulsive forces are larger for CaO

Calculate the molarity of a sodium hydroxide solution : Problem- Calculate the molarity of a sodium hydroxide solution if a .5356g sample of KHP was dissolved in 50 ml of water and titrated with 20.78 ml sodium hydroxide to a phenolphthalein endpoint.

What is the ph at the equivalence point of the titration : Problem- You are titrating 0.1 M acetic acid with 0.1 M potassium hydroxide. What is the pH at the equivalence point of the titration. Kb (CH3COO-) = 5.6 x 10^-10

Create wheel 360 degree : You have to create wheel, 360 degree. That is numbered 0-36. it is supposed to be spun, and randomly lands on one of the numbers.

User Account

All Pages