In the following exercises, you will use the data in the JC Consulting database. Dont forget to

Question:

In the following exercises, you will use the data in the JC Consulting database. Don’t forget to use a copy of the JC Consulting database so any changes you make will not affect future modules.


Which SQL command would add a new field named Region to the Clients table?

a. ALTER TABLE Clients ADD Region TEXT(20)

b. ALTER TABLE Clients MODIFY Region TEXT(20)

c. MODIFY TABLE Clients ADD Region TEXT(20)

d. MODIFY TABLE Clients MODIFY Region TEXT(20)

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Concepts Of Database Management

ISBN: 9780357422083

10th Edition

Authors: Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt

Question Posted: