Question 1

To view the column names and data types of the LOCATION table you would type DESCRIBE LOCATION;at the SQL*Plus prompt.

Accepted Answer

A) True 
 B)False

Question 2

A(n)____________________ number contains a variable number of decimal places.

Accepted Answer

The answer of A(n)____________________ number contains a variable number of...

Question 3

The CHAR data types stores up to 4,000 characters.

Accepted Answer

A) True 
 B)False

Question 4

A(n)____________________ constraint limits the value that can be placed in a specific column,irrespective of values that exist in other table rows.

Accepted Answer

The answer of A(n)____________________ constraint limits the value that can...

Question 5

Define the two basic categories of SQL commands.

Accepted Answer

Data definition language (DDL)commands-U

Question 6

Which of the following sql commands adds a new VARCHAR2 column of length 20 named new_column to table test?

Accepted Answer

A) ALTER TABLE test
ADD (new_column VARCHAR2(20)) 
B) ADD column new_column VARCHAR2(20)to TABLE test 
C) ADD to TABLE test (new_column VARCHAR2(20)) 
D) ALTER TABLE test (new_column VARCHAR2(20)) 
A) ALTER TABLE test
ADD (new_column VARCHAR2(20)) 
B) ADD column new_column VARCHAR2(20)to TABLE test 
C) ADD to TABLE test (new_column VARCHAR2(20)) 
D) ALTER TABLE test (new_column VARCHAR2(20))

Question 7

The Oracle DBMS stores columns of all data types in the same amount of space.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following is not a legal table name according to the Oracle Naming Standard?

Accepted Answer

A) #COURSE_ID 
B) COURSE$ID 
C) COURSEID 
D) COURSE_ID 
A) #COURSE_ID 
B) COURSE$ID 
C) COURSEID 
D) COURSE_ID

Question 9

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

Accepted Answer

A) period 
B) semicolon 
C) colon 
D) exclamation mark 
A) period 
B) semicolon 
C) colon 
D) exclamation mark

Question 10

An Oracle error consists of a 3 letter prefix and a 5 digit code.

Accepted Answer

A) True 
 B)False

Question 11

Explain why it is a good idea to use Notepad or another editor to modify your sql commands rather than trying to edit them directly in the SQL*Plus window.Give at least two advantages of using the editor.

Accepted Answer

Many SQL commands are long and complex,a

Question 12

To create a table it is only necessary to specify column names.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following data types is used to store variable length ASCII character data?

Accepted Answer

A) CHAR 
B) NCHAR 
C) VARCHAR2 
D) NVARCHAR2 
A) CHAR 
B) NCHAR 
C) VARCHAR2 
D) NVARCHAR2

Question 14

The CHAR and VARCHAR2 data types store Unicode character data.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following declares a column named "name" that always contains exactly 30 characters?

Accepted Answer

A) VARCHAR2(30)name 
B) CHAR(30)name 
C) name VARCHAR2(30) 
D) name CHAR(30) 
A) VARCHAR2(30)name 
B) CHAR(30)name 
C) name VARCHAR2(30) 
D) name CHAR(30)

Question 16

Which of the following is a legal character in the Oracle Naming Standard?

Accepted Answer

A) % 
B) ^ 
C) # 
D) * 
A) % 
B) ^ 
C) # 
D) *

Question 17

Which of the following column data type changes is permitted?

Accepted Answer

A) DATE to CHAR 
B) VARCHAR2 to CHAR 
C) CHAR to NUMBER 
D) NUMBER to DATE 
A) DATE to CHAR 
B) VARCHAR2 to CHAR 
C) CHAR to NUMBER 
D) NUMBER to DATE

Question 18

Which of the following is true when decreasing the maximum size of a CHAR column?

Accepted Answer

A) it is an unrestricted action 
B) it is only permitted if all values are NULL 
C) all values in the column will be truncated to the new size 
D) all values larger than the new size will be automatically set to NULL 
A) it is an unrestricted action 
B) it is only permitted if all values are NULL 
C) all values in the column will be truncated to the new size 
D) all values larger than the new size will be automatically set to NULL

Question 19

Which of the following pieces of information about a table is not displayed when using the DESCRIBE command?

Accepted Answer

A) column name 
B) column data type 
C) not null settings 
D) table constraints 
A) column name 
B) column data type 
C) not null settings 
D) table constraints

Question 20

Which of the following is not created using an integrity constraint?

Accepted Answer

A) foreign key 
B) primary key 
C) composite key 
D) surrogate key 
A) foreign key 
B) primary key 
C) composite key 
D) surrogate key

To view the column names and data types of the LOCATION table you would type DESCRIBE LOCATION;at the SQL*Plus prompt.

A(n)____________________ number contains a variable number of decimal places.

The CHAR data types stores up to 4,000 characters.

A(n)____________________ constraint limits the value that can be placed in a specific column,irrespective of values that exist in other table rows.

Define the two basic categories of SQL commands.

Which of the following sql commands adds a new VARCHAR2 column of length 20 named new_column to table test?

The Oracle DBMS stores columns of all data types in the same amount of space.

Which of the following is not a legal table name according to the Oracle Naming Standard?

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

An Oracle error consists of a 3 letter prefix and a 5 digit code.

Explain why it is a good idea to use Notepad or another editor to modify your sql commands rather than trying to edit them directly in the SQL*Plus window.Give at least two advantages of using the editor.

To create a table it is only necessary to specify column names.

Which of the following data types is used to store variable length ASCII character data?

The CHAR and VARCHAR2 data types store Unicode character data.

Which of the following declares a column named "name" that always contains exactly 30 characters?

Which of the following is a legal character in the Oracle Naming Standard?

Which of the following column data type changes is permitted?

Which of the following is true when decreasing the maximum size of a CHAR column?

Which of the following pieces of information about a table is not displayed when using the DESCRIBE command?

Which of the following is not created using an integrity constraint?

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

To view the column names and data types of the LOCATION table you would type DESCRIBE LOCATION;at the SQL*Plus prompt.

A(n)____________________ number contains a variable number of decimal places.

The CHAR data types stores up to 4,000 characters.

A(n)____________________ constraint limits the value that can be placed in a specific column,irrespective of values that exist in other table rows.

Define the two basic categories of SQL commands.

Which of the following sql commands adds a new VARCHAR2 column of length 20 named new_column to table test?

The Oracle DBMS stores columns of all data types in the same amount of space.

Which of the following is not a legal table name according to the Oracle Naming Standard?

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

An Oracle error consists of a 3 letter prefix and a 5 digit code.

Explain why it is a good idea to use Notepad or another editor to modify your sql commands rather than trying to edit them directly in the SQL*Plus window.Give at least two advantages of using the editor.

To create a table it is only necessary to specify column names.

Which of the following data types is used to store variable length ASCII character data?

The CHAR and VARCHAR2 data types store Unicode character data.

Which of the following declares a column named "name" that always contains exactly 30 characters?

Which of the following is a legal character in the Oracle Naming Standard?

Which of the following column data type changes is permitted?

Which of the following is true when decreasing the maximum size of a CHAR column?

Which of the following pieces of information about a table is not displayed when using the DESCRIBE command?

Which of the following is not created using an integrity constraint?

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