Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Data Management Databases And Organizations

Authors: Richard T. Watson

6th Edition

1943153035, 978-1943153039

More Books

Students also viewed these Databases questions