Question 1

A table name can be up to 30 characters in length.

Accepted Answer

A) True 
 B)False  True

Question 2

The ____________________ clause of the ALTER TABLE command can be used to delete a column from an existing table.

Accepted Answer

DROP COLUMN

Question 3

Which of the following is a valid SQL statement?

Accepted Answer

A)  CREATE TABLE newname (colA NUMBER, colB DAT
E) ; 
B)  CREATE TABLE newname as SELECT * FROM books; 
C)  CREATE TABLE newname (colA, col
B) ; 
D)  CREATE TABLE newname (colA DATE, colB VARCHAR2(3); 
A)  CREATE TABLE newname (colA NUMBER, colB DAT
E) ; 
B)  CREATE TABLE newname as SELECT * FROM books; 
C)  CREATE TABLE newname (colA, col
B) ; 
D)  CREATE TABLE newname (colA DATE, colB VARCHAR2(3); A

Question 4

Structure of the PROMOTION table
  
-Which of the following commands will set the MINRETAIL column of the PROMOTION table as unused?

Accepted Answer

A)  ALTER TABLE promotion SET UNUSED (minretail); 
B)  ALTER TABLE promotion SET minretail UNUSED; 
C)  ALTER TABLE promotion SET UNUSED COLUMN minretail; 
D)  both a and c 
A)  ALTER TABLE promotion SET UNUSED (minretail); 
B)  ALTER TABLE promotion SET minretail UNUSED; 
C)  ALTER TABLE promotion SET UNUSED COLUMN minretail; 
D)  both a and c

Question 5

A table name can contain a maximum of ____________________ characters.

Accepted Answer

The answer of A table name can contain a maximum...

Question 6

The $\underline {  \text { TRUNCATE TABLE }  }$ command can be used to delete a table from a database. _________________________

Accepted Answer

A) True 
 B)False

Question 7

Structure of the CUSTOMERS table
  
-Which of the following commands will change the name of the LASTNAME column to LAST_NAME in the CUSTOMERS table?

Accepted Answer

A)  ALTER TABLE customers MODIFY lastname to last_name; 
B)  ALTER TABLE customers CHANGE lastname to last_name; 
C)  ALTER TABLE customers MODIFY (lastname, last_name); 
D)  none of the above 
A)  ALTER TABLE customers MODIFY lastname to last_name; 
B)  ALTER TABLE customers CHANGE lastname to last_name; 
C)  ALTER TABLE customers MODIFY (lastname, last_name); 
D)  none of the above

Question 8

When using the ALTER TABLE...DROP COLUMN command, which of the following is not correct?

Accepted Answer

A)  The command's effect on the table is permanent. 
B)  You cannot delete the last remaining column in a table. 
C)  The command deletes both the column and its contents. 
D)  The command can be used to delete multiple columns from a table. 
A)  The command's effect on the table is permanent. 
B)  You cannot delete the last remaining column in a table. 
C)  The command deletes both the column and its contents. 
D)  The command can be used to delete multiple columns from a table.

Question 9

Which of the following datatypes refers to fixed-length character data, where n represents the maximum length of the column?

Accepted Answer

A)  CHAR(n) 
B)  VARCHAR(n) 
C)  VARCHAR2(n) 
D)  LONG 
A)  CHAR(n) 
B)  VARCHAR(n) 
C)  VARCHAR2(n) 
D)  LONG

Question 10

What is the problem associated with changing the name of a table?

Accepted Answer

If you change the name of a ta

Question 11

To retain the structure of a table, while deleting all its data and releasing their storage space, execute the TRUNC command.

Accepted Answer

A) True 
 B)False

Question 12

What is the difference between truncating a table and dropping a table?

Accepted Answer

When a table is truncated, the table str

Question 13

Once a column as been set as $\underline { \text { UNUSED }   }$ it cannot be recovered. _________________________

Accepted Answer

A) True 
 B)False

Question 14

Which of the following commands can be used to make structural changes to an existing table?

Accepted Answer

A)  MODIFY TABLE 
B)  ALTER TABLE 
C)  CHANGE TABLE 
D)  FIX TABLE 
A)  MODIFY TABLE 
B)  ALTER TABLE 
C)  CHANGE TABLE 
D)  FIX TABLE

Question 15

If you are creating a new table from data contained in an existing table, new column names can be specified by including a list of column names ____.

Accepted Answer

