Question 1

Which of the following keywords can be used to change the size, datatype, and/or default value of an existing column?

Accepted Answer

A)   ADD
B)   MODIFY
C)   CHANGE
D)   RESET

Question 2

Which of the following symbols can be used in a column name?

Accepted Answer

A)   %
B)   *
C)   #
D)   '

Question 3

SELECT9 $\underline {  is  }$ a valid table name. _________________________

Accepted Answer

A) True 
 B)False

Question 4

Which of the following commands will drop any columns marked as unused from the TABLEA table?

Accepted Answer

A)   DROP COLUMN FROM tablea WHERE column_status = UNUSED;
B)   ALTER TABLE tablea DROP UNUSED COLUMNS;
C)   ALTER TABLE tablea DROP (unused) ;
D)   DROP UNUSED COLUMNS:

Question 5

A table name must begin with a(n) $\underline { \text { number. }  }$_________________________

Accepted Answer

A) True 
 B)False

Question 6

A(n)  ____ simply identifies the type of data that Oracle11g will be expected to store in a column.

Accepted Answer

A)   data definition
B)   data format
C)   datatype
D)   data record

Question 7

Structure of the CUSTOMERS table
 
-Which of the following commands will display the structure of the CUSTOMERS table?

Accepted Answer

A)   DESC customers
B)   DESCRIBE customers
C)   DSC customers;
D)   both a and b

Question 8

The ____________________ command is used to display the structure of a table.

Accepted Answer

The answer of The ____________________ command is used to display...

Question 9

Which command instructs Oracle11g to create a new table?

Accepted Answer

A)   CREATE NEW TABLE
B)   CREATE TABLE...FROM
C)   CREATE TABLE
D)   ALTER TABLE

Question 10

When creating a table, which of the following statements is correct?

Accepted Answer

A)   The schema of the table must be explicitly stated.
B)   A user can have two tables with the same name, as long as the column names are different.
C)   The column list must be enclosed in parentheses ( ) .
D)   Default values cannot be assigned to all columns in a table.

Question 11

Structure of the CUSTOMERS table
 
-Which of the following commands will add a new column named FIRSTORDERDATE to the CUSTOMERS table to store the date that the customer first placed an order with the company?

Accepted Answer

A)   CREATE COLUMN firstorderdate, DATE TO customers;
B)   ALTER TABLE customers ADD COLUMN firstorderdate DATE;
C)   ALTER TABLE customers ADD firstorderdate DATE;
D)   ALTER TABLE customers ADD (firstorderdate DAT
E)  ;

Question 12

The ____________________ TABLE command can be used to delete and release the storage space of all data contained in a database table, while still retaining the table's structure.

Accepted Answer

The answer of The ____________________ TABLE command can be used...

Question 13

The column list of the CREATE TABLE command must be enclosed in ____________________.

Accepted Answer

The answer of The column list of the CREATE TABLE...

Question 14

When modifying data in existing columns, which of the following is correct?

Accepted Answer

A)   A column must be as wide as the data it already contains.
B)   If a NUMBER column already contains data, its precision and scale can be decreased.
C)   Changing the default value of a column will change the values of data already in a table.
D)   If a NUMBER column is empty, its precision and scale cannot be changed.

Question 15

Only one column can be added to an existing table at one time.

Accepted Answer

A) True 
 B)False

Question 16

The ALTER TABLE name can be used to rename a table.

Accepted Answer

A) True 
 B)False

Question 17

The MODIFY TABLE command can be used to change the size of a table.

Accepted Answer

A) True 
 B)False

Question 18

The default format for a DATE column is ____________________.

Accepted Answer

The answer of The default format for a DATE column...

Question 19

Which of the following is a valid table name in Oracle11g?

Accepted Answer

A)   jimm8 Y%c _5_H76ang
B)   S_c#oT#2t_321sM#_i_T6h
C)   2LaN_n23_es#M#m
D)   mAU$reE78_&_n1

Question 20

The ____________________ command can be used to modify the structure of a table.

Accepted Answer

The answer of The ____________________ command can be used to...

Exam 3: Table Creation and Management

Which of the following keywords can be used to change the size, datatype, and/or default value of an existing column?

Correct AnswerverifiedShow Answer

Structure of the CUSTOMERS table -Which of the following commands will display the structure of the CUSTOMERS table?

Correct AnswerverifiedShow Answer

A table name must begin with a(n) number. ‾\underline { \text { number. } } number. ​ _________________________

Correct AnswerverifiedShow Answer

The ____________________ command is used to display the structure of a table.

Correct AnswerverifiedShow Answer

When modifying data in existing columns, which of the following is correct?

Correct AnswerverifiedShow Answer

Only one column can be added to an existing table at one time.

Correct AnswerverifiedShow Answer

Which command instructs Oracle11g to create a new table?

Correct AnswerverifiedShow Answer

The default format for a DATE column is ____________________.

Correct AnswerverifiedShow Answer

SELECT9 is‾\underline { is }is​ a valid table name. _________________________

Correct AnswerverifiedShow Answer

A(n) ____ simply identifies the type of data that Oracle11g will be expected to store in a column.

Correct AnswerverifiedShow Answer

Which of the following is a valid table name in Oracle11g?

Correct AnswerverifiedShow Answer

The ALTER TABLE name can be used to rename a table.

Correct AnswerverifiedShow Answer

Structure of the CUSTOMERS table -Which of the following commands will add a new column named FIRSTORDERDATE to the CUSTOMERS table to store the date that the customer first placed an order with the company?

Correct AnswerverifiedShow Answer

Which of the following symbols can be used in a column name?

Correct AnswerverifiedShow Answer

The MODIFY TABLE command can be used to change the size of a table.

Correct AnswerverifiedShow Answer

The ____________________ TABLE command can be used to delete and release the storage space of all data contained in a database table, while still retaining the table's structure.

Correct AnswerverifiedShow Answer

The column list of the CREATE TABLE command must be enclosed in ____________________.

Correct AnswerverifiedShow Answer

When creating a table, which of the following statements is correct?

Correct AnswerverifiedShow Answer

Which of the following commands will drop any columns marked as unused from the TABLEA table?

Correct AnswerverifiedShow Answer

The ____________________ command can be used to modify the structure of a table.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

A table name must begin with a(n) $\underline { \text { number. } }$ _________________________

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

SELECT9 $\underline { is }$ a valid table name. _________________________

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified