62 476
Assignments Done
98,9%
Successfully Done
In June 2018

Databases | SQL | Oracle | MS Access Answers

Questions: 216

Free Answers by our Experts: 131

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

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
What is S an alias of in the query below?
select orderid, salespersonname
from
(select salespersonid, salespersonname, SalespersonTelephone
from Salesperson_T where SalesTerritoryID = 1) S
join Order_T O
on O.SalespersonID = S.SalespersonID


An Outer Join


A Derived Table


A Union


A Join
In the query below, what is the statement in between parenthesis?

SELECT CUSTOMERNAME
FROM CUSTOMER_T
WHERE CUSTOMERID IN
(SELECT DISTINCT CUSTOMERID FROM ORDER_T)


a list


A correlated subquery


A non-correlated subquery


A correlated insert statement
Table Customer_T has customer info including the CustomerID and CustomerName, while table Payment_T has every payment made by each CustomerID.

What statement would provide all records of payments made showing customer name?


SELECT PAYMENT.*, CUSTOMERNAME FROM PAYMENT_T


SELECT PAYMENT.*, CUSTOMERNAME FROM PAYMENT_T JOIN CUSTOMER_T ON PAYMENTID = CUSTOMERID


SELECT PAYMENT.*, CUSTOMERNAME FROM PAYMENT_T JOIN CUSTOMER_T ON CUSTOMERID = CUSTOMERID


SELECT PAYMENT.*, CUSTOMERNAME FROM PAYMENT_T P JOIN CUSTOMER_T C ON P.CUSTOMERID = C.CUSTOMERID
Assume there are two tables, A and B, with a one to many relationship. What join type would you use to get records from A and only those from B that match.


INNER JOIN


FULL JOIN


LEFT JOIN


OUTER JOIN
Select the statement that is equivalent to the one below. Equivalent means that it would return the same records.

SELECT *

FROM ARRIVAL

WHERE ORIGIN = 'DUS'

OR ORIGIN = 'JFK'

OR ORIGIN = 'DFW'




SELECT *
FROM ARRIVAL
WHERE ORIGIN IN ('DUS', 'JFK', 'DFW')

SELECT *
FROM ARRIVAL
WHERE ORIGIN OR ('DUS', 'JFK', 'DFW')

SELECT *
FROM ARRIVAL
WHERE ORIGIN = ('DUS', 'JFK', 'DFW')

SELECT *
FROM ARRIVAL
WHERE ORIGIN AND ('DUS', 'JFK', 'DFW')
Submit
Privacy policy Terms and Conditions