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:

Mineral-Based

Refers to substances or products derived from minerals, often used in context with lubricants, coolants, or other industrial fluids.

Transmission Lubricant

A type of fluid that is specifically designed to lubricate the gears, bearings, and other components within a vehicle's transmission.

Oil Change Interval

The recommended distance or time period between oil changes for a vehicle or machinery, ensuring optimal performance and longevity of the engine.

Air Filter Element

The replaceable component of an air filter that traps and removes particulate matter from the air entering an engine.