Question: QUESTION 5 Consider the following incomplete SQL CREATE TABLE statement CREATE TABLE Person Name VARCHAR2(2), Date Of_Birth DATE, Phone Number [x] Height_in_CM NUMERIC(3) What is

QUESTION 5 Consider the following incomplete SQL CREATE TABLE statement CREATE TABLE Person Name VARCHAR2(2), Date Of_Birth DATE, Phone Number [x] Height_in_CM NUMERIC(3) What is an appropriate data data for Phone Number QUESTION 6 Consider the following SQL table: CREATE TABLE Tibble ColA VARCHAR2(4) NOT NULL ColB VARCHAR2(6) NOT NULL COIC NUMERIC(4), PRIMARY KEY (ColA) )i For each of the following SQL INSERT statements, fill in the blank with Y if the statement will work for the above table, and N if it will not work INSERT INTO Tibble (ColA, ColB, Colc) VALUES '12345', 123', 45) : INSERT INTO Tibble (COIA, COIB, COIC) VALUES ('1234', NULL, 45); : INSERT INTO Tibble (COIA, COIB, ColC) VALUES ('1234', NULL, NULL); : INSERT INTO Tibble (COIA, ColB, ColC) VALUES ('1234', '123., NULL); INSERT INTO Tibble (ColA, ColB, Colc) VALUES ('ValA', '123456', -1) : INSERT INTO Tibble (COIA, ColB, ColC) VALUES (.ColA', '123456', .1 / 3')
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
