Question 1

____________________ is the procedural language that SQL Server uses.

Accepted Answer

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

Question 2

To concatenate columns in Oracle,you type two ____________________ between the column names.

Accepted Answer

The answer of To concatenate columns in Oracle,you type two...

Question 3

In SQL Server,you can use the ____ function to obtain today's date.
A)TODAYS_DATE
B)GETDATE()​
C)CURRENTDATE()
D)​SYSDATE

Accepted Answer

The GETDATE() function returns the current system date and time in SQL Server. This is the most commonly used function to obtain today's date in SQL Server. The other options (TODAYS_DATE, CURRENTDATE, and SYSDATE) are not valid functions in SQL Server.

Question 4

In Microsoft Visual Basic,use the ____ statement to create a string variable.
A)Dim
B)​Decl
C)Var
D)​Declare

Accepted Answer

The "Dim" statement is used in Visual Basic to declare variables, including string variables.

Question 5

Oracle uses ____________________ as an extension of SQL to accomplish procedural tasks.

Accepted Answer

The answer of Oracle uses ____________________ as an extension of...

Question 6

In PL/SQL,you can ensure that a variable has the same data type as a particular column by using the ____ attribute.
A)@VARIABLE
B)​%VARIABLE
C)@DATATYPE
D)​%TYPE

Accepted Answer

The %TYPE attribute is used in PL/SQL to declare a variable with the same data type as another variable or column. This ensures that the variable and column have the same data type and avoids data conversion errors.

Question 7

In the function UPPER(LAST_NAME),the item in parentheses (LAST_NAME)is called the ____________________ for the function.

Accepted Answer

The answer of In the function UPPER(LAST_NAME),the item in parentheses...

Question 8

To create a stored procedure in Oracle,use the ____ command.
A)CREATE ROUTINE
B)​CREATE SCRIPT
C)CREATE PROCEDURE
D)​CREATE EXECUTABLE

Accepted Answer

The correct command to create a stored procedure in Oracle is CREATE PROCEDURE. The other options (CREATE ROUTINE, CREATE SCRIPT, and CREATE EXECUTABLE) are not valid commands in Oracle for creating stored procedures.

Question 9

Variable names in PL/SQL must start with a letter and can contain letters,dollar signs,underscores,and number signs,but cannot exceed ____ characters.
A)15
B)​30
C)45
D)​60

Accepted Answer

Variable names in PL/SQL cannot exceed 30 characters.

Question 10

When you use a cursor in a procedure,the ____ command advances the cursor to the next row in the set of rows retrieved by the query and places the contents of the row in the indicated variables.
A)RETRIEVE
B)​FETCH
C)GET
D)​ADVANCE

Accepted Answer

The FETCH command is used to advance the cursor to the next row in the set of rows retrieved by the query and to place the contents of the row in the indicated variables. RETRIEVE, GET, and ADVANCE are not valid commands for moving the cursor in a SQL procedure.

Question 11

A(n)____________________ is a computer that is connected to a network and has access through the server to the database.

Accepted Answer

The answer of A(n)____________________ is a computer that is connected...

Question 12

In Microsoft Access,you can use the ____ function to obtain today's date.
A)TODAYS_DATE
B)​CURRENT_DATE
C)DATE()
D)​SYSDATE

Accepted Answer

The DATE() function in Microsoft Access returns the current system date. It is the standard way to obtain today's date in Access.

Question 13

In Oracle,you can use the ____ function to obtain today's date.
A)TODAYS_DATE
B)​CURRENT_DATE
C)NOWDATE
D)​SYSDATE

Accepted Answer

The SYSDATE function is used to obtain the current system date and time in Oracle. It can be used to retrieve today's date as well. The other options (A, B, and C) are not valid functions in Oracle.

Question 14

A(n)____ is a procedure that is executed automatically in response to an associated database operation.
A)cursor
B)trigger​
C)waypoint
D)​fetchpoint

Accepted Answer

A trigger is a procedure that is automatically executed in response to an associated database operation, such as an INSERT, UPDATE, or DELETE statement. Triggers are often used to enforce business rules, perform data validation, or update other tables in response to changes in the current table. Cursors, waypoints, and fetchpoints are not directly associated with triggers.

Question 15

SQL is a powerful ____________________ language in which you communicate tasks to the computer using simple commands.

Accepted Answer

The answer of SQL is a powerful ____________________ language in...

Question 16

To remove extra spaces to the right of a value,for example,the value in a FIRST_NAME column,use the ____ function.
A)TRUNCATE
B)​TRIM
C)RIGHT
D)​RTRIM

Accepted Answer

The RTRIM function removes any trailing spaces from a string value, which includes any spaces to the right of the value. TRUNCATE is used to remove decimal points from a numeric value, while TRIM removes both leading and trailing spaces from a string value. RIGHT is used to extract a specific number of characters from the end of a string value.

Question 17

A ____ is a pointer to a row in the collection of rows retrieved by an SQL command.
A)cursor
B)trigger​
C)waypoint
D)​fetchpoint

Accepted Answer

A cursor is a pointer to a row in the collection of rows retrieved by an SQL command. It allows the program to retrieve and manipulate the data row by row instead of fetching the entire result set at once.

Question 18

The process of combining two or more character columns into a single expression is called ____________________.

Accepted Answer

The answer of The process of combining two or more...

Question 19

A(n)____________________ language is one in which you must give the computer the step-by-step process for accomplishing a task.

Accepted Answer

The answer of A(n)____________________ language is one in which you...

Question 20

To call a procedure in SQL Server,use the ____ command.
A)CALL
B)​RUN
C)DO
D)​EXEC

Accepted Answer

In SQL Server, the EXEC command is used to call stored procedures. The CALL command is supported in other database management systems like MySQL, but not in SQL Server. The RUN command is not a valid command in SQL Server. The DO command is used to execute a block of code in some programming languages, but not in SQL Server.

Quiz 8: SQL Functions and Procedures

____________________ is the procedural language that SQL Server uses.

To concatenate columns in Oracle,you type two ____________________ between the column names.

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

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

Oracle uses ____________________ as an extension of SQL to accomplish procedural tasks.

In PL/SQL,you can ensure that a variable has the same data type as a particular column by using the ____ attribute.

In the function UPPER(LAST_NAME),the item in parentheses (LAST_NAME)is called the ____________________ for the function.

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

Variable names in PL/SQL must start with a letter and can contain letters,dollar signs,underscores,and number signs,but cannot exceed ____ characters.

When you use a cursor in a procedure,the ____ command advances the cursor to the next row in the set of rows retrieved by the query and places the contents of the row in the indicated variables.

A(n)____________________ is a computer that is connected to a network and has access through the server to the database.

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

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

A(n) ____ is a procedure that is executed automatically in response to an associated database operation.

SQL is a powerful ____________________ language in which you communicate tasks to the computer using simple commands.

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

A ____ is a pointer to a row in the collection of rows retrieved by an SQL command.

The process of combining two or more character columns into a single expression is called ____________________.

A(n)____________________ language is one in which you must give the computer the step-by-step process for accomplishing a task.

To call a procedure in SQL Server,use the ____ command.