Multiple Choice
Structure of the CUSTOMERS table
-Which of the following commands will increase the size of the CITY column in the CUSTOMERS table from 12 to 20 and increase size of the LASTNAME column from 10 to 14?
A) ALTER TABLE customers
MODIFY (city VARCHAR2(+8) ,lastname VARCHAR2(+4) ) ;
B) ALTER TABLE customers
MODIFY (city VARCHAR2(20) ,lastname VARCHAR2(14) ) ;
C) ALTER TABLE customers
MODIFY (city (+8) ,lastname (+4) ) ;
D) ALTER TABLE customers
MODIFY (city (20) ,lastname (14) ) ;
Correct Answer:

Verified
Correct Answer:
Verified
Q110: Which of the following symbols can be
Q111: The default format of a DATE column
Q112: A table name can be up to
Q113: Data<u> manipulation</u> language commands are used to
Q114: The maximum width of a NUMBER column
Q116: A DATE column consists of _ bytes.
Q117: The _ TABLE command can be used
Q118: The INTERVAL datatype can be used to
Q119: Once a column as been set as<u>
Q120: The CREATE TABLE cannot contain a subquery.