Solved

Which of the Following Sql Commands Adds a New VARCHAR2

Question 46

Multiple Choice

Which of the following sql commands adds a new VARCHAR2 column of length 20 named new_column to table test?


A) ALTER TABLE test
ADD (new_column VARCHAR2(20) )
B) ADD column new_column VARCHAR2(20) to TABLE test
C) ADD to TABLE test (new_column VARCHAR2(20) )
D) ALTER TABLE test (new_column VARCHAR2(20) )

Correct Answer:

verifed

Verified

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

Related Questions

Q41: To view the column names and data

Q42: A(n)_ number contains a variable number of

Q43: The CHAR data types stores up to

Q44: A(n)_ constraint limits the value that can

Q45: Define the two basic categories of SQL

Q47: The Oracle DBMS stores columns of all

Q48: Which of the following is not a

Q49: Each SQL*Plus command is terminated with a(n)_.<br>A)period<br>B)semicolon<br>C)colon<br>D)exclamation

Q50: An Oracle error consists of a 3

Q51: Explain why it is a good idea