Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Given the customer table and the data that it contains, and assuming that you have the rights to modify the table, which of the following

Given the customer table and the data that it contains, and assuming that you have the rights to modify the table, which of the following ALTER TABLE statements would create an error? a.) ALTER TABLE customer ALTER COLUMN state TYPE VARCHAR (100); b.) ALTER TABLE customer ALTER COLUMN postal_code TYPE VARCHAR (100); c.) ALTER TABLE customer ALTER COLUMN postal_code TYPE text; d.) ALTER TABLE customer ALTER COLUMN city TYPE INT;

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

Advances In Spatial Databases 2nd Symposium Ssd 91 Zurich Switzerland August 1991 Proceedings Lncs 525

Authors: Oliver Gunther ,Hans-Jorg Schek

1st Edition

3540544143, 978-3540544142

More Books

Students also viewed these Databases questions