choice "6" 2 if choice "5": 3 print(choice) 4 elif choice "6": 5- try: sql - "*"INSERT INTO students(student_id, student_name, student Tastname, 7. 8. student email, student DOB, major_id) VALUES(?, 2, 2, ?, 2, ?)** input ("Enter a student ID: ") stud id stud name input ("Enter a name: ") stud lastname - input ("Enter Last name: ") stud email - input("Enter email address: ") stud DOB - input ("Enter DOB 1n (MM-DD-YYYY) format: ") 9. 10 11 12 13 14 cursor.execute(sql, (stud id, stud_name, stud_lastname, stud email, stud DOB, 206)) 15 A 16 A17 cursor.execute(sql, (23593043, "Greg", "Moyers", "gmeyers@test.com", "06-10-1997, 206)) cursor.commit() 18 19 20- еxcept: print("Try again") 21

choice "6" 2 if choice "5": 3 print(choice) 4 elif choice "6": 5- try: sql - "*"INSERT INTO students(student_id, student_name, student Tastname, 7. 8. student email, student DOB, major_id) VALUES(?, 2, 2, ?, 2, ?)** input ("Enter a student ID: ") stud id stud name input ("Enter a name: ") stud lastname - input ("Enter Last name: ") stud email - input("Enter email address: ") stud DOB - input ("Enter DOB 1n (MM-DD-YYYY) format: ") 9. 10 11 12 13 14 cursor.execute(sql, (stud id, stud_name, stud_lastname, stud email, stud DOB, 206)) 15 A 16 A17 cursor.execute(sql, (23593043, "Greg", "Moyers", "gmeyers@test.com", "06-10-1997, 206)) cursor.commit() 18 19 20- еxcept: print("Try again") 21

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter4: Constraints

Section: Chapter Questions

Problem 3MC: Which of the following SQL statements is invalid and returns an error message? ALTER TABLE books ADD...

See similar textbooks

Similar questions

In The SQL Oracle Application Using the UNION operator, write a query that displays the employee_id, job_id, and salary of ALL present and past employees. If a salary is not found, then just display a 0 (zero) in its place.
Below is part of a Student database. The primary keys are highlighted in bold. Student (studNo, studName, address, mobileNo) Registration (studNo, courseNo, regDate, semester, session) Course (courseNo, courseName, creditHour, level) Project (projNo, projName, courseNo) QUESTION : 1. Write a PL/SQL PROCEDURE that will list the project names given the course ID. 2. Call the procedure from an anonymous block. Allow the user to enter the course ID (courseno)
Which of the following SQL statements is invalid and returns an error message? ALTER TABLE books ADD CONSTRAINT books_pubid_uk UNIQUE (pubid); ALTER TABLE books ADD CONSTRAINT books_pubid_pk PRIMARY KEY (pubid); ALTER TABLE books ADD CONSTRAINT books_pubid_nn NOT NULL (pubid); ALTER TABLE books ADD CONSTRAINT books_pubid_fk FOREIGN KEY (pubid) REFERENCES publisher (pubid); All of the above statements are invalid.
the following code is all part of a mockup "student information management system", with its purpose being making mockup new student accounts.1) combine the code into a small executable project called simulation.student2) Using dbeaver, Please use the following attached sql commands and make the tables shown below, populated with the appropriate dataSCREENSHOT EACH TABLE WITH THE DATA INSERTED INTO IT code:UndergraduateStudent.java //package Lab2; public class UndergraduateStudent extends Student{public static final double UNDERGRAD_TUITION = 4000;public UndergraduateStudent( int pID, String pName, StudentClassification eStudent ){super( pID, pName, eStudent );setTuition();}public void setTuition(){tuition = UNDERGRAD_TUITION;}} StudentDemo2.java import java.util.ArrayList; public class StudentDemo2{public static void main(String[] args){ArrayList<Student> students = new ArrayList<Student>();students.add( new UndergraduateStudent(111, "Lambert",…
in sql The EMPLOYEE table contains these columns: EMP_ID NOT NULL, Primary Key SSNUM NOT NULL, Unique LAST_NAME VARCHAR2(25) FIRST_NAME VARCHAR2(25) DEPT_ID NUMBER Foreign Key to DEPT_ID column of the DEPARTMENT table SALARY NUMBER(8,2). You execute this statement:CREATE INDEX emp_name_idx ON employee(last_name, first_name); Which statement is true? Select one: a. The statement creates a composite non-unique index b. The statement creates a composite unique index. c. The statement creates a function-based index. d. The statement fails because of a syntax error.
In the SQL Oracle Application Write one query to return the employee_id, job_id, hire_date, and department_id of all employees and a second query listing employee_id, job_id, start_date, and department_id from the job_history table and combine the results as one single output. Make sure you suppress duplicates in the output.
In SQL Server, describe the distinction between the two data types for the characters as follows: NVARCHAR NVARCHAR NVARCHAR
Database: CUSTOMER (CustomerID, LastName, FIrstName, Phone, EmailAddress) PURCHASE (InvoiceNumber, InvoiceDate, PreTaxAmount, CustomerID) PURCHASE_ITEM (InvoiceNumber, InvoiceLineNumber, Item Number, RetailPrice) ITEM (ItemNumber, ItemDesciption, Cost, ArtistLastName, ArtistFirstName) Write an SQL statement to show which cutomers bought which items, and include any items that have not been sold. Include CUSTOMER.LastName, CUSTOMER.FirstName, IvoiceNumber, InvoiceDate, ItemNumber, ItemDescription, ArtistLastName, and ArtistFirstName,. Use a join using JOIN ON syntax, and sort the results by ArtistLastName and ArtistFirstName in ascending order. Note that in Microsoft Access this require multiple queries. From Database Concepts 9th Ed. (Kroenke)
Write the following SQL Statements:1. Write a SELECT statement that returns one row for each customer that has orders with these columns:->The email_address from the Customers table->A count of the number of orders->The total amount for each order (Hint: First, subtract the discount amount from the price. Then, multiply by the quantity.)->Return only those rows where the customer has more than 1 order.->Sort the result set in descending sequence by the sum of the line item amounts. Q2 7. Write a SELECT statement that returns the name and discount percent of each product that has a unique discount percent. In other words, don’t include products that have the same discount percent as another product.
Write an SQL statement that will insert an order in the orders table with the following data: cutomerID=3, orderDate = current date, shipAmount=20, taxAmount=23.56, shipDate=a week after current date, shipAddressID=3, cardType=2, cardNumber=4123123412341234, cardExpires=05/2024, billingAddressID=3 Write an SQL statement to delete all orders that are created between 2017-06-01 and 2017-06-07.
The relationship between CUSTOMER and ORDER is one-to-many. CUSTOMER table has 5 records and ORDER has 15. How many records you will get in the output if you run the following SQL statement? SELECT Customers.CustomerID, Orders.OrderIDFROM Customers, Orders; 5 15 20 75
On a SQL terminal for (e.g., sqlite3) someone type the following:select ‘456’;What is expected as a result?(a) A number 456(b) An error message indicating that the command is not valid(c) A relation with one cell having the value ‘456’(d) Nothing will happen.