Question 1

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

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Question 4

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.

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

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

Accepted Answer

A) True 
 B)False

Question 8

Which of the following is a valid column name?

Accepted Answer

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

Question 9

Every table name within a specific schema must be unique.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Question 14

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 15

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

Question 16

$\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 17

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 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

RENAME
REN...

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 3: Table Creation and Management

Which of the following is a valid column name?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Every table name within a specific schema must be unique.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedRENAMEREN...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

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

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

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

Correct AnswerverifiedShow Answer

In which format does Oracle10g display a date value?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
RENAME
REN...
View Answer

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified