Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions