1.Create the My Employee table with the following fields:Not NullIDLast NameFirst NameUseridSalary123452. Add the constraint Primary Key (ID) to the table.3. Insert the following data to the table:IDLast NameFirst NameAliNumber(4)Varchar(25)Varchar(25)Varchar(8)Number(9,2)AlChameriAlaniziHejaziTurkiAlKamelRayenDechamMohamedFahhedUseridraptelbdancsbbiricnewmanaropeburSalary79586011007501550I4. Select all the data in the table.5. Change the Last Name of employee 4 to Turkish.6. Change the Salary to 1000 for all employees with a salary less than 900

Here is the complete solution of the above problem. See below steps.

1. Create the My Employee table with the following fields: Number(4) Varchar(25) Varchar(25) Varchar(8) Number(9,2) ID Last Name First Name Userid Salary 4 5 2. Add the constraint Primary Key (ID) to the table. 3. Insert the following data to the table: ID Last Name First Name 1 Ali 2 3 Not Null AIChameri AlAnizi Hejazi Turki AlKamel Rayen Decham Mohamed Fahhed Userid raptel bdancs bbiri cnewman aropebur I Salary 795 860 1100 750 1550 4. Select all the data in the table. 5. Change the Last Name of employee 4 to Turkish. 6. Change the Salary to 1000 for all employees with a salary less than 900

1. Create the My Employee table with the following fields: Number(4) Varchar(25) Varchar(25) Varchar(8) Number(9,2) ID Last Name First Name Userid Salary 4 5 2. Add the constraint Primary Key (ID) to the table. 3. Insert the following data to the table: ID Last Name First Name 1 Ali 2 3 Not Null AIChameri AlAnizi Hejazi Turki AlKamel Rayen Decham Mohamed Fahhed Userid raptel bdancs bbiri cnewman aropebur I Salary 795 860 1100 750 1550 4. Select all the data in the table. 5. Change the Last Name of employee 4 to Turkish. 6. Change the Salary to 1000 for all employees with a salary less than 900

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter9: Working With Text Functions And Creating Custom Formats

Section: Chapter Questions

Problem 5RA

See similar textbooks

Similar questions

Create a list of all customer numbers along with text indicating whether the customer has been referred by another customer. Display the text “NOT REFERRED” if the customer wasn’t referred to JustLee Books by another customer or “REFERRED” if the customer was referred.
Create a new table containing the category code and description for the categories of books sold by JustLee Books. The table should be called CATEGORY, and the columns should be CatCode and CatDesc. The CatCode column should store a maximum of 2 characters, and the CatDesc column should store a maximum of 10 characters.
Delete the index named ITEM_INDEX3.
How many NOT NULL constraints can be created at the table level by using the CREATE TABLE command? 0 1 12 30 255
A new table has been requested to support tracking automated emails sent to customers. Create the table and add data as described below. Tablename: email_log Columns: emailid (numeric), emaildate (datetime), customer# (numeric) Primary key: emailid column, define as an Identity Column Add the following data rows and display resulting rows (if any errors occur, explain why the error is expected) Emaildate = current date, customer# = 1007 Emailid = specify to use the column default value, emaildate = current date, customer# = 1008 Emailid = 25, emaildate = current date, customer# = 1009
1. ID Last Name First Name Create the My Employee table with the following fields: Not Null Number(4) Varchar(25) Varchar(25) Varchar(8) Number(9,2) Userid Salary 2. Add the constraint Primary Key (ID) to the table. 3. Insert the following data to the table: ID Last Name First Name Ali 1 2 3 4 5 AlChameri Alanizi Hejazi Turki AlKamel Rayen Decham Mohamed Fahhed 4. Select all the data in the table. Userid raptel bdancs bbiri cnewman aropebur I Salary 795 860 1100 750 1550
Guided Table Build: We will be Creating a Table called Student For the 6 following questions, your submission will be the query that shows you’ve created the table conforming to the requirements. Create a Table Named Student. The first column should be named ID, and have a data type of Integer The second column should be named First_Name, and have a data type of varchar(255). The third column should be named Last_Name, and have a data type of varchar(255) The fourth column should be named DOB (short for date of birth), and have a data type of date. The firth column should be named Adv_ID (short for advisor ID), and have a data type of integer.
LAB - Select horses with logical operators The Horse table has the following columns: • ID integer, primary key • RegisteredName - variable-length string • Breed - variable-length string • Height-decimal number • BirthDate - date Write a SELECT statement to select the registered name, height, and birth date for only horses that have a height between 15.0 and 16.0 (inclusive) or have a birth date on or after January 1, 2020.
The Horse table has the following columns: ID - integer, auto increment, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Delete the following rows: Horse with ID 5. All horses with breed Holsteiner or Paint. All horses born before March 13, 2013.
You have been instructed to add a new student information to the students table. Because the student is new, he has no marks before, you should not add an amount to the CGPA. The Students table contains these columns: Student_id NUMBER(10) Student_name VARCHAR2(30) Student phone NUMBER(10) CGPA NUMBER(2,2) Which INSERT statements will accomplish your objective? O a. INSERT INTO students VALUES (365, 'Khalil',99554721, 0 ) O b. INSERT INTO students VALUES (365, 'Khalil',99554721, 'NO CGPA' ) O c. INSERT INTO students VALUES (365, 'Khalil',99554721, NULL ) O d. INSERT INTO students VALUES (365, 'Khalil',99554721) Which line of code has an error? 1. CREATE TABLE FRUITS VEGETABLES 2. FRUIT TYPE VARCHAR2, 3. FRUIT NAME CHAR (20), 4. QUANTITY NUMBER (4)); O a. 1 O b. 2 O c. 3
Q11: After mapping the following ERD, choose the correct SQL statement that will insert a single row to the Vertebrates Table AID weight Vertebrates vertrebraLength Animal AName Disjoint ISA Invertebrates locations Eats amountPerDay type Food FID a. Insert into Vertebrates (VertebratesLength) values (1.5') b. Insert into Vertebrates (AID, AName, Weight) values (101', 'Salmon', '30') c. Insert into Vertebrates (AID, AName, Weight, VertebratesLength) values (101, 'Salmon', '30','1.5) d. Insert into Vertebrates (AID, Vertebrates Length) values (101', '1.5')
Database Q1: Which one of the following INSERT statements will successfully insert a single row? The following table has been created: CREATE TABLE student_table ( stud_id NUMBER (6), last_name VARCHAR2 (20), first_name VARCHAR2 (20), lunch_num NUMBER (4) ; a) INSERT VALUES INTO student_table (143354, ‘Roberts’, ‘Cameron’, 6543); b) INSERT INTO student_table COLMUNS (stud_id, last_name, lunch_num) VALUES (143352, ‘Roberts’, 5543, ‘Cameron’); c) INSERT TO student_table (stud_id, lunch_num, first_name, last_name) VALUES (143352, 6543, ‘Cameron’, ‘Roberts’); d) INSERT INTO student_table VALUES (143354, ‘Roberts’, ‘Cameron’, 6543); Q2: What does the following SQL statement display: SELECT EMP_ID, LAST_NAME, SALARY FROM EMPLOYEES WHERE SALARY > (SELECT MIN (E. SALARY) FROM EMPLOYEES E) ORDER BY SALARY DESC; a) Employees information who earn less money than the maximum salary b) Employees information who earn more money than the highest employee salary c) Employees information who earn…