Solved

Structure of the CUSTOMERS Table

Question 115

Multiple Choice

Structure of the CUSTOMERS table
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) ) ;
-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:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions