Please solve! First: Which of the following outputs would be produced when this SELECT is executed? Explain. (Note: data shown below in question #2!)SQL SELECT donor.idno, name, yrgoal, donation.driveno, contamt, drivename2 FROM donation, donor, drive3 WHERE donation.idno = donor.idno and donation.driveno = drive.driveno;Output A:IDNO NAMEYRGOAL DRICONTAMT DRIVENAME25 Animal Home11111 Stephen Daniels12121 Jennifer Ames500 100400 20040 Animal Home23456 Susan Ash33333 Nancy Taylor22222 Carl Hersey100 10050 30010020 Animal Home10 Animal Home10 Animal Home12121 Jennifer Ames400 10050 Animal Home500 20011111 Stephen Daniels23456 Susan Ash35 Animal Home100 30010 Animal HomeOutput B:IDNO NAMEYRGOAL DRICONTAMT DRIVENAME100 100100 10023456 Susan Ash20 Kids Shelter20 Animal Home23456 Susan Ash100 100100 10050 30050 30023456 Susan Ash20 Health Aid23456 Susan Ash33333 Nancy Taylor33333 Nancy Taylor33333 Nancy Taylor33333 Nancy Taylor20 Half Way10 Kids Shelter10 Animal Home50 30050 30010 Health Aid10 Half Way23456 Susan Ash100 30010 Kids Shelter23456 Susan Ash100 30010 Animal Home23456 Susan Ash100 30010 Health Aid23456 Susan Ash100 30010 Half WayOutput C:IDNO NAMEYRGOAL DRICONTAMT DRIVENAME11111 Stephen Daniels500 10025 Kids Shelter23456 Susan Ash100 10020 Kids Shelter22222 Carl Hersey12121 Jennifer Ames12121 Jennifer Ames11111 Stephen Daniels33333 Nancy Taylor10010 Kids Shelter400 10050 Kids Shelter400 20040 Animal Home500 20050 300100 30035 Animal Home10 Health Aid10 Health Aid23456 Susan Ash

Answer: Output would be C because here donation.idno=donor.idno and donation.driveno=donar.driveno…

Answered: SQL SELECT donor.idno, name, yrgoal,…

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter4: Constraints

Section: Chapter Questions

Problem 3MC: Which of the following SQL statements is invalid and returns an error message? ALTER TABLE books ADD...

See similar textbooks

Similar questions

Given the following SQL statement, which statement is most accurate?SELECT customer# FROM customersJOIN orders USING(customer#)WHERE shipdate-orderdate IN(SELECT MAX(shipdate-orderdate) FROM ordersWHERE shipdate IS NULL);a. The SELECT statement fails and returns an Oracle error message.b. The outer query displays no rows in its results because the subquery passes a NULLvalue to the outer query.c. The customer number is displayed for customers whose orders haven’t yet shipped.d. The customer numbers of all customers who haven’t placed an order are displayed
how to filter based on a parameter in a sql function ?' I have the following sql function: CREATE FUNCTION Function.FunctionExample { @name UNIQUEIDENTIFIER = NULL, @date DATETIME = NULL, @seconddate DATETIME = NULL } RETURNS @returnTable TABLE { Code INT, Date DATETIME, SecondDate DATETIME } AS BEGIN INSERT INTO @returnTable { Code, Date, SecondDate } SELECT Date1 AS Date, Date1 AS SecondDate FROM Function.FunctionExample WHERE (@Date IS NULL OR CONVERT(DATE, FunctionExample.Date1) >= @Date) AND (@SecondDate IS NULL OR CONVERT(DATE, FunctionExample.Date1) >= @SecondDate) RETURN END What would I have to do If I wanted to filter based on the @name parameter ?
Im trying to run the following SQL in Oracle: SELECT GUEST_KR.FIRSTNAME, GUEST_KR.LASTNAME,FEE_KR.DateCharged,FEE_KR.FeeDescription,FEE_KR.FeeCharged,SUM(FeeCharged) AS TotalFeeChargedFROM FEE_KRJOIN SERVICE_KR ON FEE_KR.ServiceID = SERVICE_KR.ServiceIDJOIN GUEST_KR ON SERVICE_KR.ServiceID = GUEST_KR.GuestIDWHERE ServiceName IN ('First Name', 'Last Name', 'Date Charged', 'Fee Description')WHERE ServiceName NOT IN (SELECT FEETYPE FROM REPORT_FILTER_KR)GROUP BY GUEST_KR.FIRSTNAME, GUEST_KR.LASTNAME,FEE_KR.DateCharged,FEE_KR.FeeDescription,FEE_KR.FeeChargedORDER BY SUM(FeeCharged) DESC; And I'm recieving this error: Error starting at line : 1 in command -SELECT GUEST_KR.FIRSTNAME, GUEST_KR.LASTNAME,FEE_KR.DateCharged,FEE_KR.FeeDescription,FEE_KR.FeeCharged,SUM(FeeCharged) AS TotalFeeChargedFROM FEE_KRJOIN SERVICE_KR ON FEE_KR.ServiceID = SERVICE_KR.ServiceIDJOIN GUEST_KR ON SERVICE_KR.ServiceID = GUEST_KR.GuestIDWHERE ServiceName IN ('First Name', 'Last Name', 'Date Charged', 'Fee…
Which of the following is a correct statement? a. A commit is issued implicitly when a user exits SQL Developer or SQLPlus. b. A commit is issued implicitly when a DDL command is executed. c. A commit is issued automatically when a DML command is executed. d. All of the above are correct. e. Both a and b are correct. f. Both a and c are correct.
Which of the following SQL statements is invalid and returns an error message? ALTER TABLE books ADD CONSTRAINT books_pubid_uk UNIQUE (pubid); ALTER TABLE books ADD CONSTRAINT books_pubid_pk PRIMARY KEY (pubid); ALTER TABLE books ADD CONSTRAINT books_pubid_nn NOT NULL (pubid); ALTER TABLE books ADD CONSTRAINT books_pubid_fk FOREIGN KEY (pubid) REFERENCES publisher (pubid); All of the above statements are invalid.
The following two SQL statements will produce the same results. SELECT P_DESCRIPT, P_QOH,P_PRICE FROM PRODUCT WHERE P_QOH >(SELECT P_QOH FROM PRODUCT WHERE P_CODE='11QER/31') AND P_PRICE>(SELECT P_PRICE FROM PRODUCT WHERE P_CODE='11QER/31'); SELECT P_DESCRIPT, P_QOH,P_PRICE FROM PRODUCT WHERE (P_QOH,P_PRICE) > (SELECT P_QOH,P_PRICE FROM PRODUCT WHERE P_CODE='11QER/31'); A) True B) False
This actually didnt work to resolve my problem... Heres what I have so far. CREATE TABLE Horse ( ID SMALLINT UNSIGNED AUTO_INCREMENT, RegisteredName VARCHAR(15), PRIMARY KEY (ID)); CREATE TABLE Student ( ID SMALLINT UNSIGNED AUTO_INCREMENT, FirstName VARCHAR(20), LastName VARCHAR(30), PRIMARY KEY (ID)); -- Your SQL statements go here
The following two SQL statements will produce the same results. SELECT P_DESCRIPT, P_PRICE FROM PRODUCT WHERE P_CODE IN (SELECT P_CODE FROM LINE GROUP BY P_CODE HAVING COUNT(*) >=1); SELECT P_DESCRIPT, P_PRICE FROM PRODUCT WHERE EXISTS (SELECT P_CODE FROM LINE WHERE LINE.P_CODE=PRODUCT.P_CODE); Group of answer choices A) True B) False
Develop a PL/SQL block that would go through all the employees from EMPLOYEES table who work in department_id= 90 (there is suppose to be 3 employee who work in Department 90) IN BEGIN END END SECTION; Execute 3 separate of SELECT statement one after the other. Each SELECT will pull first_name , salary of each employee and store them in local variables. SELECT LOAD INTO v_firstname1, v_salary1 WHERE employee_id=100 Then second SELECT first_name, salary INTO v_firstname2, v_salary2 ….. WHERE employee_id=101 Then third SELECT, SELECT first_name, salary INTO v_firstname3, v_salary3 ….. WHERE employee_id=102 You must now have 6 local variables. DECLARE all of them accordingly in DECLARE section and use them in BEGIN and END. Then add another SELECT statement in BEGIN-END to find company average salary SELECT avg(salary) INTO v_avgsal FROM EMPLOYEES; !!! Do not forget to create v_avgsal local variable in DECLARE section.
Use SQL Developer or Oracle Live SQL to write the appropriate SQL commands as follows: A) FUNCTION: Use the region table to create a function called ‘Return_region_name’ which accepts an input parameter ‘region_id’, and print the name of the region with that id. Then execute this function with region_id = 1. [LAB-7] (3) B) PROCEDURE: Use the cust_node table to create a procedure called ‘Get_node_id’ that takes the cust_id as an input parameter to show its corresponding node id to the banker. Then execute this procedure with cust_id=5. [LAB-7] (2) C) Trigger: Create a row-level trigger called ‘Compute_Amount_trigger’ on the cust_txn table to automatically update the amount of withdraw transaction made after inserting or updating amount on the cust_txn table. Additionally, this trigger must show this statement ‘TRIGGER MESSAGE: The amount of cust_id and txn_type is modified successfully'. Then test your trigger by updating the cust_txn table. For example, update the amount of the…
SQL Commands In the sec0411_employees table, change the credit limit to $27.00 for all the employees who currently have a credit limit of $15.00 and also for any employee who has a null in the credit limit field. The code is something like update sec0411_employees change credit_limit to 27 if 15; But I get an error.
For the table definition below, write a SQL UPDATE statement that changes all annual salaries to monthly salaries. CREATE TABLE Worker ( WORKER_ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, FIRST_NAME TEXT, LAST_NAME TEXT, SALARY DOUBLE, JOINING_DATE DATETIME, DEPARTMENT CHAR(25));

SEE MORE QUESTIONS

Recommended textbooks for you

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS

SQL SELECT donor.idno, name, yrgoal, donation.driveno, contamt, drivename 2 FROM donation, donor, drive 3 WHERE donation.idno - donor.idno and donation.driveno - drive.driveno;