The DEPARTMENTS table has the following data:DEPARTMENT IDDEPARTMENT NAMEMANAGER IDLOCATION_ID10Administration200170020Marketing201180050Shipping124150060IT103140080Sales1492500What will be the value in the first row of the result set when the following query is executed?SELECT manager_id FROM departments ORDER BY location_id;O a. 201O b. 149O c. 103O d. 200

Here all the tuple of column Manger_id will be selected. Order by clause will arrange the ids in…

e DEPARTMENTS table has the following data: DEPARTMENT_ID DEPARTMENT_NAME MANAGER_ID LOCATION_ID 10 Administration 200 1700 20 Marketing 201 1800 50 Shipping 124 1500 60 IT 103 1400 80 Sales 149 2500 at will be the value in the first row of the result set when the following query is executed?

e DEPARTMENTS table has the following data: DEPARTMENT_ID DEPARTMENT_NAME MANAGER_ID LOCATION_ID 10 Administration 200 1700 20 Marketing 201 1800 50 Shipping 124 1500 60 IT 103 1400 80 Sales 149 2500 at will be the value in the first row of the result set when the following query is executed?

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

I. Retrieve the SSN_NUMBER of all employees whose name starts with N. Attribute First Name Last Name SSN Number Data Type Varchar(15) Varchar(15) Char(9) Not Null Not Null Constraint Primary Key
Database Schema The schema for the Ch07_FACT database is shown below and should be used to answer the next several problems. Click this image to view it in its own tab. FIGURE P7.56 THE CH07_FACT ERD CHECKOUT PATRON PK Check Num PK Pat ID FK1 Book_Num FK2 Pat_ID Check_Out_Date Check_Due_Date Check_In_Date >0-----H- Pat_FName Pat LName Pat_Type BOOK AUTHOR PK Book_Num PK Au ID Book_Title Book_Year Book_Cost Book_Subject FK1 Pat_ID Au_FName Au_LName Au_BirthYear WRITES PK,FK1 Book Num PK,FK2 Au ID The CIS Department at Tiny College maintains the Free Access to Current Technology (FACT) library of e-books. FACT is a collection of current technology e-books for use by faculty and students. Agreements with the publishers allow patrons to electronically check out a book,
Based on stage 2, write queries for the following questions: Write a query to display all vendors sorted by vendor name. Write a query to display the product id, description, type, base, category, and price for all products that have a product base of water and a product category of sealer. Write a query to display the first name, last name, and email address of employees who were not hired from January 1, 2015, to December 31, 2019. Sort the output by the last name and then by the first name. Write a query to display the first name, last name, phone number, title, and department number of employees who work in department 123 and have the title “Assistant.” Write a query to display the employee number, last name, first name, salary “from” date, salary end date, and salary amount for employees 99675, 53845, and 44035. Sort the output by employee number and salary “from” date. Write a query to display the first name, last name, street no, street name, city,…
I. Retrieve the SSN_NUMBER of all employees whose name starts with N. Attribute First Name Last Name SSN Number Data Type Varchar(15) Varchar(15) Char(9) Not Null Not Null Constraint Primary Key
question 6 please use the picture below to answer the following question Write a SQL statement to define a constraint in the Position table to ensure the column position does not accept duplicates.
appropriately. Table: Author Column Name Data Type Size/Length Constraint Type AID Number Primary Key Varchar2 Not Null Varchar2 Number AName Lang Phno Table: Book Create all the below tables using SQL queries with necessary key constraints Column Name BID Bname Publisher Rate Tax AID AID 311 312 Table: Author 313 314 315 316 Table: Book B07 B08 Data Type Varchar2 10 Varchar2 25 Varchar2 25 Number 5,2 Number 3 Number AName Amira Saif Meera Hani Ahmed Marwan BID Bname B01 Palace of Desire B02 Rainbow Fish B03 King and Lion B04 Ghost Village B05 The Truth B06 Peter Pan 20 50 8 The Last Leaf The Little Size/Length Insert all the values to the tables using SQL queries. Lang Arabic Unique English Hindi Arabic English English Constraint Type Primary Key Not Null Foreign Key Between 1 and 200 Assign a proper name Assign a proper name Phno 99455625 99456625 99457725 97795234 97795254 97795354 Publisher Rate Tata 160 Pearson 140 DC Books 120 Pearson Tata Pearson DC Books Tata 180 170 140 130…
fbvxcbvc
q22
Question 18 The query in the figure below:. BRANCH SALESPERSON 1 Dr ID Br_Name Em ID TITLE FIRST LAST Gender DOB PASSWORD Dr ID SALART Field Br Name Table BRANCH TILE SALESPERSON First Last SALESPERSON, SALARY SALESPERSON SALESPERSON Sort Show Criteria RTa" DE A. The First, Last, and SALARY for all salespersons who did not work in a Riffa branch will be listed The Br Name, TITLE, First, Last, and SALARY for all salespersons who live in Manama will be listed The Br Name, TITLE, First, Last, and SALARY for all salespersons Mwill be listed The Br Name, TITLE, First Last, and SALARY for all salespersons who worked in a Riffa branch will be listed
*SQL Query Required* Display schedule_id, source, destination and travel_time which has minimum travel time. Sort the result based on schedule id BUSES P BUS_NO number(11) SCHEDULE BUS NAME Varchar2(20) t varchar2(20) t SCHEDULE_ID TRAVEL DATE varchar2(3) date d varchar2(20) t DESTINATION varchar2(20) t TYPE TOTAL_SEATS number(11) # AVAIL_SEATS number(11) # SOURCE number(11) BU NO number(11) # BUS_NO P BUS NO DURATION PAYMENTS DISCOUNTS P PAYMENT_ID varchar2(3)t varchar2(3) number(11) varchar2(3) TICKET ID BD IDO O TICKET_ID oO BD_ID PDISCOUNT_ID DISCOUNT_AMOUNT number(11) # TICKETS O DISCOUNT_ID varchar2(3) SCOUNT_ID TICKET ID yarchar2(3) HEDULE ID O SCHEDULE ID varchar2(3) number(11) # number(11)O number(11) # FARE USER ID OUSER ID NO SEATS USERS PUSER_ID number(11) varchar2(20) t ADDRESS varchar2(100) t number(11) # EMAILID varchar2(30) t primary key - not null NAME e foreign key PHNO # data type - number d data type - date It| data type - varchar2 CANCELLATION PCANCELLATION_ID…
Task 3: The Car Maintenance team wants to insert and store the following maintenance types to the MAINTENANCE_TYPES table: ID: 1; Description: Tire Change; Price: 50 ID: 2; Description; Oil Change; Price: 45 ID: 3; Description; Full Cleaning; Price: 100 ID: 4; Description; Gas Pump Change; Price: 145 SQL Database Add the four maintenance types to the MAINTENANCE_TYPES table Test Query SELECT * FROM MAINTENANCE_TYPES Expected Results MAINTENANCE_TYPE_ID MAINTENANCE_TYPE_DESCRIPTION MAINTENANCE_PRICE 1 Tire Change 50 2 Oil Change 45 3 Full Cleaning 100 4 Gas Pump Change 145
Q1- List all employees whose job_id is IT_PROG and hired after 01-JAN-95 and earning more than5000.Q2- List all employee except those with employee_id 101, 102, 103, 104 and 105Q3- Display the city attribute from locations table. Show the ones that contain “South” in the city.Sort the list in descending order.Q4- Display the first name, last name, salary, manager id and job id of all employees whose last fourcharacters of job id ends with “LERK”.Q5- Display the first name, last name and salary of all employees. Round the salary to the nearestunit of 1000 (ex. Salary=4500 New Salary=5000). Label the column as "New Salary".