Reference no: EM13973038
Objectives:
·To demonstrate your understanding of how a query is processed.
·Related to Objectives #3 and #4 as listed in the Syllabus Addendum.
Scenario:
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,andorderby 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 notinclude 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?
5.Extra Credit Oracle has to complete many steps in the processing of a DDL statements such as acreate tablestatement. List and describe the steps or substeps Oracle needs to process acreate tablestatement. Show them in the order in which they would occur.
|
Charge of communications for a company
: When responding to your peers, review the types of social media that are addressed in their posts, and offer further possible examples for their choices.
|
|
Create a prototype or mockup of homepage and secondary page
: Based on your recommendations from attachments, create a prototype or mockup of the homepage and a secondary page of your choice for your assigned/chosen Virtual Organization.
|
|
What are the leader most important tasks
: What core personality traits do you bring to your personal leadership model? What leadership skills do you possess, and how do these skills enhance your model? What are the leader's most important tasks? What are the core values that your leadership ..
|
|
What were you able to accomplish
: Which sources of power do you feel are most applicable to your field of study or industry? Describe a time when you exercised one of these sources of power. What were you able to accomplish
|
|
When does oracle stop processing the query
: 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.
|
|
Determine the density of the solution
: A student uses a volumetric pipet to transfer 10.00 mL of the NaCl solution as described question 3 to a beaker. the mass of this volume of solution is 10.08 g. Determine the density of the solution.
|
|
Calculate the density of the substance
: If an unknown substance has a mass of 0.6035g and a volume of 0.550 mL, calculate the density of the substance. Please show any unit conversion factors. Your answers must have the correct number of sig figures. a. g/ml b.g/l c. kg.ml d.kg/dm^3.
|
|
What is meant by influence tactics
: What is meant by "influence tactics"? What are some of the most common tactics used by leaders to influence followers? What is the cornerstone of presidential leadership according to Neustadt? Do you agree or disagree with his perspective and why
|
|
Percentage of tenkey assets
: Sandra was alarmed because inventories constituted a large percentage of Tenkey's assets, and if losses could occur in even one store, they could probably occur in others too. She called a staff meeting that included the IT director and the genera..
|