Homework Answers
c. it will return all rows and columns from the EMPLYEES table where the TYPE column ="CASHIER"
select * return all rows and all columns but there is a WHERE clause which shrink down the output , therefore it returns rows were type column has 'cashier'
Add Answer to:
What will the following SQL script return? /* SELECT* FROM EMPLOYEES WHERE TYPE = 'CASHIER' */...
Using the following table what will result from the SQL command "SELECT Item SKU, Price? Item...
Using the following table what will result from the SQL command "SELECT Item SKU, Price? Item SKU Price Manufacturer 651 $ 5.00 Nike 546 $ 4.00 Nike 876 $ 5.00 Under Armour 165 $ 10.00 Addidas All data in the 1st and 2nd columns for the first and last row. ОООО All rows but only columns with numerical data. All rows but only the 1st and 2nd column. All data in the table.
Which SQL statement retrieves the EmployeeName and City columns from the Employees table? O LIST EmployeeName,...
Which SQL statement retrieves the EmployeeName and City columns from the Employees table? O LIST EmployeeName, City ON Employees; O FIND EmployeeName, City ON Employees; SELECT EmployeeName, City FROM Employees; O RETRIEVE EmployeeName, City FROM Employees; Which SQL statement finds the different cities in which national parks reside with no duplicate rows listed? SELECT DISTINCT city FROM natlpark ORDER BY city; O ORDER BY natlpark DISTINCT city; O ORDER BY city FROM natlpark; O SELECT city FROM natlpark ORDER BY...
WRITE A SQL QUERY SQL SERVER Write a SELECT statement that returns one column from the...
WRITE A SQL QUERY SQL SERVER Write a SELECT statement that returns one column from the Customers table named FullName that joins the LastName and FirstName columns. -- Format this column with the last name, a comma, a space, and the first name like this: -- Doe, John -- Sort the result set by last name in ascending sequence. -- Return only the contacts whose last name begins with a letter from M to Z. -- ...
1.What is the return value if the user try to do the following: SELECT TRUNC (65.73,-2)...
1.What is the return value if the user try to do the
following:
SELECT TRUNC (65.73,-2) FROM DUAL;
Select one:
a. 60
b. 00
c. 0
d. 600
2.Supposed that the user uses the ff SELECT statement: what will
be the possible output.
SELECT GRADE AS STUDENT MARK
FROM GRADE_REPORT;
Select one:
a. Error because of the keyword AS.
b. Error because of missing “” mark.
c. Will display the column GRADE rename as STUDENT MAK
d. Will display all...
QUESTIONS Q01: Use the comment feature of SQL to print your full name, AUID and username in three separate lines at the top of the script file. From this point onwards, you should use the comment fea...
QUESTIONS Q01: Use the comment feature of SQL to print your full name, AUID and username in three separate lines at the top of the script file. From this point onwards, you should use the comment feature to separate your answers for each question. (0.2 mark) Q02: Write a SQL statement to retrieve all the rows from the Product table. All the columns should be renamed with proper spacing using the alias feature. For example, the UnitPrice column should be...
An objective of this task is to implement SQL script that verifies the following logical consistency constraint imposed...
An objective of this task is to implement SQL script that verifies the following logical consistency constraint imposed on the contents of a sample database. "All orders submitted after 30 April 2019 must not include discontinued products" Download a file solution1.sql and insert into the file the implementations of the following actions. (1) First, the script inserts into a sample database information about a new order submitted today that includes two products. One of the products is discontinued while the...
2. Write a script that implements the following design: In the Downloads table, the user_id and...
2. Write a script that implements the following design: In the Downloads table, the user_id and product_id columns are the foreign keys. Create these tables in the ex schema. Create the sequences for the user_id, download_id, and product_id columns. Include a PL/SQL script to drop the table or sequence if it already exists. Include any indexes that you think are necessary. 3. Write a script that adds rows to the database that you created in exercise 2. Add two rows...
Using the Cash table below, show the output for the following SQL query: (Using the dropdowns,...
Using the Cash table below, show the output for the following
SQL query: (Using the dropdowns, identify which rows and
columns would included in the SQL query output shown below. Select
"Not included" for rows and columns that would not be included in
the output.)
SELECT Account#, Balance
FROM Cash
WHERE Bank = ‘Boston5’
ORDER BY Amount DESC;
Cash Account # Type Bank Balance 253 48.000 75,000 950 Checking Checking Draft Checking ncluded BA-6 BA-7 ot Included BA-8 BA-9 Boston...
5. Write a SELECT statement that returns these columns from the Orders table: OrderID OrderDate ShipDate...
5. Write a SELECT statement that returns these columns from the Orders table: OrderID OrderDate ShipDate Return only the rows where the ShipDate column contains a null value. 6. Write a SELECT statement that returns all columns from the Addresses table State is equal to CA 7. Write a SELECT statement that returns all columns from the Products table Product name has a "ru" in its name 8. Write a SELECT statement that returns these columns from the Customers table...
What happens when you try to compile and run the following code? String query = "INSERT...
What happens when you try to compile and run the following code? String query = "INSERT INTO Invoices (InvoiceDate InvoiceTotal) " + "VALUES ('2/10/01', '443.55')"; Statement statement = connection.createStatement(); statement.executeUpdate(query); a. A SQLException is thrown at runtime because the executeUpdate method can’t accept a String object. b. A SQLException is thrown at runtime because the SQL statement is coded incorrectly. c. An error occurs at compile time because the SQL statement is coded incorrectly. d. This code compiles and...
Using the following table what will result from the SQL command "SELECT Item SKU, Price? Item SKU Price Manufacturer 651 $ 5.00 Nike 546 $ 4.00 Nike 876 $ 5.00 Under Armour 165 $ 10.00 Addidas All data in the 1st and 2nd columns for the first and last row. ОООО All rows but only columns with numerical data. All rows but only the 1st and 2nd column. All data in the table.
Which SQL statement retrieves the EmployeeName and City columns from the Employees table? O LIST EmployeeName, City ON Employees; O FIND EmployeeName, City ON Employees; SELECT EmployeeName, City FROM Employees; O RETRIEVE EmployeeName, City FROM Employees; Which SQL statement finds the different cities in which national parks reside with no duplicate rows listed? SELECT DISTINCT city FROM natlpark ORDER BY city; O ORDER BY natlpark DISTINCT city; O ORDER BY city FROM natlpark; O SELECT city FROM natlpark ORDER BY...
1.What is the return value if the user try to do the
following:
SELECT TRUNC (65.73,-2) FROM DUAL;
Select one:
a. 60
b. 00
c. 0
d. 600
2.Supposed that the user uses the ff SELECT statement: what will
be the possible output.
SELECT GRADE AS STUDENT MARK
FROM GRADE_REPORT;
Select one:
a. Error because of the keyword AS.
b. Error because of missing “” mark.
c. Will display the column GRADE rename as STUDENT MAK
d. Will display all...
QUESTIONS Q01: Use the comment feature of SQL to print your full name, AUID and username in three separate lines at the top of the script file. From this point onwards, you should use the comment feature to separate your answers for each question. (0.2 mark) Q02: Write a SQL statement to retrieve all the rows from the Product table. All the columns should be renamed with proper spacing using the alias feature. For example, the UnitPrice column should be...
Using the Cash table below, show the output for the following
SQL query: (Using the dropdowns, identify which rows and
columns would included in the SQL query output shown below. Select
"Not included" for rows and columns that would not be included in
the output.)
SELECT Account#, Balance
FROM Cash
WHERE Bank = ‘Boston5’
ORDER BY Amount DESC;
Cash Account # Type Bank Balance 253 48.000 75,000 950 Checking Checking Draft Checking ncluded BA-6 BA-7 ot Included BA-8 BA-9 Boston...
5. Write a SELECT statement that returns these columns from the Orders table: OrderID OrderDate ShipDate Return only the rows where the ShipDate column contains a null value. 6. Write a SELECT statement that returns all columns from the Addresses table State is equal to CA 7. Write a SELECT statement that returns all columns from the Products table Product name has a "ru" in its name 8. Write a SELECT statement that returns these columns from the Customers table...
Most questions answered within 3 hours.
-
draw product of cyclohex-2-en-1-one, Sodium methoxide and
hydronium workup
asked 5 minutes ago -
In a certain state, about 65% of drivers who are arrested for
driving while intoxicated (DWI)...
asked 6 minutes ago -
A single NEC SX-9 vector processor unit (VPU) has a peak
arithmetic
performance of 102.4 GFs/s....
asked 24 minutes ago -
. Determine the hourly multiplication factors
such that the total daily water consumption will equal 15,000...
asked 25 minutes ago -
A budgeting Web site reported that 35% of U.S. households have
withdrawn money from a 401(k)...
asked 23 minutes ago -
In this assignment, you will write a minimum two-page paper that
explains the treatment of internal...
asked 28 minutes ago -
Direct marketing is also referred to as Question 50 options: 1)
one-to-one marketing. 2) business-customer marketing....
asked 31 minutes ago -
INK Ltd is grocery retailer with 103 shops around South
Australia and Tasmania. The company has...
asked 36 minutes ago -
HOW BEER IS MADE
The beer making process is an art. It takes time, patience and...
asked 37 minutes ago -
What two methods could be used to purify the dimethyl
fumarate?
Based on the 12 Principles...
asked 46 minutes ago -
Reflect upon the readings and videos as well as our Media Monday
discussion. Integrating concepts from...
asked 51 minutes ago -
1. A cylindrical capacitor with A = 0.01, B = 0.1 and a length
of 5...
asked 58 minutes ago