Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started