Database https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all Lab 3Q1. Create the following tables:A. CarrierAttribute nameSizeConstraintТуреVarchar2Varchar2Varchar2Varchar2Primary keyNOT NULLcarrierID10carrierName100PhoneRange50LIKE +966%'30Value is either"International' or"Local'B. ReviewAttribute nameReviewIDТуреSizeConstraintPrimary keyNOT NULLINTStarsINTCommentNameCustomerIDVarchar270Default 'UserForeign keyreferences customersVarchar250INTProductIDINT

Question 1) Crate table queries The "CREATE TABLE" command is used in sql to create table in a…

Lab 3 Q1. Create the following tables: A. Carrier Attribute name carrierID Туре Varchar2 Size Constraint Primary key NOT NULL LIKE +966%' Value is either "International' or "Local' 10 carrierName Varchar2 100 Phone Varchar2 Varchar2 50 Range 30 B. Review Attribute name ReviewID Constraint Primary key NOT NULL Туре Size INT Stars INT Comment Varchar2 70 Name Varchar2 50 Default 'User' Foreign key references customers CustomerID INT ProductID INT

Lab 3 Q1. Create the following tables: A. Carrier Attribute name carrierID Туре Varchar2 Size Constraint Primary key NOT NULL LIKE +966%' Value is either "International' or "Local' 10 carrierName Varchar2 100 Phone Varchar2 Varchar2 50 Range 30 B. Review Attribute name ReviewID Constraint Primary key NOT NULL Туре Size INT Stars INT Comment Varchar2 70 Name Varchar2 50 Default 'User' Foreign key references customers CustomerID INT ProductID INT

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter4: Constraints

Section: Chapter Questions

Problem 15MC: Which of the following data dictionary objects should be used to view information about the...

See similar textbooks

Similar questions

