Reference no: EM13191062
As a DBA it is vital that you understand in detail how a query is processed by the DBMS. Since Team Retail is using Oracle, you need to demonstrate your knowledge of Oracle query processing. You recognize that all relational DBMS must perform the same general steps when processing a query even though the steps may have different names and the details may be somewhat different.
1. Consider the processing of a (read-only) query in Oracle. The query will proceed through multiple steps to produce the output. Assume the query contains (or could contain) select, from, where, and order by clauses. Assume also the query may require the join of two tables. Create a flowchart or structured English "algorithm" to describe how a query is processed.
a. A description at the appropriate level of detail will include how and when syntax and semantic errors are identified through the return of a result set.
b. Include the processing that occurs when a syntax or semantic error occurs.
c. Include other errors as appropriate. Hint: remember the user has to be authorized.
d. Do not include details of the optimizer processing; identifying when the optimizer step occurs is sufficient.
e. Acceptable diagram formats include a flowchart, a UML activity diagram, or similar diagram style. The "algorithm" would be a numbered list of steps similar to those used in our assignment descriptions or a checklist.
f. This must be your own diagram or list of steps. Do not copy an existing diagram or algorithm. Such diagrams are usually too detailed or not detailed enough to answer this question.
2. Use the Global Engineering query from your Discussion 3 contribution that has two syntax errors. Describe in detail how this query is processed by Oracle. I recommend that you execute the query and save the results in a spool file; then refer to those results in your analysis. Consider the following in your answer.
a. What error does Oracle find first?
b. When does Oracle stop processing the query?
c. What error message does Oracle return?
d. Is that error message accurate?
e. Does Oracle identify both errors? Why or why not?
3. Use the Global Engineering query from your Discussion 3 contribution that has two semantic errors. Describe in detail how this query is processed by Oracle. I recommend that you execute the query and save the results in a spool file; then refer to those results in your analysis. Consider the following in your answer.
a. What error does Oracle find first?
b. When does Oracle stop processing the query?
c. What error message does Oracle return?
d. Is that error message accurate?
e. Does Oracle identify both errors? Why or why not?
4. Use the Global Engineering query from your Discussion 3 contribution that produces incorrect results. Execute the Explain Plan for this query. Describe in detail how this query is processed by Oracle. I recommend that you execute the query and save the results in a spool file; then refer to those results in your analysis. Consider the following in your answer.
a. How does Oracle process this query? That is, what does Explain Plan tell you about how the query is processed?
b. How would you recognize that the results were not correct?
c. What is the error that caused the query to produce incorrect results?
|
Define cyclohexane-toluene mixture
: cyclohexane-toluene mixture, and then obtain IR spectra for each fraction. How would the IR spectrum of the first 1 mL fraction look different from that of the last 1 mL fraction?
|
|
Problem of a rational consumer with an utility function
: Based on customer feedback, the firm is considering eliminating the matching policy and introducing instead a price rebate of size r per-unit purchased.
|
|
Define how much solid potassium iodide should add
: Need to make an aqueous solution of 0.233 M potassium iodide for an experiment in lab, using a 250 mL volumetric flask. How much solid potassium iodide should you add?
|
|
How far has billy cycled
: Billy likes to go cycling.His bike has wheels of diameter 75cm. He has invented a counter for his bike, which counts the number of revolutions the wheels make. One day the counter shows 150 revolutions.How far has Billy cycled?
|
|
When does oracle stop processing the query
: How does Oracle process this query? That is, what does Explain Plan tell you about how the query is processed - how would you recognize that the results were not correct?
|
|
Compute the percent enantiomeric excess of the contents
: Calculate the percent enantiomeric excess of the contents of the bottle labeled as just menthol. For the purchased sample what percentage of (-)-menthol is indicated by this measurement?
|
|
Do you think industry environment is different today
: In the 1990s, five firms supplied amateur color film in the United States: Kodak, Fuji, Konica, Agfa, and 3M. From a technical viewpoint, there was little difference in the quality of color film produced by these firms, yet Kodak's market share wa..
|
|
Define what is the theoretical yield for the reaction
: What is the theoretical yield for this reaction under the given conditions? What is the percent yield for this reaction under the given conditions?
|
|
Which expression could be used to find the volume of drug
: It is 3 feet high, and the diameter of its circular base is 2 feet. Which expression could be used to find the volume of the drum?
|