A)  before the AS clause 
B)  after the AS clause 
C)  in the subquery 
D)  after the subquery 
A)  before the AS clause 
B)  after the AS clause 
C)  in the subquery 
D)  after the subquery

Question 16

Which of the following is displayed by the DESCRIBE command?

Accepted Answer

A)  column names 
B)  not null requirements 
C)  datatypes 
D)  all of the above 
A)  column names 
B)  not null requirements 
C)  datatypes 
D)  all of the above

Question 17

When defining columns for a table, which of the following symbols is used to separate the column names in the column list?

Accepted Answer

A)  " " 
B)  , 
C)  ( ) 
D)  | | 
A)  " " 
B)  , 
C)  ( ) 
D)  | |

Question 18

A datatype identifies the type of data to be stored in a column.

Accepted Answer

A) True 
 B)False

Question 19

A table must have at least ____________________ column(s).

Accepted Answer

The answer of A table must have at least ____________________...

Question 20

The maximum width of a VARCHAR2 column is 2000 characters.

Accepted Answer

A) True 
 B)False

A table name can be up to 30 characters in length.

The ____________________ clause of the ALTER TABLE command can be used to delete a column from an existing table.

Which of the following is a valid SQL statement?

Structure of the PROMOTION table -Which of the following commands will set the MINRETAIL column of the PROMOTION table as unused?

A table name can contain a maximum of ____________________ characters.

The $\underline { \text { TRUNCATE TABLE } }$ command can be used to delete a table from a database. _________________________

Structure of the CUSTOMERS table -Which of the following commands will change the name of the LASTNAME column to LAST_NAME in the CUSTOMERS table?

When using the ALTER TABLE...DROP COLUMN command, which of the following is not correct?

Which of the following datatypes refers to fixed-length character data, where n represents the maximum length of the column?

What is the problem associated with changing the name of a table?

To retain the structure of a table, while deleting all its data and releasing their storage space, execute the TRUNC command.

What is the difference between truncating a table and dropping a table?

Once a column as been set as $\underline { \text { UNUSED } }$ it cannot be recovered. _________________________

Which of the following commands can be used to make structural changes to an existing table?

If you are creating a new table from data contained in an existing table, new column names can be specified by including a list of column names ____.

Which of the following is displayed by the DESCRIBE command?

When defining columns for a table, which of the following symbols is used to separate the column names in the column list?

A datatype identifies the type of data to be stored in a column.

A table must have at least ____________________ column(s).

The maximum width of a VARCHAR2 column is 2000 characters.

Overview of Database Concepts

Basic Sql Select Statements

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

Exam 3: Table Creation and Management

A table name can be up to 30 characters in length.

The ____________________ clause of the ALTER TABLE command can be used to delete a column from an existing table.

Which of the following is a valid SQL statement?

Structure of the PROMOTION table -Which of the following commands will set the MINRETAIL column of the PROMOTION table as unused?

A table name can contain a maximum of ____________________ characters.

The TRUNCATE TABLE ‾\underline { \text { TRUNCATE TABLE } } TRUNCATE TABLE ​ command can be used to delete a table from a database. _________________________

Structure of the CUSTOMERS table -Which of the following commands will change the name of the LASTNAME column to LAST_NAME in the CUSTOMERS table?

When using the ALTER TABLE...DROP COLUMN command, which of the following is not correct?

Which of the following datatypes refers to fixed-length character data, where n represents the maximum length of the column?

What is the problem associated with changing the name of a table?

To retain the structure of a table, while deleting all its data and releasing their storage space, execute the TRUNC command.

What is the difference between truncating a table and dropping a table?

Once a column as been set as UNUSED ‾\underline { \text { UNUSED } } UNUSED ​ it cannot be recovered. _________________________

Which of the following commands can be used to make structural changes to an existing table?

If you are creating a new table from data contained in an existing table, new column names can be specified by including a list of column names ____.

Which of the following is displayed by the DESCRIBE command?

When defining columns for a table, which of the following symbols is used to separate the column names in the column list?

A datatype identifies the type of data to be stored in a column.

A table must have at least ____________________ column(s).

The maximum width of a VARCHAR2 column is 2000 characters.

Overview of Database Concepts

Basic Sql Select Statements

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

The $\underline { \text { TRUNCATE TABLE } }$ command can be used to delete a table from a database. _________________________

Once a column as been set as $\underline { \text { UNUSED } }$ it cannot be recovered. _________________________