Question 1

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

Accepted Answer

When a table is truncated,the table stru...

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

Question 3

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 4

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 (#) .

Question 5

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.

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

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

Accepted Answer

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

Question 9

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

Question 10

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

Question 11

_________________________ commands are used to create database objects.

Accepted Answer

DDL
Data d...

Question 12

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

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.

Question 14

SELECT9 is a valid table name._________________________​

Accepted Answer

A) True 
 B)False

Question 15

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 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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 19

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

Accepted Answer

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

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 3: Table Creation and Management

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

Correct AnswerverifiedShow Answer

_________________________ commands are used to create database objects.

Correct AnswerverifiedDDLData d...View AnswerShow Answer

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

Correct AnswerverifiedWhen a table is truncated,the table stru...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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?​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

SELECT9 is a valid table name._________________________​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct Answer
verified

Correct Answer
verified
DDL
Data d...
View Answer

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

Correct Answer
verified
When a table is truncated,the table stru...
View Answer

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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?

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

SELECT9 is a valid table name._________________________

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

The default size of a VARCHAR2 column is one character.

Correct Answer
verified

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

Correct Answer
verified

The default size of the CHAR column is 2._________________________

Correct Answer
verified

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

Correct Answer
verified