Which of the following statements deletes all rows in the HOMEWORK10 table? a. DELETE FROM homework10; b. DELETE . FROM homework10; c. DELETE FROM homework10; d. DELETE FROM homework10 WHERE amid = ; e. Both c and d delete all rows in the HOMEWORK10 table.
Which of the following is a correct statement? a. A commit is issued implicitly when a user exits SQL Developer or SQLPlus. b. A commit is issued implicitly when a DDL command is executed. c. A commit is issued automatically when a DML command is executed. d. All of the above are correct. e. Both a and b are correct. f. Both a and c are correct.
Which object in the data dictionary enables you to verify DEFAULT column settings? DEFAULT_COLUMNS DEF_TAB_COLUMNS USER_TAB_COLUMNS None of the above
Which of the following data dictionary objects should be used to view information about the constraints in a database? USER_TABLES USER_RULES USER_COLUMNS USER_CONSTRAINTS None of the above objects should be used.
Write, but do not execute, the commands to grant the following privileges: a. User Ashton must be able to retrieve data from the ITEM table. b. Users Kelly and Morgan must be able to add new orders and order lines. c. User James must be able to change the price for all items. d. User Danielson must be able to delete customers. e. All users must be able to retrieve each customers number, name, street, city, state,and postal code. f. f User Pere7 must be able to create an index on the ORDFRS table. g. User Washington must be able to change the structure of the ITEM table. h. User Grinstead must have all privileges on the ORDERS table.
Create table Medicine (MInventory_Id int primary key, M_Name varchar (40), Manufacturer varchar (40), Price varchar (20), Quantity int, Exp_Date date); Create table PrescriptionMedicine (Prescription_Id int primary key, MInventory_Id int); Example of a table (Medicine) Insert into Medicine values(101, ‘Biaxin’, ‘Pfizers’, ‘$10.99’, 1, 10/5/02); Insert into Medicine
Create a stored procedure named sp_ListBookDetails().CREATE OR REPLACE PROCEDURE sp_ListBookDetails(in_ISBN IN INTEGER)AStemp_BookTitle VARCHAR2(250);temp_BookDescription VARCHAR(250);temp_BookPrice NUMBER(12,2);temp_BookReviews INTEGER;temp_UserRating NUMBER(12,2);temp_BookCategoryID INTEGER;BEGINSELECT Book_Title ,Book_Description,Book_Price,Book_Reviews,User_Rating,Book_Category_IDINTO temp_BookTitle,temp_BookDescription,temp_BookPrice,temp_BookReviews,temp_UserRating,temp_BookCategoryIDFROM HOL_BOOKSWHERE ISBN = in_ISBN;-- Output the resultsDBMS_Output.Put_Line('---------------------------------------------');DBMS_Output.Put_Line('Here are the details for ISBN ' || in_ISBN);DBMS_Output.Put_Line('');DBMS_Output.Put_Line('Book Title: ' || temp_BookTitle);DBMS_Output.Put_Line('Book Description: ' || temp_BookDescription);DBMS_Output.Put_Line('Book Price: ' || temp_BookPrice);DBMS_Output.Put_Line('Book Reviews: ' || temp_BookReviews);DBMS_Output.Put_Line('Book User Rating: ' ||…
Create a trigger that will prefix the values of item category with ‘dev-‘ when a new row insinserted. For example if the inserted category is ‘rdf’ then then the value should become ‘devrdf’. Below is the item tableCREATE TABLE Item (ItemID NUMBER PRIMARY KEY, category VARCHAR2(12)); Write in SQL
The PatientDim table contains columns. PatientEpicId and name. Use the following query to answer the questions below it: SELECT PatientEpicID Name FROM PatientDim What does this query return? select one of the following: A. Nothing because the query won't run.B. The column PatientEpicId and name from the table PatientDimC. The PatientEpicID column from the table PatientDim, with an alias of name.D. The name column from the table PatientDim, with an alias of PatientEpicId
Assume you have these table CREATE TABLE Student (studid Char(9) Primary Key,FirstName Varchar2(50) NOT NULL,LastName Varchar2(50) NOT NULL,Email Varchar2(50) NOT NULL UNIQUE,PhoneNumber Number(8) NOT NULL UNIQUE,DateOfBirth Date NOT NULL,GPA Number(1,2) NOT NULL); CREATE TABLE Club (clubID Number(3) Primary Key,ClubName Varchar2(20) NOT NULL,studid Char(9) NOT NULL UNIQUE, Foreign key(studid) references Student(studid)); CREATE TABLE MemberOf (ClubID Number(3) Primary Key, Studid char(9), JoiningDate date, Foreign Key(ClubID) references club(clubID), Foreign Key(Studid) references Student(studid)); CREATE TABLE Activities (Actid Number(3) Primary Key,Acdt DATE NOT NULL,Place Varchar2(50) NOT NULL,durationNbHour Number NOT NULL); CREATE TABLE Organize (actid Number(3) Primary Key, clubID Number(3), Fee Number(4,2), Foreign Key(actid) references Activities(Actid),Foreign Key(clubID) references MemberOf(ClubID)); Write in SQL queries to populate the above tables by inserting minimum 4…
Assuming the HOMEWORK10 table has three columns (Col1, Col2, and Col3, in this order), which of the following commands stores a NULL value in Col3 of the HOMEWORK10 table?a. INSERT INTO homework10 VALUES (‘A’, ‘B’, ‘C’);b. INSERT INTO homework10 (col3, col1, col2) VALUES (NULL, ‘A’, ‘B’);c. INSERT INTO homework10 VALUES (NULL, ‘A’, ‘B’);d. UPDATE homework10 SET col1 = col3;
CREATE TABLE MOVIE( mov_id int NOT NULL, mov_title varchar(255) NOT NULL, mov_releaseDate date, gen_id int NOT NULL, PRIMARY KEY (mov_id), FOREIGN KEY (gen_id) REFERENCES GENRE(gen_id) ); CREATE TABLE GENRE( gen_id int NOT NULL, PRIMARY KEY (gen_id), gen_name varchar(255) NOT NULL ); Search movies by year. Using the tables above, create a stored procedure, called getMovieByYear, that, given a year, returns all the movies which were released in that year. It displays the movie title, movie’s genre name, and release year.please use MySQL Workbench with screenshots of it for the explanation.