Question 1

The default format for a DATE column is ____________________.

Accepted Answer

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

Question 2

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

Accepted Answer

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

Question 3

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. 
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 4

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 
A)  DESC customers 
B)  DESCRIBE customers 
C)  DSC customers; 
D)  both a and b

Question 5

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 
A)  CREATE NEW TABLE 
B)  CREATE TABLE...FROM 
C)  CREATE TABLE 
D)  ALTER TABLE

Question 6

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

Accepted Answer

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

Question 7

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 
A)  ADD 
B)  MODIFY 
C)  CHANGE 
D)  RESET

Question 8

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: 
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 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

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. 
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 12

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 
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 13

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

Accepted Answer

A) True 
 B)False

Question 14

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) ; 
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 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

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

Question 17

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 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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 
A)  data definition 
B)  data format 
C)  datatype 
D)  data record

The default format for a DATE column is ____________________.

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

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

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

Which command instructs Oracle11g to create a new table?

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

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

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

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

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

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

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

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

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?

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

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

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.

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

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

A(n) ____ simply identifies the type of data that Oracle11g will be expected to store in a 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

The default format for a DATE column is ____________________.

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

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

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

Which command instructs Oracle11g to create a new table?

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

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

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

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

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

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

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

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

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?

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

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

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.

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

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

A(n) ____ simply identifies the type of data that Oracle11g will be expected to store in a 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

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

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