Description
Unformatted Attachment Preview
ITEC 315 - Assignment 6
Individual Assignment
Advanced SQL (chapter 8) - Answer the questions below thoroughly and completely. Submit one word
document via BlackBoard assignments. Be sure to include your name, course.section and assignment #.
Documents without a name or in other formats will not be accepted!
1. What is a CROSS JOIN? Give an example of its syntax.
2. What is an OUTER Join? Describe each of the three join types included in the OUTER JOIN
classification?
3. Using tables named T1 and T2, write a query example for each of the three join types you described
in Question 2 above. Assume that T1 and T2 share a common column named C1.
4. What is a subquery, and what are its basic characteristics?
5. What is a correlated subquery? Give an example.
6. Explain the difference between a regular subquery and a correlated subquery.
7. What MS Access/SQL Server function should you use to calculate the number of days between the
current date and January 25, 1999?
8. Suppose that a PRODUCT table contains two attributes, PROD_CODE and VEND_CODE. Those
two attributes have values of ABC, 125, DEF, 124, GHI, 124, and JKL, 123, respectively. The
VENDOR table contains a single attribute, VEND_CODE, with values 123, 124, 125, and 126,
respectively. (The VEND_CODE attribute in the PRODUCT table is a foreign key to the
VEND_CODE in the VENDOR table.) Given that information, what would be the query output for:
a. A UNION query based on these two tables?
b. A UNION ALL query based on these two tables?
c. An INTERSECT query based on these two tables?
d. A MINUS query based on these two tables?
9. MS Acess does not support the substring function. Using the Substring function show the ORACLE
SQL command to list the first three characters of a company’s EMP_LNAME values? Give an example,
using a table named EMPLOYEE.
10. What is a trigger, and what is its purpose?
11. What is a stored procedure, and why is it particularly useful? Give an example.
12. What is embedded SQL, and how is it used?
13. What is dynamic SQL, and how does it differ from static SQL?
Purchase answer to see full attachment
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Review
Review
Anonymous
I was stuck on this subject and a friend recommended Studypool. I'm so glad I checked it out!
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
Similar Content
Digital Security, Ethics and privacy objectives
Please make sure you respond to my question and two other classmates response to my question to receive full credit for cl...
Explain how these ERM implementations are similar or different. Also describe if you would implement the same ERM or done something different. Do you think their ERM implementation would be successful in the next years.
Chapters 13 and 14 described two organizations ERM implementation. Explain how these ERM implementations are similar or di...
Network Security Research Paper
Network Security Paper: In this paper, you will define the security strategies of Defense in Depth and Layered Security al...
Campbellsville University Cyber Security Discussion
Describe the best practice to employ to mitigate malware effects on a machine.
Much has been made of the new Web 2.0 pheno...
SRS 830 UMUC Software Requirements and Design Specification for Project Questions
Normally you gather requirements through interviews and reviews with stakeholders. From these interviews and reviews you ...
Operating Systems Development Question
The module is Operating Systems and must be done in Java.
Attached, you can find the full brief.
Methods that are listed ...
Threat Agents For Web Applications
The most and famous threat agent who may put this design in risk is the cybercriminals. The system connects directly to th...
Cloud Computing Responses
Hello Srikanth, thank you for your deep insight, especially on comparing and contracting between public, private, communit...
Shosh Business
You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on Blackboard via the a...
