Question 1

To add data to the database,use the ____ command.

Accepted Answer

A) OPEN 
B) ADD 
C) ADD_DATA 
D) INSERT 
A) OPEN 
B) ADD 
C) ADD_DATA 
D) INSERT

Question 2

If you wish to grant a privilege to all users,what user name is used in the grant command?

Accepted Answer

A) ALL 
B) EVERYONE 
C) PUBLIC 
D) ALLUSERS 
A) ALL 
B) EVERYONE 
C) PUBLIC 
D) ALLUSERS

Question 3

What part of the query contains the join condition when joining two tables?

Accepted Answer

A) SELECT 
B) FROM 
C) WHERE 
D) GROUP BY 
A) SELECT 
B) FROM 
C) WHERE 
D) GROUP BY

Question 4

Only one search condition may be listed in a WHERE clause.

Accepted Answer

A) True 
 B)False

Question 5

To find all rows with NULL values for the column grade,your where condition would be: WHERE grade = NULL.

Accepted Answer

A) True 
 B)False

Question 6

Why is it more efficient to perform calculations within a query than to retrieve the individual values and perform the calculation on the client machine? Provide an example.

Accepted Answer

Database applications often display valu

Question 7

MIN is a single-row function.

Accepted Answer

A) True 
 B)False

Question 8

When you use the syntax: SELECT column1 AS anothername ...you are using a(n)____________________.

Accepted Answer

The answer of When you use the syntax: SELECT column1...

Question 9

To format a number value with a comma between the thousands and hundreds,use the format model ____.

Accepted Answer

A) 9999 
B) 99,999 
C) xxxx 
D) xx,xxx 
A) 9999 
B) 99,999 
C) xxxx 
D) xx,xxx

Question 10

When using a subquery the DBMS executes the ____________________ first.

Accepted Answer

The answer of When using a subquery the DBMS executes...

Question 11

When a row's value is a foreign key that references another row,it is called a(n)____________________ row.

Accepted Answer

The answer of When a row's value is a foreign...

Question 12

COUNT is a(n)____________________ function.

Accepted Answer

The answer of COUNT is a(n)____________________ function....

Question 13

The more common name for a natural join is a(n)____.

Accepted Answer

A) inner join 
B) outer join 
C) multi-join 
D) bi-join 
A) inner join 
B) outer join 
C) multi-join 
D) bi-join

Question 14

To retrieve a list of all values that appear in one table and not in another,which operator would be used?

Accepted Answer

A) MINUS 
B) SUBTRACT 
C) UNION 
D) INTERSECT 
A) MINUS 
B) SUBTRACT 
C) UNION 
D) INTERSECT

Question 15

The SYSDATE function supplies the current date from the system.

Accepted Answer

A) True 
 B)False

Question 16

All users can select data from all schemas,but they must be granted privileges to modify data.

Accepted Answer

A) True 
 B)False

Question 17

If you are joining three tables you must select a column from each table in the select portion of the statement.

Accepted Answer

A) True 
 B)False

Question 18

What keyword is added to the select command to retrieve only unique data?

Accepted Answer

A) UNIQUE 
B) NODUP 
C) DISTINCT 
D) INTERSECT 
A) UNIQUE 
B) NODUP 
C) DISTINCT 
D) INTERSECT

Question 19

You can use a format model to add a $ to a currency value when retrieving it from the database.

Accepted Answer

A) True 
 B)False

Question 20

How does Oracle keep sequence information unique for each user?

Accepted Answer

A) Only one user has access to a sequence 
B) Using user session 
C) Each user has a private copy of the sequence 
D) It is not always unique - there is a possibility that two users may receive the same sequence number 
A) Only one user has access to a sequence 
B) Using user session 
C) Each user has a private copy of the sequence 
D) It is not always unique - there is a possibility that two users may receive the same sequence number

To add data to the database,use the ____ command.

If you wish to grant a privilege to all users,what user name is used in the grant command?

What part of the query contains the join condition when joining two tables?

Only one search condition may be listed in a WHERE clause.

To find all rows with NULL values for the column grade,your where condition would be: WHERE grade = NULL.

Why is it more efficient to perform calculations within a query than to retrieve the individual values and perform the calculation on the client machine? Provide an example.

MIN is a single-row function.

When you use the syntax: SELECT column1 AS anothername ...you are using a(n)____________________.

To format a number value with a comma between the thousands and hundreds,use the format model ____.

When using a subquery the DBMS executes the ____________________ first.

When a row's value is a foreign key that references another row,it is called a(n)____________________ row.

COUNT is a(n)____________________ function.

The more common name for a natural join is a(n)____.

To retrieve a list of all values that appear in one table and not in another,which operator would be used?

The SYSDATE function supplies the current date from the system.

All users can select data from all schemas,but they must be granted privileges to modify data.

If you are joining three tables you must select a column from each table in the select portion of the statement.

What keyword is added to the select command to retrieve only unique data?

You can use a format model to add a $ to a currency value when retrieving it from the database.

How does Oracle keep sequence information unique for each user?

Clientserver Databases and the Oracle10g Relational Database

Creating and Modifying Database Tables

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 3: Using SQL Queries to Insert, update, delete, and View Data

To add data to the database,use the ____ command.

If you wish to grant a privilege to all users,what user name is used in the grant command?

What part of the query contains the join condition when joining two tables?

Only one search condition may be listed in a WHERE clause.

To find all rows with NULL values for the column grade,your where condition would be: WHERE grade = NULL.

Why is it more efficient to perform calculations within a query than to retrieve the individual values and perform the calculation on the client machine? Provide an example.

MIN is a single-row function.

When you use the syntax: SELECT column1 AS anothername ...you are using a(n)____________________.

To format a number value with a comma between the thousands and hundreds,use the format model ____.

When using a subquery the DBMS executes the ____________________ first.

When a row's value is a foreign key that references another row,it is called a(n)____________________ row.

COUNT is a(n)____________________ function.

The more common name for a natural join is a(n)____.

To retrieve a list of all values that appear in one table and not in another,which operator would be used?

The SYSDATE function supplies the current date from the system.

All users can select data from all schemas,but they must be granted privileges to modify data.

If you are joining three tables you must select a column from each table in the select portion of the statement.

What keyword is added to the select command to retrieve only unique data?

You can use a format model to add a $ to a currency value when retrieving it from the database.

How does Oracle keep sequence information unique for each user?

Clientserver Databases and the Oracle10g Relational Database

Creating and Modifying Database Tables

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