7. What is the result of executing the following SQL statement? UPDATE employee SET salary = 50000 WHERE salary < 50000; The statement sets the salary for each employee to a value below 50,000. The statement sets the salary of each employee to 50,000 and ensures that the salary cannot drop below 50,000. The statement sets the salary to 50,000 for each employee whose salary is below 50,000. The statement always sets the salary of each and every employee to 50,000 None of the above QUESTION 8 What is the proper SQL Statement to add a column called DEPTCODE that accepts 4 alphanumeric characters to a table called ΕMPLOYE? INSERT INTO TABLE EMPLOYEE (DEPTCODE CHAR(4)); UPDATE EMPLOYEE SET DEPTCODE TO CHAR(4); ALTER TABLE EMPLOYEE ADD (DEPTCODE CHAR(4)); ADD COLUM DEPTCODE CHAR(4) TO EMPLOYEE;

7. What is the result of executing the following SQL statement? UPDATE employee SET salary = 50000 WHERE salary < 50000; The statement sets the salary for each employee to a value below 50,000. The statement sets the salary of each employee to 50,000 and ensures that the salary cannot drop below 50,000. The statement sets the salary to 50,000 for each employee whose salary is below 50,000. The statement always sets the salary of each and every employee to 50,000 None of the above QUESTION 8 What is the proper SQL Statement to add a column called DEPTCODE that accepts 4 alphanumeric characters to a table called ΕMPLOYE? INSERT INTO TABLE EMPLOYEE (DEPTCODE CHAR(4)); UPDATE EMPLOYEE SET DEPTCODE TO CHAR(4); ALTER TABLE EMPLOYEE ADD (DEPTCODE CHAR(4)); ADD COLUM DEPTCODE CHAR(4) TO EMPLOYEE;

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

Database Q1: Select the correct SQL statement to provide the user Samer with read only permission on Employees table a) Grant read on Employee where username = Samer; b) Grant read only on Employee to Samer; c) Grant select to Samer on Employee; d) Grant select on Employee to Samer; Q2: Based on the TWO schema structures below, which SQL statement will create a view to show department names where each department has at least 5 employees? Employee (E_ID, E_Name, D_ID, E_Salary) Department (D_ID, D_Name, D_Address) (Select one) a) Create View Dept_Emp as select D_Name, count(E_ID) from Employee, Department where Employee D_ID = Department D_ID Group by D_Name Where count (E_ID) >= 5; b) Create View Dept_Emp as select D_Name, count(E_ID) from Employee D_ID = Department D_ID Group by D_Name Having count (E_ID) >= 5; c) Create View Dept_Emp as select D_Name, count(D_ID) from Employee, Department where Employee D_ID = Department D_ID Group by D_Name Having count (E_ID) >= 5; d)…
Write a PL/SQL stored procedure to print number of employees who are working in a job with Title "Tester". Include procedure call also. If the total count of Employees is more than 5 then print "Sufficient number of Employees" If the total count of Employees is less than 5 then print "Insufficient number of Employees" Else print "there are 5 employees". Use Oracle's NO DATA_FOUND build in exception to display the last message. DEPARTMENTS LOCATIONS P DEPARTMENT_ID * DEPARTMENT_NAME MANAGER_ID LOCATION_ID P LOCATION_ID STREET ADDRESS POSTAL_CODE * CITY STATE PROVINCE COUNTRY_ID JOB_HISTORY PF* EMPLOYEE_ID P * START DATE * END DATE F JOB ID F DEPARTMENT_ID EMPLOYEES P EMPLOYEE_ID FIRST NAME * LAST_NAME EMAIL COUNTRIES COUNTRY_ID COUNTRY_NAME F REGION ID PHONE_NUMBER * HIRE DATE F JOB_ID JOBS P JOB_ID * JOB_TITLE MIN_SALARY MAX_SALARY SALARY COMMISSION_PCT MANAGER_ID F REGIONS DEPARTMENT_ID P* REGION_ID REGION_NAME I--
Create a function to insert a new product into an existing order, include the product id, unit price, quantity. The output of the function is the message to notify the calling program whether the update succeeded or not. note : Note: Sql code need not java don't waste my time by giving java code
Table: Team Member Primary key: Team MemberID Team MemberID 1 2 3 Team MemberName Joe Bloggs Samantha Smith Pete Ngwenya Table: Task Primary key: TaskID Foreign key: Team MemberID TaskID 1 2 3 Description Build login screen Implement inventory management Add logo to splahs 1 screen TeamMemberEmail joe@theoffice.com sam@theoffice.com pete@theoffice.com Duration StartDate Team MemberID 2022-05-06 1 2022-05-15 1 4 10 2022-05-06 2
I need help with creating the SQL statement for the instructions below. Create the following 2 tables with columns and constraints Table Lab4program_xxxx has 3 columns: code is varchar(5) and the primar key, name is varchar(20), tel varchar(20). Table Lab4course_xxxx has 3 columns: cid is int, and the primary key, name is varchar(20), credits is int, mycode is a foreign key reference to your Lab4program table. Table Lab4program_xxxx has 3 columns: code is varchar(5) and the primar key, name is varchar(20), tel varchar(20). Table Lab4course_xxxx has 3 columns: cid is int, and the primary key, name is varchar(20), credits is int, mycode is a foreign key reference to your Lab4program table.
If you write PL/SQL program contains a cursor; which of the following statements can be written inside the loop? Nots: You may have many answers. (2 Points) *: open x; close x exit when x%notfound; fetch x into rec13B x integer:=673; rec1 employees%rowtype;
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.
Test your Procedure with the following data:AthleteID= 10, First_Name = ‘Frankie’, Last_Name = ‘Fredricks’, DOB = ’17 June 1975’. Create your SQL statement that will test the procedure.EXEC spInsertAthleteDetails @AthleteID= 10, @First_Name = ‘Frankie’, @Last_Name = ‘Fredricks’, @DOB = ’17 June 1975’;
YOu have to find SQL code of all and show output
Write SQL queries for the following statements. 1) Write SQL code which declares two variables for name and address. Store your name and address in respective variables. Display name and address in a single line using print statement. 2) Display table of 10 in given format using 10 x 1 = 10 10 x 2 = 20 . . . 10 x 10 = 100. 3) Write a code which declares a variable and stores age of youngest employee from “Employee” table. And display name of youngest employee 5 times his. 4) Assume that in “Employee” table, Emp_id are assigned from 1 to onward. ie first employee’s eid is 1, second employee’s eid is 2 and so on. Write a code that displays name of eldest employee without using aggregate function of “max”. You can use count function
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
12. Write a pl / sql program to calculate the overtime hours using if then and end if .