Question 1

If a user only specifies the time when setting a value for a DATE column,the date portion will default to the current time.

Accepted Answer

A) True 
 B)False

Question 2

Up to 6 GB of binary data can be stored in a BLOB column.

Accepted Answer

A) True 
 B)False

Question 3

A(n)____________________ constraint is a table constraint that specifies that a column must have a unique value for every table row.

Accepted Answer

The answer of A(n)____________________ constraint is a table constraint that...

Question 4

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

Accepted Answer

A) NUMBER 
B) NUMERIC 
C) VAR 
D) FLOAT 
A) NUMBER 
B) NUMERIC 
C) VAR 
D) FLOAT

Question 5

To log in to a database using SQL*Plus you only need to provide user name and password.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) 2,000 
B) 4,000 
C) 10,000 
D) unlimited 
A) 2,000 
B) 4,000 
C) 10,000 
D) unlimited

Question 7

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 8

The ____________________ category of data dictionary views shows both the objects in the current user's schema and the objects that the user has privileges to manipulate.

Accepted Answer

The answer of The ____________________ category of data dictionary views...

Question 9

Which of the following LOB data types does not store the entire large object in the database?

Accepted Answer

A) BLOB 
B) BFILE 
C) CLOB 
D) NCLOB 
A) BLOB 
B) BFILE 
C) CLOB 
D) NCLOB

Question 10

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 11

You can always rename a table.

Accepted Answer

A) True 
 B)False

Question 12

Adding a check condition constraint to a table is a(n)____________________ action.

Accepted Answer

The answer of Adding a check condition constraint to a...

Question 13

Which of the following is not required when creating a table?

Accepted Answer

A) table size 
B) table name 
C) column names 
D) column data types 
A) table size 
B) table name 
C) column names 
D) column data types

Question 14

Oracle provides a means to disable constraints and then enable them again.Give an example of a situation in which this feature would be useful.

Accepted Answer

Sometimes while you are developing new d

Question 15

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 16

What is the default format for a DATE value?

Accepted Answer

A) MM/DD/YY 
B) DD-MON-YY 
C) MM/DD/YYYY 
D) MON-DD-YYYY 
A) MM/DD/YY 
B) DD-MON-YY 
C) MM/DD/YYYY 
D) MON-DD-YYYY

Question 17

A composite key is created using a value constraint.

Accepted Answer

A) True 
 B)False

Question 18

Using the CHAR data type causes a column value to be padded to the maximum declared size of the column.

Accepted Answer

A) True 
 B)False

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

The VARCHAR2 data type can store up to 4,000 characters.

Accepted Answer

A) True 
 B)False

If a user only specifies the time when setting a value for a DATE column,the date portion will default to the current time.

Up to 6 GB of binary data can be stored in a BLOB column.

A(n)____________________ constraint is a table constraint that specifies that a column must have a unique value for every table row.

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

To log in to a database using SQL*Plus you only need to provide user name and password.

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

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

The ____________________ category of data dictionary views shows both the objects in the current user's schema and the objects that the user has privileges to manipulate.

Which of the following LOB data types does not store the entire large object in the database?

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

You can always rename a table.

Adding a check condition constraint to a table is a(n)____________________ action.

Which of the following is not required when creating a table?

Oracle provides a means to disable constraints and then enable them again.Give an example of a situation in which this feature would be useful.

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

What is the default format for a DATE value?

A composite key is created using a value constraint.

Using the CHAR data type causes a column value to be padded to the maximum declared size of the column.

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

The VARCHAR2 data type can store up to 4,000 characters.

Clientserver Databases and the Oracle10g Relational Database

Using SQL Queries to Insert, update, delete, and View Data

Introduction to PlSQL

Introduction to Forms Builder

Creating Custom Forms

Creating Database Reports

Creating an Integrated Database Application

Advanced SQL and PlSQL Topics

Advanced Forms Builder Topics

Introduction to Oracle 10g Database Administration

Filters

Exam 2: Creating and Modifying Database Tables

If a user only specifies the time when setting a value for a DATE column,the date portion will default to the current time.

Up to 6 GB of binary data can be stored in a BLOB column.

A(n)____________________ constraint is a table constraint that specifies that a column must have a unique value for every table row.

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

To log in to a database using SQL*Plus you only need to provide user name and password.

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

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

The ____________________ category of data dictionary views shows both the objects in the current user's schema and the objects that the user has privileges to manipulate.

Which of the following LOB data types does not store the entire large object in the database?

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

You can always rename a table.

Adding a check condition constraint to a table is a(n)____________________ action.

Which of the following is not required when creating a table?

Oracle provides a means to disable constraints and then enable them again.Give an example of a situation in which this feature would be useful.

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

What is the default format for a DATE value?

A composite key is created using a value constraint.

Using the CHAR data type causes a column value to be padded to the maximum declared size of the column.

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

The VARCHAR2 data type can store up to 4,000 characters.

Clientserver Databases and the Oracle10g Relational Database

Using SQL Queries to Insert, update, delete, and View Data

Introduction to PlSQL

Introduction to Forms Builder

Creating Custom Forms

Creating Database Reports

Creating an Integrated Database Application

Advanced SQL and PlSQL Topics

Advanced Forms Builder Topics

Introduction to Oracle 10g Database Administration

Filters