Question
SQL questions. Select the appropriate letter/option only. Multiple choice. 1.Which of the following statements identifies the syntax error in this query? select Lastname, Firstname from
SQL questions. Select the appropriate letter/option only. Multiple choice.
1.Which of the following statements identifies the syntax error in this query?
select Lastname, Firstname from charity.donors where Donation > 1000 and; Lastname not in select Lastname from charity.current;
a. The subquery requires a semicolon prior to the SELECT statement in the WHERE clause. | |
b. The subquery has an extra semicolon after the AND operator. | |
c. The subquery must reside inside a HAVING clause. | |
d. The subquery must reference the same table as the outer query. |
2.Which query finds the ID, Job_Title and Salary of all employees who make more than the average of all employees?
ID | Job_Title | Salary |
---|---|---|
001 | Director | $163,040 |
046 | Sales Manager | $108,255 |
074 | Office Assistant | $36,256 |
085 | Service Assistant | $29,147 |
a. select ID, Job_Title, Salary from staff where Salary > (mean(Salary)); | |
b. select ID, Job_Title, Salary from staffwhere Salary > (select mean(Salary)); | |
c. select ID, Job_Title, Salary from staff where Salary > (select mean(Salary) from staff); |
3.Which query finds the ID, Job_Title and Salary of all employees in the Engineering department?
ID | Job_Title | Salary | Department |
---|---|---|---|
001 | Director | $163,040 | Sales Management |
074 | Office Assistant | $36,256 | Administration |
085 | Service Assistant | $29,147 | Engineering |
a. select ID, Job_Title, Salary from staff where ID in (select ID from staff where Department ="Engineering"); | |
b. select ID, Job_Title, Salary from staff where ID = (select ID from staff where Department ="Engineering"); |
4.Suppose you need to use the most up-to-date data from a complex query and want multiple users to be able to access the information. Which of the following solutions would be best?
a. Create a table with the complex query and allow users access to the table. | |
b. Create a view with the complex query and allow users to access the view. | |
c. Send users the complex query to copy and paste in their queries as an in-line view. |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started