Structure of the CUSTOMERS Table

question 115

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));

---

Definitions:

Take Initiative

The act of taking the first step or move in a situation without waiting for others to act.

Shared Ownership

A form of property ownership where multiple parties hold rights to use or possess property, often seen in businesses and real estate.

Tight Control

A management approach that relies on closely monitoring and controlling organizational activities and processes.

Production-Centred

Focused or centered around the production or manufacturing process within an organization.