Question 1

A ____ is a character LOB,storing up to 4 GB of character data in the database.
A)BFILE
B)BLOB
C)CLOB
D)CHAR

Accepted Answer

CLOB stands for Character LOB and can store up to 4 GB of character data in the database. BLOB is used for binary data and BFILE is used for storing data outside the database in a file on the operating system. CHAR is a fixed-length character data type. Therefore, the best choice for storing large amounts of character data is CLOB.

Question 2

A(n)____________________ is a whole number with no digits on the right side of the decimal point.

Accepted Answer

The answer of A(n)____________________ is a whole number with no...

Question 3

A(n)____________________ specifies the kind of data that the column stores.

Accepted Answer

The answer of A(n)____________________ specifies the kind of data that...

Question 4

Fixed-length character data is stored in the ____________________ data type.

Accepted Answer

The answer of Fixed-length character data is stored in the...

Question 5

The data objects within a user schema are called database objects or ____________________.

Accepted Answer

The answer of The data objects within a user schema...

Question 6

Deleting columns from a table is a(n)____ action.
A)restricted
B)unrestricted
C)illegal
D)privileged

Accepted Answer

The answer of Deleting columns from a table is a(n)____...

Question 7

____________________ are restrictions on the data values that a column can store.

Accepted Answer

The answer of ____________________ are restrictions on the data values...

Question 8

The ____ constraint specifies whether the user must enter a column for a specific record,or whether the value can be NULL (indeterminate or unknown).
A)INDEF
B)INPUT
C)NULL
D)NOT NULL

Accepted Answer

The correct constraint for this scenario is "NOT NULL" which means that the user must enter a value for the specific record and NULL values are not allowed.

Question 9

____ constraints define specific data values or data ranges that must be inserted into columns and whether values must be unique or not NULL.
A)Value
B)Integrity
C)Redundancy
D)Range

Accepted Answer

The answer of ____ constraints define specific data values or...

Question 10

A(n)____ number would be best to store a currency value.
A)int
B)char
C)floating-point
D)fixed-point

Accepted Answer

Fixed-point numbers are best for storing currency values because they avoid the precision issues associated with floating-point arithmetic, ensuring accurate financial calculations.

Question 11

The VARCHAR2 data type stores variable-length character data up to a maximum of ____________________ characters.

Accepted Answer

The answer of The VARCHAR2 data type stores variable-length character...

Question 12

The CHAR data type stores fixed-length character data up to a maximum size of ____ characters.
A)2,000
B)4,000
C)10,000
D)unlimited

Accepted Answer

The CHAR data type in most database management systems stores fixed-length character data up to a maximum size of 2,000 characters. Therefore, the best choice would be A.

Question 13

Each SQL*Plus command is terminated with a(n)____.
A)period
B)semicolon
C)colon
D)exclamation mark

Accepted Answer

Each SQL*Plus command is terminated with a semicolon (;).

Question 14

Oracle10g stores character data in VARCHAR2 and CHAR columns using ____ encoding.
A)Unicode
B)ASCII
C)EBCDIC
D)Java

Accepted Answer

The answer of Oracle10g stores character data in VARCHAR2 and...

Question 15

The ____________________ specifies the number of digits on the right side of the decimal point.

Accepted Answer

The answer of The ____________________ specifies the number of digits...

Question 16

You use the ____ data type for any column that stores numerical data upon which users may perform arithmetic calculations.
A)NUMBER
B)NUMERIC
C)VAR
D)FLOAT

Accepted Answer

The NUMBER data type is used for any column that stores numerical data upon which users may perform arithmetic calculations.

Question 17

______________________________ commands are used to insert,update,delete,and view data.

Accepted Answer

The answer of ______________________________ commands are used to insert,update,delete,and view...

Question 18

The ____ TABLE command is used to modify an existing column's data declaration.
A)CHANGE
B)RESET
C)MODIFY
D)ALTER

Accepted Answer

The ALTER TABLE command is used to modify an existing table. It allows you to add, delete or modify columns or constraints for an existing table. The ALTER TABLE command can also be used to modify an existing column's data declaration through the MODIFY keyword.

Question 19

____________________ is the total number of digits both to the left and to the right of the decimal point.

Accepted Answer

The answer of ____________________ is the total number of digits...

Question 20

NVARCHAR2 and NCHAR store character data with ____________________ coding.

Accepted Answer

The answer of NVARCHAR2 and NCHAR store character data with...

Quiz 2: Creating and Modifying Database Tables

A ____ is a character LOB,storing up to 4 GB of character data in the database.

A(n)____________________ is a whole number with no digits on the right side of the decimal point.

A(n)____________________ specifies the kind of data that the column stores.

Fixed-length character data is stored in the ____________________ data type.

The data objects within a user schema are called database objects or ____________________.

Deleting columns from a table is a(n) ____ action.

____________________ are restrictions on the data values that a column can store.

The ____ constraint specifies whether the user must enter a column for a specific record,or whether the value can be NULL (indeterminate or unknown) .

____ constraints define specific data values or data ranges that must be inserted into columns and whether values must be unique or not NULL.

A(n) ____ number would be best to store a currency value.

The VARCHAR2 data type stores variable-length character data up to a maximum of ____________________ characters.

The CHAR data type stores fixed-length character data up to a maximum size of ____ characters.

Each SQL*Plus command is terminated with a(n) ____.

Oracle10g stores character data in VARCHAR2 and CHAR columns using ____ encoding.

The ____________________ specifies the number of digits on the right side of the decimal point.

You use the ____ data type for any column that stores numerical data upon which users may perform arithmetic calculations.

______________________________ commands are used to insert,update,delete,and view data.

The ____ TABLE command is used to modify an existing column's data declaration.

____________________ is the total number of digits both to the left and to the right of the decimal point.

NVARCHAR2 and NCHAR store character data with ____________________ coding.