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:

Durbin-Watson Statistic

A statistical measure employed to identify autocorrelation within the residuals of a regression analysis.

Independence of Errors

An assumption in statistical models indicating that the error terms are not correlated with each other.

Durbin-Watson Test

A statistical test used to detect the presence of autocorrelation in the residuals from a regression analysis.

Negative Autocorrelation

A statistical property where a variable is inversely correlated with its own lagged values, implying that positive changes are likely followed by negative changes, and vice versa.