Question 1

Structure of the PROMOTION table​
 
-​Which of the following commands will change the name of the PROMOTION table to GIFT?

Accepted Answer

A)   ALTER TABLE promotion NAME TO gift​
B)   ​ALTER TABLE promotion TO gift;
C)   ​RENAME TABLE promotion TO gift;
D)   ​RENAME promotion TO gift; D

Question 2

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.

Question 3

When defining columns for a table in the CREATE TABLE command,the column list must be enclosed in which of the following symbols?​

Accepted Answer

A)   ​" "
B)   ​' '
C)   ​( ) 
D)   ​| |

Question 4

The maximum width of the NUMBER datatype is ____ digits.

Accepted Answer

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

Question 5

A(n) ____ simply identifies the type of data that Oracle 12c will be expected to store in a column.​

Accepted Answer

A)   ​data definition
B)   ​data format
C)   ​datatype
D)   ​data record

Question 6

A database ____________________ is a defined,self-contained structure in Oracle 12c.

Accepted Answer

The answer of A database ____________________ is a defined,self-contained structure...

Question 7

The RENAME command can be used to assign a table to a new schema.​

Accepted Answer

A) True 
 B)False

Question 8

If a new table is being created based upon a subquery,the subquery must be enclosed in which of the following symbols?​

Accepted Answer

A)   " "
B)   | |​
C)   ​' '
D)   ​( )

Question 9

​Each ____________________ name within a table must be unique.

Accepted Answer

The answer of ​Each ____________________ name within a table must...

Question 10

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

Question 11

A database must be shut down before the ALTER TABLE command can be executed.​

Accepted Answer

A) True 
 B)False

Question 12

The TRUNCATE TABLE command can be used to delete a table from a database._________________________​

Accepted Answer

A) True 
 B)False

Question 13

The syntax of the CREATE TABLE command requires that the column list be enclosed in parentheses._________________________​

Accepted Answer

A) True 
 B)False

Question 14

​Which of the following terms refers to commands that are used to create or modify database tables?

Accepted Answer

A)   ​data manipulation language (DML) 
B)   ​data control language (DCL) 
C)   ​data definition language (DDL) 
D)   ​data formatting language (DFL)

Question 15

Which of the following rules does not apply to column names in Oracle 12c?​

Accepted Answer

A)   ​Column names can contain numbers.
B)   ​Column names can be up to 30 characters in length.
C)   ​Column names must begin with a letter.
D)   ​Column names can contain an ampersand (&) .

Question 16

​Which command is used to rename a table you own?

Accepted Answer

A)   ​ALTER TABLE...RENAME
B)   ​ALTER TABLE...SET NAME
C)   ​RENAME...AS
D)   ​RENAME...TO D

Question 17

​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

Question 18

​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

Question 19

Structure of the CUSTOMERS table
  ​
-Which of the following commands will change the name of the LAST NAME 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

Question 20

The scale of a NUMBER column indicates the number of digits that can be displayed to the right of the decimal point.​

Accepted Answer

A) True 
 B)False

Exam 3: Table Creation and Management

Structure of the PROMOTION table​ -​Which of the following commands will change the name of the PROMOTION table to GIFT?

Correct AnswerverifiedD

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

Correct AnswerverifiedShow Answer

When defining columns for a table in the CREATE TABLE command,the column list must be enclosed in which of the following symbols?​

Correct AnswerverifiedShow Answer

The maximum width of the NUMBER datatype is ____ digits.

Correct AnswerverifiedC

A(n) ____ simply identifies the type of data that Oracle 12c will be expected to store in a column.​

Correct AnswerverifiedShow Answer

A database ____________________ is a defined,self-contained structure in Oracle 12c.

Correct AnswerverifiedShow Answer

The RENAME command can be used to assign a table to a new schema.​

Correct AnswerverifiedShow Answer

If a new table is being created based upon a subquery,the subquery must be enclosed in which of the following symbols?​

Correct AnswerverifiedShow Answer

​Each ____________________ name within a table must be unique.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A database must be shut down before the ALTER TABLE command can be executed.​

Correct AnswerverifiedShow Answer

The TRUNCATE TABLE command can be used to delete a table from a database._________________________​

Correct AnswerverifiedShow Answer

The syntax of the CREATE TABLE command requires that the column list be enclosed in parentheses._________________________​

Correct AnswerverifiedShow Answer

​Which of the following terms refers to commands that are used to create or modify database tables?

Correct AnswerverifiedShow Answer

Which of the following rules does not apply to column names in Oracle 12c?​

Correct AnswerverifiedShow Answer

​Which command is used to rename a table you own?

Correct AnswerverifiedD

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The scale of a NUMBER column indicates the number of digits that can be displayed to the right of the decimal point.​

Correct AnswerverifiedShow Answer

Structure of the PROMOTION table -Which of the following commands will change the name of the PROMOTION table to GIFT?

Correct Answer
verified
D

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

Correct Answer
verified

When defining columns for a table in the CREATE TABLE command,the column list must be enclosed in which of the following symbols?

Correct Answer
verified

Correct Answer
verified
C

A(n) ____ simply identifies the type of data that Oracle 12c will be expected to store in a column.

Correct Answer
verified

Correct Answer
verified

The RENAME command can be used to assign a table to a new schema.

Correct Answer
verified

If a new table is being created based upon a subquery,the subquery must be enclosed in which of the following symbols?

Correct Answer
verified

Each ____________________ name within a table must be unique.

Correct Answer
verified

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

Correct Answer
verified

A database must be shut down before the ALTER TABLE command can be executed.

Correct Answer
verified

The TRUNCATE TABLE command can be used to delete a table from a database._________________________

Correct Answer
verified

The syntax of the CREATE TABLE command requires that the column list be enclosed in parentheses._________________________

Correct Answer
verified

Which of the following terms refers to commands that are used to create or modify database tables?

Correct Answer
verified

Which of the following rules does not apply to column names in Oracle 12c?

Correct Answer
verified

Which command is used to rename a table you own?

Correct Answer
verified
D

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

The scale of a NUMBER column indicates the number of digits that can be displayed to the right of the decimal point.

Correct Answer
verified