65 759
Assignments Done
99,3%
Successfully Done
In October 2018

Databases | SQL | Oracle | MS Access Answers

Questions: 222

Free Answers by our Experts: 137

Ask Your question

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Search & Filtering

How many levels of abstraction a typical database should hold
Write a SQL query for the following:

1. I need to know which of our sales reps don’t have any customers, all regions. (Hint: This is a different type of JOIN. Also, test for nulls and eliminate the managers.)

2. tell me which region managers are responsible for those sales reps who don’t have customers in all regions. Display the region ID, I can get the full name separately. (Hint: You’ll need to see the entire employee/customer list to provide this answer)
I want a list of employees in the east and west regions and I need the full region name, not just the region ID.
each bank customer can have several types of accounts and each type of account can only be owned by a customer
I am trying to figure out the formula for this question. I tried but i can't figure it out:

create a calculated field with the column label Discount Price that subtracts the Price times the Current Discount from the Price.

Construct an er diagram for a university registrar office
The query below is an example of a:
SELECT O.ORDERID, o.SALESPERSONID, S.SALESPERSONID
FROM ORDER_T o FULL JOIN SALESPERSON_t s
ON O.SALESPERSONID = S.SalespersonID


An INNER JOIN


A Subquery


A UNION


A FULL JOIN
What would happen if a ROLLBACK is executed after an INSERT statement within a transaction?


The ROLLBACK fails because it is only for UPDATE


Records from the table are deleted


The record(s) that were inserted do not get committed to the table


The records are left inconsistent
The COMMIT statement is ...



Only works when combined with a ROLLBACK.


Only works within a transaction.


not needed because the server always commits changes.


Makes changes outside a transaction permanen.t
Submit
Privacy policy Terms and Conditions