Databases | SQL | Oracle | MS Access Answers

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.

How to excecute join queries in hibernate?

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

What would the following query include?

SELECT Customer_T.CustomerID,CustomerName, OrderID

FROM Customer_T RIGHT OUTER JOIN Order_T

ON Customer_T.CustomerID = Order_T.CustomerID


only rows that match both Customer_T and Order_T Tables


only rows that do not match both Customer_T and Order_T Tables


all rows of the Order_T Table regardless of matches with the Customer_T Table


all rows of the Customer_T Table regardless of matches with the Order_T Table