Copyright

What are SQL Functions? - Use & Examples Video

Instructions:

Choose an answer and hit 'next'. You will receive your score and answers at the end.

question 1 of 3

Which of the following statements is NOT true about SQL functions?

Create Your Account To Take This Quiz

As a member, you'll also get unlimited access to over 79,000 lessons in math, English, science, history, and more. Plus, get practice tests, quizzes, and personalized coaching to help you succeed.

Try it risk-free
Try it risk-free for 30 days. Cancel anytime
Already registered? Log in here for access

1.

Take a look at the table. What is the result after executing the following query?

select sum(salary) from empSalary where department = 'HR'

2.

Which of the following are examples of built-in SQL scalar functions?

I. TRIM

II. LEN

III. SUM

IV. CONCAT

Create your account to access this entire worksheet
A Premium account gives you access to all lesson, practice exams, quizzes & worksheets
Access to all video lessons
Quizzes, practice exams & worksheets
Certificate of Completion
Access to instructors
Create an account to get started Create Account

About This Quiz & Worksheet

See what you know about SQL functions by answering these multiple-choice questions. For the quiz, you'll be covering important areas of interest, such as the characteristics of SQL functions and the outcome of executing a query in a sample table.

Quiz & Worksheet Goals

The quiz will cover these topics:

  • Built-in SQL scalar functions
  • The benefits of using SQL functions
  • Error in an SQL statement

Skills Practiced

  • Reading comprehension - make sure you know the most important information about the basic attributes of SQL functions
  • Knowledge application - use your knowledge to answer questions about the advantages of using SQL functions and some examples of built-in SQL scalar functions
  • Information recall - access the knowledge you've gained regarding the result of executing a query with a sample table

Additional Learning

To learn more about functions in computer programming, feel free to review the lesson entitled What are SQL Functions? - Use & Examples. The following points will be covered:

  • DDL (data definition language)
  • DML (data manipulation language)
  • Ways of classifying SQL functions
  • SQL function applications
  • Aggregate functions
Support