A Guide to SQL Study Set 2

Computing

Quiz 8 :

Functions Procedures and Triggers

Quiz 8 :

Functions Procedures and Triggers

Question Type
search
arrow
In MySQL, Oracle, and SQL server, you can display a value in lowercase letters using the _____.
Free
Multiple Choice
Answer:

Answer:

D

Tags
Choose question tag
close menu
arrow
How do you add a specific number of days to a date in MySQL?
Free
Multiple Choice
Answer:

Answer:

B

Tags
Choose question tag
close menu
arrow
Applying the function ROUND(PRICE,0) to the price 24.95 results in 24.
Free
True False
Answer:

Answer:

False

Tags
Choose question tag
close menu
arrow
To remove extra spaces to the right of a value after concatenating two or more columns, use the _____.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
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?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
In Oracle, to add a specific number of months to a date, use the _____.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
A procedure that is executed automatically in response to an associated database operation is called a _____.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Variable names in PL/SQL must start with a letter and can contain letters, dollar signs, underscores, and number signs, but cannot exceed _____.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
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?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Which function displays a value in uppercase letters in Oracle and SQL Server?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Which function can you use in Oracle, MySQL, and SQL Server to truncate everything to the right of the decimal point?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
In SQL Server, you can obtain today's date using the _____.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Which WHERE clause can you use with a SELECT statement to perform a case-insensitive search for rows containing the first name Marco?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The DATE_ADD function has one argument.
True False
Answer:
Tags
Choose question tag
close menu
arrow
In SQL Server, you use the & symbol to concatenate columns.
True False
Answer:
Tags
Choose question tag
close menu
arrow
When you need to complete tasks that are beyond the capabilities of SQL, you need to use a procedural language.
True False
Answer:
Tags
Choose question tag
close menu
arrow
You cannot use functions in WHERE clauses.
True False
Answer:
Tags
Choose question tag
close menu
arrow
In Oracle, SQL Server, and MySQL, you can round a numeric value to a desired number of decimal places using the _____.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Which command is used to call a procedure in SQL Server?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
What function can you use to obtain today's date in MySQL?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
Showing 1 - 20 of 35