Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please do 1 part a, b ,c thank you I will make sure I give you a like Given the table create table T (A
please do 1 part a, b ,c thank you I will make sure I give you a like
Given the table create table T (A int primary key, Bint, Cint not null) Which of the following insert statements are valid? insert into T values(10, null, 30); insert into T(C, A) values (10.30); insert into T(B,A) values (10, 20); insert into T(B, C) values (10, 20); Question 2 5 What is the largest value that can inserted into a column defined a NUMERIC(6,1)? 0 999999.9 99999.9 9999.9 9999999 Given the tables create table T (A int primary key, B int); create table U (Cint primary key, A int, foreign key(A) references T(A)); Table T contains 100 rows and table U contains 200 rows. A common mistake made by students is to do a join and assuming the database will supply the join predicate. A student does the query SELECT T.A, T.B, U.C FROM T, U; The student does not get an error message but gets a large result set. How many rows are in the result set
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