Question 1

The ____________________ datatype is used to store fixed length data.

Accepted Answer

The answer of The ____________________ datatype is used to store...

Question 2

Data $\underline {  \text { manipulation }  }$language commands are used to create or modify database tables. _________________________

Accepted Answer

A) True 
 B)False

Question 3

Structure of the PROMOTION table
  
-A _______ column generates values automatically at runtime and may reference values from other columns.

Accepted Answer

A)  Automatic 
B)  Virtual 
C)  Calculated 
D)  Static 
A)  Automatic 
B)  Virtual 
C)  Calculated 
D)  Static

Question 4

A database ____________________ is a defined, self-contained structure in Oracle11g.

Accepted Answer

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

Question 5

To delete all the rows in a table and free up the storage space that was occupied by those rows, the ____ command should be used.

Accepted Answer

A)  ALTER TABLE...DELETE 
B)  TRUNCATE ROWS 
C)  TRUNCATE TABLE 
D)  DELETE...FROM 
A)  ALTER TABLE...DELETE 
B)  TRUNCATE ROWS 
C)  TRUNCATE TABLE 
D)  DELETE...FROM

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

When adding a column to an existing table, the ____________________ clause must be used with the ALTER TABLE command.

Accepted Answer

The answer of When adding a column to an existing...

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

The default format of a DATE column in Oracle11g is DD-MON-YY.

Accepted Answer

A) True 
 B)False

Question 10

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;

Question 11

Structure of the CUSTOMERS table
  
-Which of the following commands will increase the size of the CITY column in the CUSTOMERS table from 12 to 20 and increase size of the LASTNAME column from 10 to 14?

Accepted Answer

A)  ALTER TABLE customers
MODIFY (city VARCHAR2(+8), lastname VARCHAR2(+4)); 
B)  ALTER TABLE customers
MODIFY (city VARCHAR2(20), lastname VARCHAR2(14)); 
C)  ALTER TABLE customers
MODIFY (city (+8), lastname (+4)); 
D)  ALTER TABLE customers
MODIFY (city (20), lastname (14)); 
A)  ALTER TABLE customers
MODIFY (city VARCHAR2(+8), lastname VARCHAR2(+4)); 
B)  ALTER TABLE customers
MODIFY (city VARCHAR2(20), lastname VARCHAR2(14)); 
C)  ALTER TABLE customers
MODIFY (city (+8), lastname (+4)); 
D)  ALTER TABLE customers
MODIFY (city (20), lastname (14));

Question 12

The data contained in a dropped table can be retrieved if the $\underline { \text { DROP }   }$ option was not used in the DROP TABLE command. _________________________

Accepted Answer

A) True 
 B)False

Question 13

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

Question 14

A table name can consist of numbers, letters, and blank spaces.

Accepted Answer

A) True 
 B)False

Question 15

The syntax of the$\underline {   \text { CREATE TABLE }  }$ command requires that the column list be enclosed in parentheses. _________________________

Accepted Answer

A) True 
 B)False

Question 16

The CREATE TABLE cannot contain a subquery.

Accepted Answer

A) True 
 B)False

Question 17

A table that has been dropped without the PURGE option can be retrieved using the FLASHBACK TABLE command.

Accepted Answer

A) True 
 B)False

Question 18

$\underline {  \text { DDL }  }$ commands are used to create or modify database objects. _________________________

Accepted Answer

A) True 
 B)False

Question 19

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 20

The $\underline { \text { CREATE TABLE }   }$ command is used to create a table in Oracle11g. _________________________

Accepted Answer

A) True 
 B)False

The ____________________ datatype is used to store fixed length data.

Data $\underline { \text { manipulation } }$ language commands are used to create or modify database tables. _________________________

Structure of the PROMOTION table -A _______ column generates values automatically at runtime and may reference values from other columns.

A database ____________________ is a defined, self-contained structure in Oracle11g.

To delete all the rows in a table and free up the storage space that was occupied by those rows, the ____ command should be used.

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

When adding a column to an existing table, the ____________________ clause must be used with the ALTER TABLE command.

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

The default format of a DATE column in Oracle11g is DD-MON-YY.

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

Structure of the CUSTOMERS table -Which of the following commands will increase the size of the CITY column in the CUSTOMERS table from 12 to 20 and increase size of the LASTNAME column from 10 to 14?

The data contained in a dropped table can be retrieved if the $\underline { \text { DROP } }$ option was not used in the DROP TABLE command. _________________________

Which command is used to rename a table you own?

A table name can consist of numbers, letters, and blank spaces.

The syntax of the $\underline { \text { CREATE TABLE } }$ command requires that the column list be enclosed in parentheses. _________________________

The CREATE TABLE cannot contain a subquery.

A table that has been dropped without the PURGE option can be retrieved using the FLASHBACK TABLE command.

$\underline { \text { DDL } }$ commands are used to create or modify database objects. _________________________

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

The $\underline { \text { CREATE TABLE } }$ command is used to create a table in Oracle11g. _________________________

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 ____________________ datatype is used to store fixed length data.

Data manipulation ‾\underline { \text { manipulation } } manipulation ​ language commands are used to create or modify database tables. _________________________

Structure of the PROMOTION table -A _______ column generates values automatically at runtime and may reference values from other columns.

A database ____________________ is a defined, self-contained structure in Oracle11g.

To delete all the rows in a table and free up the storage space that was occupied by those rows, the ____ command should be used.

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

When adding a column to an existing table, the ____________________ clause must be used with the ALTER TABLE command.

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

The default format of a DATE column in Oracle11g is DD-MON-YY.

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

Structure of the CUSTOMERS table -Which of the following commands will increase the size of the CITY column in the CUSTOMERS table from 12 to 20 and increase size of the LASTNAME column from 10 to 14?

The data contained in a dropped table can be retrieved if the DROP ‾\underline { \text { DROP } } DROP ​ option was not used in the DROP TABLE command. _________________________

Which command is used to rename a table you own?

A table name can consist of numbers, letters, and blank spaces.

The syntax of the CREATE TABLE ‾\underline { \text { CREATE TABLE } } CREATE TABLE ​ command requires that the column list be enclosed in parentheses. _________________________

The CREATE TABLE cannot contain a subquery.

A table that has been dropped without the PURGE option can be retrieved using the FLASHBACK TABLE command.

DDL ‾\underline { \text { DDL } } DDL ​ commands are used to create or modify database objects. _________________________

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

The CREATE TABLE ‾\underline { \text { CREATE TABLE } } CREATE TABLE ​ command is used to create a table in Oracle11g. _________________________

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

Data $\underline { \text { manipulation } }$ language commands are used to create or modify database tables. _________________________

The data contained in a dropped table can be retrieved if the $\underline { \text { DROP } }$ option was not used in the DROP TABLE command. _________________________

The syntax of the $\underline { \text { CREATE TABLE } }$ command requires that the column list be enclosed in parentheses. _________________________

$\underline { \text { DDL } }$ commands are used to create or modify database objects. _________________________

The $\underline { \text { CREATE TABLE } }$ command is used to create a table in Oracle11g. _________________________