Question 1

​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 
A)  ​ALTER TABLE...RENAME 
B)  ​ALTER TABLE...SET NAME 
C)  ​RENAME...AS 
D)  ​RENAME...TO D

Question 2

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 C

Question 3

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

​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

Question 5

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

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

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

​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) 
A)  ​data manipulation language (DML) 
B)  ​data control language (DCL) 
C)  ​data definition language (DDL) 
D)  ​data formatting language (DFL)

Question 9

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)  ​| | 
A)  ​" " 
B)  ​' ' 
C)  ​( ) 
D)  ​| |

Question 10

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 (&). 
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 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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 15

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)  ​( ) 
A)  " " 
B)  | |​ 
C)  ​' ' 
D)  ​( )

Question 16

​Each ____________________ name within a table must be unique.

Accepted Answer

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

Question 17

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

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

Question 19

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 20

​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

Which command is used to rename a table you own?

The maximum width of the NUMBER datatype is ____ digits.

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

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

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

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

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

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

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

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

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

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

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

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

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

Each ____________________ name within a table must be unique.

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?

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

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

Which of the following keywords can be used to change the size,datatype,and/or default value of an existing 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 command is used to rename a table you own?

The maximum width of the NUMBER datatype is ____ digits.

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

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

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

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

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

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

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

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

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

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

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

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

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

​Each ____________________ name within a table must be unique.

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

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

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

​Which of the following keywords can be used to change the size,datatype,and/or default value of an existing 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

Which command is used to rename a table you own?

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

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

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

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

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

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

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

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

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

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

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

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

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

Each ____________________ name within a table must be unique.

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?

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

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