In OES4 database, we can verify the values stored in subtotal field by using thefollowing1:col gross_sales for 99999999col subtotal for 99999999select o.order_no,sum(qty*Unit_cost) Gross_Sales, sum(o.subtotal) subtotalfrom orders o, orderline ol, product pwhere o.order_no=ol.order_noand ol.product_no=p.product_nogroup by o.order_no;II:col gross_sales for 99999999col subtotal for 99999999select o.order_no,sum(qty*Unit_cost) Gross_Sales, sum(o.subtotal) subtotalfrom orders o, orderline ol, product pwhere o.order_no=ol.order_noand ol.product_no=p.product_nogroup by o.order_no;I & II: are correctI & II: are not correct|||I & II: are not correctI & II: are correct

In OES4 database, we can verify the values stored in subtotal field by using the following 1: col gross_sales for 99999999 col subtotal for 99999999 select o.order_no,sum(qty*Unit_cost) Gross_Sales, sum(o.subtotal) subtotal from orders o, orderline ol, product p where o.order_no=ol.order_no and ol.product_no=p.product_no group by o.order_no; 11: col gross_sales for 99999999 col subtotal for 99999999 select o.order_no,sum(qty*Unit_cost) Gross_Sales, sum(o.subtotal) subtotal from orders o, orderline ol, product p where o.order_no=ol.order_no and ol.product_no=p.product_no group by o.order_no; I & II: are correct I & II: are not correct || I & II: are not correct I & II: are correct

In OES4 database, we can verify the values stored in subtotal field by using the following 1: col gross_sales for 99999999 col subtotal for 99999999 select o.order_no,sum(qtyUnit_cost) Gross_Sales, sum(o.subtotal) subtotal from orders o, orderline ol, product p where o.order_no=ol.order_no and ol.product_no=p.product_no group by o.order_no; 11: col gross_sales for 99999999 col subtotal for 99999999 select o.order_no,sum(qtyUnit_cost) Gross_Sales, sum(o.subtotal) subtotal from orders o, orderline ol, product p where o.order_no=ol.order_no and ol.product_no=p.product_no group by o.order_no; I & II: are correct I & II: are not correct || I & II: are not correct I & II: are correct

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

List all products with their highest unit price, i.e. not discounted.the database is
In Oracle database, if we have any field such as Job_Title field in any of our table then we can use DECODE function to sort the result based on our own numerical value. This can be done by including the following in ORDER BY clause: 1: ORDER BY DECODE(job-title,'Manager',3,Assistant',2,'Sales Rep', 1) DESC II: ORDER BY DECODE(job-title,'Manager', 3,'Assistant',2, Sales Rep', 1) ASC III I and II are correct IV I and II are incorrect ||| IV || 1
True or False below: Given two relations named A and B, if we q-JOIN A and B, the maximum number of attributes in the result relation could be (the number of attributes of A) times(*) the number of attributes of B). * in an SQL SELECT statement means “all the tuples”. In relational algebra, Cartesian Product (X) can be implemented using the q-JOIN operator. Cartesian Product ISA q-JOIN where q-condition always evaluates to true. SQL is based on Predicate Calculus. A query in SQL always specifies what should be included in the query result.
true/false INNER JOIN combines two relations. It takes the second relation, and appends it to the end of the first relation. In Corelated Subqueries, subquery is executed independent of the outer query: subquery is executed only once. SELECT * FROM sys.Relations displays information about all the user-defined relations within a database. Given GENDER and STUDENT relations, SELECT Gender, FName, LName FROM GENDER LEFT OUTER JOIN STUDENT ON STUDENT.GenderCode = GENDER.GenderCode ≡ SELECT Gender,FName, LName FROM STUDENT RIGHT OUTER JOIN GENDER ON STUDENT.GenderCode = GENDER.GenderCode The statements select RIGHT('I wish I had attended the practice hours', 9) and select…
Use your ERD to define the table structures in the database using SQL DDL commands to build your schema.
Intersection table is needed when you have a relationship 1:1 M:N M:1 1:M
Why it's useful to have index that partially sort a query if it doesn't present all of the results already sorted?
In SQL This sample database consists of the following tables(see image for tables and there is one more at the bottom in this text):• Customers: stores customer’s data• Products: stores a list of scale model cars• ProductLines: stores a list of product line categories• Orders: stores sales orders placed by customers• OrderDetails: stores sales order line items for each sales order• Payments: stores payments made by customers based on their accounts• Employees: stores all employee information as well as the organization structuresuch as who reports to whom• Offices: stores sales office data Write SQL code for the following:We want to add a new sale order for the customer (customerNumber = 145) in thedatabase. The steps of adding a sale order are described as follows:(1) Get latest sale order number from “orders” table, and use the next sale ordernumber as the new sale order number(2) Insert a new sale order into “orders” table for the customer (customerNumber =145). For this order, the…
Explain set operator in SQL
Consider the following relational schema. titles employees emp_ne NUMERICE 0) emp ne NUMERICEO) title CHARACTER VARYING) from date DATE to date DATE birth date DATE first mame CHARACTER VARYING(14 last name CHARACTER VARYING(16) gender CHARACTER) hire date DATE salaries emp ne NUMERICE0) salary NUMERIC6.0) from_date DATE te date DATE dept_manager dept_no CHARACTERIA emp no ERICISO from date DATE to date DATE departments dept ne CHARACTERIA) dept_name CHARACTER VARYINOJAO) dept_emp emp ne NUMERICS dept ne CHARACTER() from date DATE date DATE The salaries table has the primary key named emp_no. The titles table has the primary key named emp_no. • The employees table has the primary key named emp_no. The dept_manager table has the composite primary key named (dept_no, emp_no). The dept_emp table has the composite primary key named (emp_no, dept_no). The departments table has the primary key named dept_no. The salaries table has a foreign key column named emp_no that references the…
SQL Database Write PL/SQL or T-SQL procedures to accomplish the following tasks: Obtain the first name and last name, separated by a space, of the guide whose number currently is stored in I_GUIDE_NUM. Place these values in the variables I_FIRST_NAME and I_LAST_NAME. Output the contents of I_GUIDE_NUM, I_FIRST_NAME, and I_ LAST_NAME. Obtain the number of persons, customer number, and customer last name for every reservation whose ID currently is stored in I_RESERVATION_ID. Place these values in the variables I_NUM_PERSONS, I_CUSTOMER_NUM, and I_LAST_NAME, respectively. Output the contents of I_NUM_PERSONS, I_CUSTOMER_NUM, and I_LAST_NAME. Add a row to the GUIDE table. Change the last name of the guide whose number is stored in I_GUIDE_NUM to the value currently found in I_LAST_NAME. Delete the guide whose number is stored in I_GUIDE_NUM
Unlike UNION queries, EXCEPT (MINUS) queries care about the order of operands.