Question 1

To remove extra spaces to the right of a value, for example, the value in a FIRST_NAME column, use the ____ function.

Accepted Answer

A)  TRUNCATE 
B)  TRIM 
C)  RIGHT 
D)  RTRIM

Question 2

What is the difference between a nonprocedural language and a procedural language? Give an example of each.

Accepted Answer

The answer of What is the difference between a nonprocedural...

Question 3

In SQL Server, you can use the ____ function to obtain today's date.

Accepted Answer

A)  TODAYS_DATE 
B)  GETDATE() 
C)  CURRENTDATE() 
D)  SYSDATE

Question 4

A client is a computer that is connected to a network and has access through the server to the database.

Accepted Answer

A) True 
 B)False

Question 5

To create a stored procedure in Oracle, use the ____________________ command.

Accepted Answer

The answer of To create a stored procedure in Oracle,...

Question 6

In Microsoft Access, programs are written in ____________________, which does not support embedded SQL commands directly in the code.

Accepted Answer

The answer of In Microsoft Access, programs are written in...

Question 7

In Microsoft Visual Basic, use the ____ statement to create a string variable.

Accepted Answer

A)  Dim 
B)  Decl 
C)  Var 
D)  Declare

Question 8

If a price is 24.95, the function ROUND(PRICE,0) would result in 24.

Accepted Answer

A) True 
 B)False

Question 9

The ADD_MONTHS function has one argument.

Accepted Answer

A) True 
 B)False

Question 10

____________________ is the procedural language that SQL Server uses.

Accepted Answer

The answer of ____________________ is the procedural language that SQL...

Question 11

In Microsoft Access, you can use the ____ function to obtain today's date.

Accepted Answer

A)  TODAYS_DATE 
B)  CURRENT_DATE 
C)  DATE() 
D)  SYSDATE

Question 12

To add a specific number of days to a date, you must use a function.

Accepted Answer

A) True 
 B)False

Question 13

PL/SQL commands have a certain format and cannot include any blank lines in the code.

Accepted Answer

A) True 
 B)False

Question 14

The UPPER function allows you to manipulate numeric data.

Accepted Answer

A) True 
 B)False

Question 15

To close a cursor and deactivate it, use the ____________________ command.

Accepted Answer

The answer of To close a cursor and deactivate it,...

Question 16

In Microsoft Access, you must store an SQL command in a string variable.

Accepted Answer

A) True 
 B)False

Question 17

In Oracle and SQL Server, use the ____ function to truncate everything to the right of the decimal point.

Accepted Answer

A)  TRUNCATE 
B)  FLOOR 
C)  REMOVE 
D)  TRIM

Question 18

To create a stored procedure, use the CREATE PROCEDURE command.

Accepted Answer

A) True 
 B)False

Question 19

When you need to complete tasks that are beyond the capabilities of SQL, you need to use a procedural language.

Accepted Answer

A) True 
 B)False

Question 20

Microsoft Access supports triggers.

Accepted Answer

A) True 
 B)False

Exam 8: SQL Functions and Procedures

To remove extra spaces to the right of a value, for example, the value in a FIRST_NAME column, use the ____ function.

What is the difference between a nonprocedural language and a procedural language? Give an example of each.

In SQL Server, you can use the ____ function to obtain today's date.

A client is a computer that is connected to a network and has access through the server to the database.

To create a stored procedure in Oracle, use the ____________________ command.

In Microsoft Access, programs are written in ____________________, which does not support embedded SQL commands directly in the code.

In Microsoft Visual Basic, use the ____ statement to create a string variable.

If a price is 24.95, the function ROUND(PRICE,0) would result in 24.

The ADD_MONTHS function has one argument.

____________________ is the procedural language that SQL Server uses.

In Microsoft Access, you can use the ____ function to obtain today's date.

To add a specific number of days to a date, you must use a function.

PL/SQL commands have a certain format and cannot include any blank lines in the code.

The UPPER function allows you to manipulate numeric data.

To close a cursor and deactivate it, use the ____________________ command.

In Microsoft Access, you must store an SQL command in a string variable.

In Oracle and SQL Server, use the ____ function to truncate everything to the right of the decimal point.

To create a stored procedure, use the CREATE PROCEDURE command.

When you need to complete tasks that are beyond the capabilities of SQL, you need to use a procedural language.

Microsoft Access supports triggers.