Reference no: EM131309110
Assignment
1. Write a query that retrieves student.last_name, student.first_name and total number of enrollments from the student and enrollment tables. Your query should also include students that do not have any enrollments.
a. Write this query without using a join operator.
b. Write this query using the join operator style
2. Write a query that retrieves student.last_name, student.first_name, grade_type.description and average numeric_grade for all average numeric grades above 90.
a. Write this query without using a join operator.
b. Write this query using the join operator style
3. What are views and what are the advantages of using views.
4. Create a view that displays student.last_name, student.first_name, courses.descriptions, instructor.last_name, andinstructor. first_name.
5. Discuss the types of constraints that may be placed on view
6. What are Oracle sequences and how are they most commonly used.
7. What is a sub query and what are the types of sub queries. Your discussion should include the differences between the types of sub-queries.
8. Write a simple sub query that retrieves student last_name, student first_name for students that do not have any enrollments.
9. Write a correlated sub query that retrieves all instructors that have taught classes.
10. Where can sub-queries be placed in a SQL Select statement.
11. What are the ACID properties of a transaction.
12. Describe the three most common concurrent transaction execution problems. Explain how concurrency control can be used to avoid those problems.
13. What tables are good candidates for indexes and what type of indexes would you place on those tables.
14. Write a query using a set operator that list all first_names that students and instructors have in common.
15. What is a data warehouse and what type of data model is used in data marts to improve performance.
|
Analyze the parent goal of the maintain node
: Analyze the parent goal of the Maintain [SufficientRouteSeparation] node. Determine the incompleteness in the provided model fragment and fix the anomaly. Explain what the anomaly is and propose a way for it to be rectified.
|
|
What is level 0 protective clothing and ppe
: How much exhaust ventilation is required to maintain safety hazards below explosive levels?How much exhaust ventilation is required to maintain health hazards below OSHA-specified action levels?How many plant area room changes would be the level of..
|
|
Evaluate the quality of internet resources
: Search for news about a company that interests you. Use the questions for "Evaluating Web Resources," and submit a brief summary of your analysis.
|
|
How might capacity be measured
: How might capacity be measured? In what ways is capacity limited by labor constraints and by capital constraints? What are the consequences if demand in the economy exceeds capacity? What signs would you look for?
|
|
Write this query without using a join operator
: Write a query that retrieves student.last_name, student.first_name and total number of enrollments from the student and enrollment tables. Write this query without using a join operator.
|
|
What do the cpi and the ppi measure
: What do the CPI and the PPI measure? Why do we need both of these price indexes? (Think about what purpose you would use each one for.)
|
|
Are your state''s experiences same as rest of the country
: Are your state's experiences the same as the rest of the country? Provide an explanation of why your state's experiences are the same as or different from the rest of the country.
|
|
Can tech give the fashion industry a sustainability makeover
: General fabric research - Nike and Adidas show cautious support for eco-friendly dye technology. Can tech give the fashion industry a sustainability makeover
|
|
What is the unemployment rate in your state today
: Suppose all wages, salaries, welfare benefits, and other sources of income were indexed to inflation. Would inflation still be considered a problem? Why or why not?
|