Question 1

In MySQL, Oracle, and SQL server, you can display a value in lowercase letters using the _____.
A) REGULAR function
B) LCASE function
C) SMALL function
D) LOWER function

Accepted Answer

The LOWER function is used in MySQL, Oracle, and SQL Server to convert all characters in a string to lowercase.

Question 2

How do you add a specific number of days to a date in MySQL?
A) use the DATE_ADD function without an INTERVAL unit
B) use an expression with a plus (+) operator such as "+ 14"
C) use the ADD_DAYS function
D) use the SUM operator

Accepted Answer

In MySQL, you can add a specific number of days to a date using an expression with a plus (+) operator, such as "date_column + INTERVAL 14 DAY".

Question 3

Applying the function ROUND(PRICE,0) to the price 24.95 results in 24.

Accepted Answer

The ROUND function rounds the number to the nearest integer, so applying ROUND(PRICE,0) to the price 24.95 would result in 25, not 24.

Question 4

To remove extra spaces to the right of a value after concatenating two or more columns, use the _____.
A) TRUNCATE function
B) TRIM function
C) FLOOR function
D) RTRIM function

Accepted Answer

The RTRIM function is used to remove any extra spaces to the right of a value, which is useful after concatenating two or more columns to ensure the resulting string does not end with unnecessary whitespace.

Question 5

If Mack wants to display the number of days between two dates, such as the current date and an invoice date from a table, which function can he use in his MySQL query to accomplish this?
A) DATE_ADD()
B) SUBTRACT()
C) DATEDIFF()
D) SYSDATE()

Accepted Answer

DATEDIFF() is the correct function to use when wanting to calculate the number of days between two dates in MySQL. It returns the difference in days between two date values.

Question 6

In Oracle, to add a specific number of months to a date, use the _____.
A) MONTHS function
B) ADD_DATE function
C) ADD_MONTHS function
D) CALC_MONTHS function

Accepted Answer

The correct function to add a specific number of months to a date in Oracle is ADD_MONTHS.

Question 7

A procedure that is executed automatically in response to an associated database operation is called a _____.
A) cursor
B) trigger
C) waypoint
D) fetchpoint

Accepted Answer

A trigger is a database object that is automatically executed or fired when certain events occur, such as before or after insertions, updates, or deletions in a specified table.

Question 8

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

Accepted Answer

Variable names in PL/SQL can be up to 30 characters long. This allows for descriptive naming while maintaining compatibility with Oracle's naming conventions for database objects.

Question 9

When you use a cursor in a procedure, what 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 within a cursor to advance it to the next row in the set of rows retrieved by the query, and it places the contents of that row into the variables specified in the cursor's definition.

Question 10

Which function displays a value in uppercase letters in Oracle and SQL Server?
A) CAPITAL
B) UPPER
C) LARGE
D) UCASE

Accepted Answer

The UPPER function is used in both Oracle and SQL Server to convert all letters in a specific string to uppercase.

Question 11

Which function can you use in Oracle, MySQL, and SQL Server to truncate everything to the right of the decimal point?
A) TRUNCATE
B) FLOOR
C) ROUND
D) TRIM

Accepted Answer

FLOOR is a function available in Oracle, MySQL, and SQL Server that rounds down the value to the nearest whole number, effectively truncating everything to the right of the decimal point.

Question 12

In SQL Server, you can obtain today's date using the _____.
A) DATEDIFF() function
B) GETDATE() function
C) CURRENTDATE() function
D) SYSDATE function

Accepted Answer

GETDATE() function returns the current database system timestamp as a datetime value without the database time zone offset in SQL Server.

Question 13

Which WHERE clause can you use with a SELECT statement to perform a case-insensitive search for rows containing the first name Marco?
A) WHERE FIRST_NAME = UPPER('MARCO')
B) WHERE FIRST_NAME = LOWER('MARCO')
C) WHERE LOWER(FIRST_NAME) = 'MARCO'
D) WHERE UPPER(FIRST_NAME) = 'MARCO'

Accepted Answer

The WHERE clause using UPPER(FIRST_NAME) = 'MARCO' converts all first names to uppercase before comparing, ensuring a case-insensitive match with 'MARCO'.

Question 14

The DATE_ADD function has one argument.

Accepted Answer

The DATE_ADD function in SQL requires at least two arguments: the starting date and the interval by which to add to the starting date.

Question 15

In SQL Server, you use the & symbol to concatenate columns.

Accepted Answer

In SQL Server, the plus sign (+) is used to concatenate columns, not the & symbol.

Question 16

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

Accepted Answer

SQL is primarily designed for managing and manipulating data in relational database management systems, but it is not designed to handle complex procedural logic or computations that go beyond data manipulation. For tasks that require conditional logic, iterations, and complex computations, a procedural language such as PL/SQL (for Oracle databases) or T-SQL (for Microsoft SQL Server) is needed. These languages extend SQL with procedural capabilities.

Question 17

You cannot use functions in WHERE clauses.

Accepted Answer

You can use certain functions in WHERE clauses, such as mathematical, string, date, and conversion functions, to filter query results based on specific conditions.

Question 18

In Oracle, SQL Server, and MySQL, you can round a numeric value to a desired number of decimal places using the _____.
A) INT function
B) FLOOR function
C) ROUND function
D) TRUNCATE function

Accepted Answer

The ROUND function is used in Oracle, SQL Server, and MySQL to round a numeric value to a specified number of decimal places.

Question 19

Which command is used to call a procedure in SQL Server?
A) CALL
B) RUN
C) DO
D) EXEC

Accepted Answer

In SQL Server, the EXEC command is used to execute a stored procedure.

Question 20

What function can you use to obtain today's date in MySQL?
A) TODAYS_DATE()
B) CURRENT_DATE()
C) DATE()
D) CURDATE()

Accepted Answer

The answer of What function can you use to obtain...

Quiz 8: Functions Procedures and Triggers

In MySQL, Oracle, and SQL server, you can display a value in lowercase letters using the _____.

How do you add a specific number of days to a date in MySQL?

Applying the function ROUND(PRICE,0) to the price 24.95 results in 24.

To remove extra spaces to the right of a value after concatenating two or more columns, use the _____.

If Mack wants to display the number of days between two dates, such as the current date and an invoice date from a table, which function can he use in his MySQL query to accomplish this?

In Oracle, to add a specific number of months to a date, use the _____.

A procedure that is executed automatically in response to an associated database operation is called a _____.

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

When you use a cursor in a procedure, what 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?

Which function displays a value in uppercase letters in Oracle and SQL Server?

Which function can you use in Oracle, MySQL, and SQL Server to truncate everything to the right of the decimal point?

In SQL Server, you can obtain today's date using the _____.

Which WHERE clause can you use with a SELECT statement to perform a case-insensitive search for rows containing the first name Marco?

The DATE_ADD function has one argument.

In SQL Server, you use the & symbol to concatenate columns.

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

You cannot use functions in WHERE clauses.

In Oracle, SQL Server, and MySQL, you can round a numeric value to a desired number of decimal places using the _____.

Which command is used to call a procedure in SQL Server?

What function can you use to obtain today's date in MySQL?