Question 1

The name of a table can be changed with the ____________________ command.

Accepted Answer

RENAME
REN

Question 2

Which command instructs Oracle11g 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 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 default size of the CHAR column is $\underline { 2.   }$_________________________

Accepted Answer

A) True 
 B)False

Question 6

The abbreviation for the DESCRIBE command is $\underline {   \text { DES }  }$ _________________________

Accepted Answer

A) True 
 B)False

Question 7

The $\underline {   \text { CHAR } }$ datatype is used to store variable-length data that can consist of letters and numbers. _________________________

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

The maximum width of a NUMBER column is $\underline { 25   }$digits. _________________________

Accepted Answer

A) True 
 B)False

Question 10

If a column is defined as NUMBER(5,2), which of the following is True?

Accepted Answer

A)  The column can store a total of 7 digits, with 5 on the left side of the decimal point, and 2 on the right. 
B)  The column can store a total of 7 digits, all of them on the right side of the decimal point. 
C)  The column can store a total of 5 digits, with 3 on the left side of the decimal point, and 2 on the right. 
D)  The column can store a total of 5 digits, all of them on the left side of the decimal point. 
A)  The column can store a total of 7 digits, with 5 on the left side of the decimal point, and 2 on the right. 
B)  The column can store a total of 7 digits, all of them on the right side of the decimal point. 
C)  The column can store a total of 5 digits, with 3 on the left side of the decimal point, and 2 on the right. 
D)  The column can store a total of 5 digits, all of them on the left side of the decimal point.

Question 11

Which of the following keywords is used to remove a database table in Oracle11g?

Accepted Answer

A)  DROP TABLE 
B)  ALTER TABLE...DROP 
C)  DELETE TABLE 
D)  TRUNCATE TABLE 
A)  DROP TABLE 
B)  ALTER TABLE...DROP 
C)  DELETE TABLE 
D)  TRUNCATE TABLE

Question 12

In which format does Oracle10g 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 13

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 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

Which of the following rules apply to table names in Oracle11g?

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

$\underline { \text { Seven bytes }   }$ are allocated in a DATE column to store the century, year, month, day, hour, minute, and second of a date. _________________________

Accepted Answer

A) True 
 B)False

Question 18

Which of the following rules does not apply to column names in Oracle11g?

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 19

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 20

Every table name within a specific schema must be unique.

Accepted Answer

A) True 
 B)False

The name of a table can be changed with the ____________________ command.

Which command instructs Oracle11g to create a new table from existing data?

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 default size of the CHAR column is $\underline { 2. }$ _________________________

The abbreviation for the DESCRIBE command is $\underline { \text { DES } }$ _________________________

The $\underline { \text { CHAR } }$ datatype is used to store variable-length data that can consist of letters and numbers. _________________________

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

The maximum width of a NUMBER column is $\underline { 25 }$ digits. _________________________

If a column is defined as NUMBER(5,2), which of the following is True?

Which of the following keywords is used to remove a database table in Oracle11g?

In which format does Oracle10g display a date value?

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

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

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

Which of the following rules apply to table names in Oracle11g?

$\underline { \text { Seven bytes } }$ are allocated in a DATE column to store the century, year, month, day, hour, minute, and second of a date. _________________________

Which of the following rules does not apply to column names in Oracle11g?

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

Every table name within a specific schema must be unique.

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 name of a table can be changed with the ____________________ command.

Which command instructs Oracle11g to create a new table from existing data?

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 default size of the CHAR column is 2.‾\underline { 2. }2.​ _________________________

The abbreviation for the DESCRIBE command is DES ‾\underline { \text { DES } } DES ​ _________________________

The CHAR ‾\underline { \text { CHAR } } CHAR ​ datatype is used to store variable-length data that can consist of letters and numbers. _________________________

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

The maximum width of a NUMBER column is 25‾\underline { 25 }25​ digits. _________________________

If a column is defined as NUMBER(5,2), which of the following is True?

Which of the following keywords is used to remove a database table in Oracle11g?

In which format does Oracle10g display a date value?

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

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

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

Which of the following rules apply to table names in Oracle11g?

Seven bytes ‾\underline { \text { Seven bytes } } Seven bytes ​ are allocated in a DATE column to store the century, year, month, day, hour, minute, and second of a date. _________________________

Which of the following rules does not apply to column names in Oracle11g?

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

Every table name within a specific schema must be unique.

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

The default size of the CHAR column is $\underline { 2. }$ _________________________

The abbreviation for the DESCRIBE command is $\underline { \text { DES } }$ _________________________

The $\underline { \text { CHAR } }$ datatype is used to store variable-length data that can consist of letters and numbers. _________________________

The maximum width of a NUMBER column is $\underline { 25 }$ digits. _________________________

$\underline { \text { Seven bytes } }$ are allocated in a DATE column to store the century, year, month, day, hour, minute, and second of a date. _________________________