Which among the following is the correct query to drop a column Budget in Expenses table?O a. Drop column Budget;O b. Alter table Expenses delete column Budget;1O c. Alter table Expenses drop column Budget;O d. Drop Budget;What is the appropriate datatype for the column Birthdate in Family table?a. Dateb. DecimalO c. NumberO d. IntegerTo change the weight column value to 25 in Data table for the person with id 112, which command willexecute correctly?O a. Update table Data set weight=25 where personid=112;3.b. Update table Data set personid =112 where weight =25 ;O c. Update Data weight =25;O d. Update Data set weight =25 where personid =112;

Here have to determine correct option for given sql problem.

Which among the following is the correct query to drop a column Budget in Expenses table? O a. Drop column Budget; O b. Alter table Expenses delete column Budget; O c. Alter table Expenses drop column Budget; O d. Drop Budget; What is the appropriate datatype for the column Birthdate in Family table? a. Date O b. Decimal O c. Number O d. Integer To change the weight column value to 25 in Data table for the person with id 112 , which command will execute correctly? O a. Update table Data set weight=25 where personid=112; O b. Update table Data set personid =112 where weight =25 ; O . Update Data weight =25; O d. Update Data set weight =25 where personid =112;

Which among the following is the correct query to drop a column Budget in Expenses table? O a. Drop column Budget; O b. Alter table Expenses delete column Budget; O c. Alter table Expenses drop column Budget; O d. Drop Budget; What is the appropriate datatype for the column Birthdate in Family table? a. Date O b. Decimal O c. Number O d. Integer To change the weight column value to 25 in Data table for the person with id 112 , which command will execute correctly? O a. Update table Data set weight=25 where personid=112; O b. Update table Data set personid =112 where weight =25 ; O . Update Data weight =25; O d. Update Data set weight =25 where personid =112;

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter4: Constraints

Section: Chapter Questions

Problem 10MC

See similar textbooks

Similar questions

