Question 1

The default size of a VARCHAR2 column is one character.​

Accepted Answer

A) True 
 B)False

Question 2

​Which of the following is a valid table name in Oracle 12c?

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 3

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

Accepted Answer

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

Question 4

The MODIFY clause can be included in the ALTER TABLE command to add a default value to an existing column._________________________

Accepted Answer

A) True 
 B)False

Question 5

_________________________ commands are used to create database objects.

Accepted Answer

DDL
Data d

Question 6

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

Accepted Answer

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

Question 7

Once a table is ____________________,any associated indexes will be removed from the database.

Accepted Answer

The answer of Once a table is ____________________,any associated indexes...

Question 8

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 9

Structure of the CUSTOMERS table
   ​
-Which of the following commands will add a new column named FIRST ORDER DATE 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 10

The CHAR datatype is used to store variable-length data that can consist of letters and numbers._________________________​

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

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

Question 12

​The ALPHANUMERIC datatype can be used to store characters and numbers to a maximum width of 2000.

Accepted Answer

A) True 
 B)False

Question 13

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 14

The default size of the CHAR column is 2._________________________​

Accepted Answer

A) True 
 B)False

Question 15

SELECT9 is a valid table name._________________________​

Accepted Answer

A) True 
 B)False

Question 16

Which of the following keywords is used to remove a database table in Oracle 12c?​

Accepted Answer

A)  ​DROP TABLE 
B)  ​ALTER TABLE...DROP 
C)  ​DELETE TABLE 
D)  ​TRUNCATE TABLE 
A)  ​DROP TABLE 
B)  ​ALTER TABLE...DROP 
C)  ​DELETE TABLE 
D)  ​TRUNCATE TABLE

Question 17

Which of the following rules apply to table names in Oracle 12c?​

Accepted Answer

A)  ​Names can contain blank spaces. 
B)  ​Names can be up to 225 characters in length. 
C)  ​Names can begin with a number. 
D)  ​Names can contain a number sign (#). 
A)  ​Names can contain blank spaces. 
B)  ​Names can be up to 225 characters in length. 
C)  ​Names can begin with a number. 
D)  ​Names can contain a number sign (#).

Question 18

Which of the following keywords cannot be used to modify an existing table?​

Accepted Answer

A)  ​ALTER TABLE...ADD 
B)  ​ALTER TABLE...DROP COLUMN 
C)  ​ALTER TABLE...MODIFY 
D)  ​ALTER TABLE...AS 
A)  ​ALTER TABLE...ADD 
B)  ​ALTER TABLE...DROP COLUMN 
C)  ​ALTER TABLE...MODIFY 
D)  ​ALTER TABLE...AS

Question 19

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 20

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

Accepted Answer

When a table is truncated,the table stru

The default size of a VARCHAR2 column is one character.

Which of the following is a valid table name in Oracle 12c?

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

The MODIFY clause can be included in the ALTER TABLE command to add a default value to an existing column._________________________

_________________________ commands are used to create database objects.

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

Once a table is ____________________,any associated indexes will be removed from the database.

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

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

The CHAR datatype is used to store variable-length data that can consist of letters and numbers._________________________

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

The ALPHANUMERIC datatype can be used to store characters and numbers to a maximum width of 2000.

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

The default size of the CHAR column is 2._________________________

SELECT9 is a valid table name._________________________

Which of the following keywords is used to remove a database table in Oracle 12c?

Which of the following rules apply to table names in Oracle 12c?

Which of the following keywords cannot be used to modify an existing table?

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

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

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 size of a VARCHAR2 column is one character.​

​Which of the following is a valid table name in Oracle 12c?

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

The MODIFY clause can be included in the ALTER TABLE command to add a default value to an existing column._________________________

_________________________ commands are used to create database objects.

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

Once a table is ____________________,any associated indexes will be removed from the database.

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

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

The CHAR datatype is used to store variable-length data that can consist of letters and numbers._________________________​

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

​The ALPHANUMERIC datatype can be used to store characters and numbers to a maximum width of 2000.

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

The default size of the CHAR column is 2._________________________​

SELECT9 is a valid table name._________________________​

Which of the following keywords is used to remove a database table in Oracle 12c?​

Which of the following rules apply to table names in Oracle 12c?​

Which of the following keywords cannot be used to modify an existing table?​

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

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

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 default size of a VARCHAR2 column is one character.

Which of the following is a valid table name in Oracle 12c?

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

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

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

The CHAR datatype is used to store variable-length data that can consist of letters and numbers._________________________

The ALPHANUMERIC datatype can be used to store characters and numbers to a maximum width of 2000.

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

The default size of the CHAR column is 2._________________________

SELECT9 is a valid table name._________________________

Which of the following keywords is used to remove a database table in Oracle 12c?

Which of the following rules apply to table names in Oracle 12c?

Which of the following keywords cannot be used to modify an existing table?

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

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