Question 1

Which of the following is a valid table name?

Accepted Answer

A)  MYTABLE 
B)  DISTINCT 
C)  SELECT 
D)  CHAR 
A)  MYTABLE 
B)  DISTINCT 
C)  SELECT 
D)  CHAR

Question 2

_________________________ commands are used to create database objects.

Accepted Answer

DDL
Data d

Question 3

The DELETE TABLE command can be used to remove a table from a database.

Accepted Answer

A) True 
 B)False

Question 4

The INTERVAL datatype can be used to identify a specific interval, or amount, of time.

Accepted Answer

A) True 
 B)False

Question 5

A DATE column consists of ____________________ bytes.

Accepted Answer

The answer of A DATE column consists of ____________________ bytes....

Question 6

A column name can consist of up to 225 characters.

Accepted Answer

A) True 
 B)False

Question 7

The DROP UNUSED COLUMNS clause can be used with the ____________________ command to delete any column previously set as unused.

Accepted Answer

The answer of The DROP UNUSED COLUMNS clause can be...

Question 8

The $\underline {  \text { DELETE TABLE }  }$ command can be used to delete all the data stored in a table and release the storage space, yet retain the structure of the table. _________________________

Accepted Answer

A) True 
 B)False

Question 9

You cannot specify the width for a(n) $\underline { \text { NUMBER }   }$ column. _________________________

Accepted Answer

A) True 
 B)False

Question 10

Once a column has been set as UNUSED, which of the following is correct?

Accepted Answer

A)  It is unavailable and will not be displayed in the table structure. 
B)  It will still appear in the results of subqueries until it is dropped. 
C)  It is unavailable, but will still be displayed in the table structure. 
D)  All DDL operations can be performed on it until it is actually dropped. 
A)  It is unavailable and will not be displayed in the table structure. 
B)  It will still appear in the results of subqueries until it is dropped. 
C)  It is unavailable, but will still be displayed in the table structure. 
D)  All DDL operations can be performed on it until it is actually dropped.

Question 11

The default size of a VARCHAR2 column is one character.

Accepted Answer

A) True 
 B)False

Question 12

A column's ____________________ identifies the type of data that can be stored in a column.

Accepted Answer

The answer of A column's ____________________ identifies the type of...

Question 13

A table must contain a minimum of $\underline { \text { two } }$columns. _________________________

Accepted Answer

A) True 
 B)False

Question 14

If you are creating a new table containing four columns from an existing table and want to change the name of one of the columns when it is created in the new table, add a column list containing ____ names in the CREATE TABLE clause.

Accepted Answer

A)  one 
B)  four 
C)  five 
D)  zero 
A)  one 
B)  four 
C)  five 
D)  zero

Question 15

The ____________________ clause of the ALTER TABLE command can be used to change the size of a column.

Accepted Answer

The answer of The ____________________ clause of the ALTER TABLE...

Question 16

The ____________________ of a NUMBER column indicates the total number of digits that can be stored in the column.

Accepted Answer

The answer of The ____________________ of a NUMBER column indicates...

Question 17

The DROP COLUMN clause of the ALTER TABLE command can be used to drop a maximum of ____________________ column(s) at a time.

Accepted Answer

The answer of The DROP COLUMN clause of the ALTER...

Question 18

The ____________________ keyword must be used with the CREATE TABLE command if the table is being created from a subquery.

Accepted Answer

The answer of The ____________________ keyword must be used with...

Question 19

The maximum width of the NUMBER datatype is ____ digits.

Accepted Answer

A)  7 
B)  30 
C)  38 
D)  255 
A)  7 
B)  30 
C)  38 
D)  255

Question 20

What is the maximum width that can be assigned to a DATE column?

Accepted Answer

A)  1 
B)  8 
C)  12 
D)  none of the above 
A)  1 
B)  8 
C)  12 
D)  none of the above

Which of the following is a valid table name?

_________________________ commands are used to create database objects.

The DELETE TABLE command can be used to remove a table from a database.

The INTERVAL datatype can be used to identify a specific interval, or amount, of time.

A DATE column consists of ____________________ bytes.

A column name can consist of up to 225 characters.

The DROP UNUSED COLUMNS clause can be used with the ____________________ command to delete any column previously set as unused.

The $\underline { \text { DELETE TABLE } }$ command can be used to delete all the data stored in a table and release the storage space, yet retain the structure of the table. _________________________

You cannot specify the width for a(n) $\underline { \text { NUMBER } }$ column. _________________________

Once a column has been set as UNUSED, which of the following is correct?

The default size of a VARCHAR2 column is one character.

A column's ____________________ identifies the type of data that can be stored in a column.

A table must contain a minimum of $\underline { \text { two } }$ columns. _________________________

If you are creating a new table containing four columns from an existing table and want to change the name of one of the columns when it is created in the new table, add a column list containing ____ names in the CREATE TABLE clause.

The ____________________ clause of the ALTER TABLE command can be used to change the size of a column.

The ____________________ of a NUMBER column indicates the total number of digits that can be stored in the column.

The DROP COLUMN clause of the ALTER TABLE command can be used to drop a maximum of ____________________ column(s) at a time.

The ____________________ keyword must be used with the CREATE TABLE command if the table is being created from a subquery.

The maximum width of the NUMBER datatype is ____ digits.

What is the maximum width that can be assigned to a DATE column?

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

Which of the following is a valid table name?

_________________________ commands are used to create database objects.

The DELETE TABLE command can be used to remove a table from a database.

The INTERVAL datatype can be used to identify a specific interval, or amount, of time.

A DATE column consists of ____________________ bytes.

A column name can consist of up to 225 characters.

The DROP UNUSED COLUMNS clause can be used with the ____________________ command to delete any column previously set as unused.

The DELETE TABLE ‾\underline { \text { DELETE TABLE } } DELETE TABLE ​ command can be used to delete all the data stored in a table and release the storage space, yet retain the structure of the table. _________________________

You cannot specify the width for a(n) NUMBER ‾\underline { \text { NUMBER } } NUMBER ​ column. _________________________

Once a column has been set as UNUSED, which of the following is correct?

The default size of a VARCHAR2 column is one character.

A column's ____________________ identifies the type of data that can be stored in a column.

A table must contain a minimum of two ‾\underline { \text { two } } two ​ columns. _________________________

If you are creating a new table containing four columns from an existing table and want to change the name of one of the columns when it is created in the new table, add a column list containing ____ names in the CREATE TABLE clause.

The ____________________ clause of the ALTER TABLE command can be used to change the size of a column.

The ____________________ of a NUMBER column indicates the total number of digits that can be stored in the column.

The DROP COLUMN clause of the ALTER TABLE command can be used to drop a maximum of ____________________ column(s) at a time.

The ____________________ keyword must be used with the CREATE TABLE command if the table is being created from a subquery.

The maximum width of the NUMBER datatype is ____ digits.

What is the maximum width that can be assigned to a DATE column?

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 { DELETE TABLE } }$ command can be used to delete all the data stored in a table and release the storage space, yet retain the structure of the table. _________________________

You cannot specify the width for a(n) $\underline { \text { NUMBER } }$ column. _________________________

A table must contain a minimum of $\underline { \text { two } }$ columns. _________________________