Which of the following is a valid table name? a. 9NEWTABLE b. DATE9 c. NEWTABLE d. None of the above are valid table names.
In the query below, what is the difference between INTEGER ad INTEGER(15)? Why is it used? CREATE TABLE Worker ( WORKER_ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, FIRST_NAME TEXT, LAST_NAME TEXT, SALARY INTEGER(15), JOINING_DATE DATETIME, DEPARTMENT CHAR(25));
Which query will use the given columns from the PRODUCT table to determine the total value of inventory held on hand? P_QOH = quantity on hand P_PRICE = price a. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH/P_PRICE FROM PRODUCT; b. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH=P_PRICE FROM PRODUCT; c. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH-P_PRICE FROM PRODUCT; d. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH*P_PRICE FROM PRODUCT;
Add two columns to the EMPLOYEES table. One column, named EmpDate, contains thedate of employment for each employee, and its default value should be the system date. Thesecond column, named EndDate, contains employees’ date of termination. When I put this formal it says, line 2 has invalid identifier! Can you help me what I need to fix from line 2? alter table EMPLOYEES2add column EmpDate date = getdate(),add column EndDate;
Q. Write a query to return first, last, email of employees in my_contacts Q. Write a query to return list of everyone who lives in the same zip code as the person with the highest current salary.
Write a T-SQL query to display the emp code, emp lname, employee job code, from the employee table joining the job table where the employee job code equals the job table job code. Order the output by employee job code. Copy and paste the query and the output into your assignment document. (hint: use table aliases) /* Created with SQL Script Builder v.1.5 */ /* Type of SQL : SQL Server */ CREATE TABLE EMPLOYEE ( EMP_CODE int, EMP_TITLE varchar(4), EMP_LNAME varchar(15), EMP_FNAME varchar(15), EMP_INITIAL varchar(1), EMP_DOB datetime, JOB_CODE varchar(5), STORE_CODE int ); INSERT INTO EMPLOYEE VALUES('1','Mr.','Williamson','John','W','5/21/1964','SEC','3'); INSERT INTO EMPLOYEE VALUES('2','Ms.','Ratula','Nancy','','2/9/1969','MGR','2'); INSERT INTO EMPLOYEE VALUES('3','Ms.','Greenboro','Lottie','R','10/2/1961','GEN','4'); INSERT INTO EMPLOYEE VALUES('4','Mrs.','Rumpersfro','Jennie','S','6/1/1971','GEN','5'); INSERT INTO EMPLOYEE…
1. Write a query to display customer name, product and category with prices between 5 and 25 (without using between), save as q1. 2. Write a query to remove duplicate values from the category column of the customer table, save as q2. 3. Write a query to arrange the product price in descending order, save as q3.
Please assist to fix the query below: use SQLBook; WITH oz as (SELECT zc.zcta5,(COUNT(DISTINCT c.HouseholdId) /MAX(zc.tothhs*1.0) ) as penetration,zc.tothhs, zc.medianhhinc, zc.pctbachelorsormore),ozm as (SELECT AVG(medianhhinc) as avgmedianhhinc,STDEV(medianhhinc) as stdmedianhhinc,AVG(pctbachelorsormore) as avgpctbachelorsormore,STDEV(pctbachelorsormore) as stdpctbachelorsormoreFROM oz),ozs as (SELECT oz.*,((oz.medianhhinc - ozm.avgmedianhhinc) / ozm.stdmedianhhinc) as z_medianhhinc,((oz.pctbachelorsormore - ozm.avgpctbachelorsormore) /ozm.stdpctbachelorsormore) as z_pctbachelorsormoreFROM oz CROSS JOIN ozm)SELECT TOP 10 ozs,*,SQRT(SQUARE(ozs.z_medianhhinc - ozs10021.z_medianhhinc) +SQUARE(ozs.z_pctbachelorsormore –ozs10021.z_pctbachelorsormore)) as distFROM ozs CROSS JOIN(SELECT ozs.* FROM ozs WHERE ozs.zcta5 = '10021') ozs10021ORDER BY dist ASC
SQL: Start with the Employee table used in Lab 4. CREATE TABLE Employee ( EMPLOYEE_ID INT NOT NULL, FIRST_NAME CHAR(20), LAST_NAME CHAR(20), JOB_LEVEL INT, SALARY BIGINT, COMMISSION_PCT INT, CONSTRAINT PKEmployeeID PRIMARY KEY (EMPLOYEE_ID) ); INSERT INTO Employee VALUES (100,'Steven','King',1,50000,10), (101,'Neena','Kochhar',1,50000,10), (102,'Lex','De Haan',2,60000 ,15), (103,'Alexander','Hunold',2,60000,15), (104,'Bruce','Ernst',3,70000,25), (105,'Johann','Ernst',4,75000,30); Create another table. CREATE TABLE NumEmployeesByLastName ( LastName CHAR(20), NumEmployees INT ); a. Write a query to initialize the NumEmployeesByLastName table by inserting one row for each last name already in the Employee table, and having the accurate count of the number of employees having that last name. Assume that there are no null values in the Employee table. After your query, if you execute the following query, you would…
Select all columns from the jobs table using an asterisk.2. Select only job title, min salary, and max salary columns from the jobs table.3. Select all columns from the d_partners table by writing out all of the columns inthe select statement.4. Using the d_partners table, display the id, and then concatenate the first_nameand last_name together with a space in between the two columns. Give theconcatenated column an alias of NAME. Be sure to use the optional ASkeyword.5. Using the job_grades table, show the grade level, and then subtract thelowest_sal from the highest_sal to show the amount of variance there is for eachgrade level. Give the calculated column an alias of Salary_Variance. Do notuse the optional AS keyword.6. Using the employees table, show an unduplicated list of department_id’s.7. Change the SELECT statement you built for question 4, adding a single columncalled Partner_Information that concatenates the partner’s expertise,auth_expense_amt, and manager_ id, so the…
Please match the keyword or operator from the list below to its correct SQL explanation and syntax in the table. Replace ? with a correct option from the following list: Right outer join, UNION, Left outer join, Cartesian product, Inner join, Full outer join Keyword/Operator Explanation Syntax ? Combine tables vertically SELECT * FROM <table 1> UNION SELECT * FROM <table 2>; ? Produces all possible combinations of rows from the two tables SELECT * FROM <table name 1>, <table name 2>; ? Only matching rows are returned SELECT * FROM <table name 1>, <table name 2> WHERE <join condition> <AND other conditions> <other CLAUSES>; SELECT * FROM <table name 1> INNER JOIN <table name 2> ON join-condition <other clauses>; ? Includes all rows from the left table and inserts NA for non-matching rows SELECT * FROM <table name 1> LEFT JOIN <table name 2> ON <join…
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…