Question 1

DML commands are used to create or modify database tables.​

Accepted Answer

A) True 
 B)False

Question 2

What is the difference between dropping a column with the DROP COLUMN clause and setting a column as unused with the SET UNUSED clause?​

Accepted Answer

​When a column is dropped with the DROP

Question 3

An automatic column will generate a value at runtime and may reference values from other columns.
​

Accepted Answer

A) True 
 B)False

Question 4

Which of the following is a valid column name?​

Accepted Answer

A)  ​VARCHAR2 
B)  ​DISTINCT 
C)  ​NEW_COLUMN 
D)  ​CHAR 
A)  ​VARCHAR2 
B)  ​DISTINCT 
C)  ​NEW_COLUMN 
D)  ​CHAR

Question 5

​The column definition of NUMBER(7,4)indicates a precision of ____.

Accepted Answer

A)  ​7 
B)  ​4 
C)  ​11 
D)  ​3 
A)  ​7 
B)  ​4 
C)  ​11 
D)  ​3

Question 6

Which command instructs Oracle 12c to create a new table from existing data?​

Accepted Answer

A)  ​CREATE NEW TABLE 
B)  ​CREATE TABLE...FROM 
C)  ​CREATE TABLE 
D)  ​CREATE TABLE...AS 
A)  ​CREATE NEW TABLE 
B)  ​CREATE TABLE...FROM 
C)  ​CREATE TABLE 
D)  ​CREATE TABLE...AS

Question 7

A table must have at least ____________________ column(s).​

Accepted Answer

The answer of A table must have at least ____________________...

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

Which of the following datatypes refers to variable-length character data,where n represents the maximum length of the column?​

Accepted Answer

A)  ​CHAR(n) 
B)  ​BFILE 
C)  ​VARCHAR2(n) 
D)  ​LONG 
A)  ​CHAR(n) 
B)  ​BFILE 
C)  ​VARCHAR2(n) 
D)  ​LONG

Question 10

The structure of a table can be viewed by issuing the STRUCTURE command.​

Accepted Answer

A) True 
 B)False

Question 11

In which format does Oracle 12c display a date value?​

Accepted Answer

A)  ​DD-MON-YEAR 
B)  ​DAY-MM-YY 
C)  ​DD-MM-YY 
D)  ​DD-MON-YY 
A)  ​DD-MON-YEAR 
B)  ​DAY-MM-YY 
C)  ​DD-MM-YY 
D)  ​DD-MON-YY

Question 12

Which data dictionary object contains a column named HIDDEN_COLUMN?​

Accepted Answer

A)  ​USER_HIDE_COLS. 
B)  USER_TABLES.​ 
C)  ​USER_COLUMNS. 
D)  ​USER_TAB_COLS. 
A)  ​USER_HIDE_COLS. 
B)  USER_TABLES.​ 
C)  ​USER_COLUMNS. 
D)  ​USER_TAB_COLS.

Question 13

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 14

The data contained in a dropped table can be retrieved if the DROP option was not used in the DROP TABLE command._________________________​

Accepted Answer

A) True 
 B)False

Question 15

What is the problem associated with changing the name of a table?

Accepted Answer

​If you change the name of a t

Question 16

More than one column can be changed at a time with the ALTER TABLE...MODIFY command._________________________​

Accepted Answer

A) True 
 B)False

Question 17

​Which command instructs Oracle 12c 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 18

Which of the following queries will allow hidden columns to be displayed?​

Accepted Answer

A)  DESC on a table.​ 
B)  ​SELECT which specifically references the hidden column. 
C)  ​SELECT *. 
D)  ​None of the above. 
A)  DESC on a table.​ 
B)  ​SELECT which specifically references the hidden column. 
C)  ​SELECT *. 
D)  ​None of the above.

Question 19

Which of the following commands can be used to make structural changes to an existing table?​

Accepted Answer

A)  ​MODIFY TABLE 
B)  ​ALTER TABLE 
C)  ​CHANGE TABLE 
D)  ​FIX TABLE 
A)  ​MODIFY TABLE 
B)  ​ALTER TABLE 
C)  ​CHANGE TABLE 
D)  ​FIX TABLE

Question 20

The maximum width of a VARCHAR2 column is 2000 characters.​

Accepted Answer

A) True 
 B)False

DML commands are used to create or modify database tables.

What is the difference between dropping a column with the DROP COLUMN clause and setting a column as unused with the SET UNUSED clause?

An automatic column will generate a value at runtime and may reference values from other columns.

Which of the following is a valid column name?

The column definition of NUMBER(7,4)indicates a precision of ____.

Which command instructs Oracle 12c to create a new table from existing data?

A table must have at least ____________________ column(s).

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

Which of the following datatypes refers to variable-length character data,where n represents the maximum length of the column?

The structure of a table can be viewed by issuing the STRUCTURE command.

In which format does Oracle 12c display a date value?

Which data dictionary object contains a column named HIDDEN_COLUMN?

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

The data contained in a dropped table can be retrieved if the DROP option was not used in the DROP TABLE command._________________________

What is the problem associated with changing the name of a table?

More than one column can be changed at a time with the ALTER TABLE...MODIFY command._________________________

Which command instructs Oracle 12c to create a new table?

Which of the following queries will allow hidden columns to be displayed?

Which of the following commands can be used to make structural changes to an existing table?

The maximum width of a VARCHAR2 column is 2000 characters.

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

DML commands are used to create or modify database tables.​

What is the difference between dropping a column with the DROP COLUMN clause and setting a column as unused with the SET UNUSED clause?​

An automatic column will generate a value at runtime and may reference values from other columns. ​

Which of the following is a valid column name?​

​The column definition of NUMBER(7,4)indicates a precision of ____.

Which command instructs Oracle 12c to create a new table from existing data?​

A table must have at least ____________________ column(s).​

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

Which of the following datatypes refers to variable-length character data,where n represents the maximum length of the column?​

The structure of a table can be viewed by issuing the STRUCTURE command.​

In which format does Oracle 12c display a date value?​

Which data dictionary object contains a column named HIDDEN_COLUMN?​

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

The data contained in a dropped table can be retrieved if the DROP option was not used in the DROP TABLE command._________________________​

What is the problem associated with changing the name of a table?

More than one column can be changed at a time with the ALTER TABLE...MODIFY command._________________________​

​Which command instructs Oracle 12c to create a new table?

Which of the following queries will allow hidden columns to be displayed?​

Which of the following commands can be used to make structural changes to an existing table?​

The maximum width of a VARCHAR2 column is 2000 characters.​

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

DML commands are used to create or modify database tables.

What is the difference between dropping a column with the DROP COLUMN clause and setting a column as unused with the SET UNUSED clause?

An automatic column will generate a value at runtime and may reference values from other columns.

Which of the following is a valid column name?

The column definition of NUMBER(7,4)indicates a precision of ____.

Which command instructs Oracle 12c to create a new table from existing data?

A table must have at least ____________________ column(s).

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

Which of the following datatypes refers to variable-length character data,where n represents the maximum length of the column?

The structure of a table can be viewed by issuing the STRUCTURE command.

In which format does Oracle 12c display a date value?

Which data dictionary object contains a column named HIDDEN_COLUMN?

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

The data contained in a dropped table can be retrieved if the DROP option was not used in the DROP TABLE command._________________________

More than one column can be changed at a time with the ALTER TABLE...MODIFY command._________________________

Which command instructs Oracle 12c to create a new table?

Which of the following queries will allow hidden columns to be displayed?

Which of the following commands can be used to make structural changes to an existing table?

The maximum width of a VARCHAR2 column is 2000 characters.