Copyright

Structured Query Language: Manipulating Databases Using SQL

Instructions:

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

question 1 of 3

Which SQL statement is used to sort the result of a database query?

Start Your Free Trial To Take This Quiz

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

Free 5-day trial
It only takes a few minutes to set up and you can cancel at any time.
Already registered? Login here for access

1. _____ operators are used to compare values, while _____ operators make it possible to combine two or more conditions in a single statement.

2.

Given the following table called Students, how many records would be returned using the following SQL database query?

SELECT Student ID

FROM Students

WHERE Financial Aid = Yes AND GPA > 3.0

Start your free trial to access this entire page
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

Structured Query Language (SQL) is a computer language used to retrieve and manipulate data found in databases. The quiz will assess your knowledge of SQL syntax and types of queries.

Quiz & Worksheet Goals

Take this quiz to see how well you know:

  • SQL statements
  • Condition keywords
  • Data sets
  • SQL syntax

Skills Practiced

When you take the quiz, you're practicing the following skills:

  • Reading comprehension - ensure that you draw the most important information from the related SQL lesson
  • Problem solving - use your acquired knowledge to solve practice problems using SQL
  • Knowledge application - use your knowledge to answer questions about data sets

Additional Learning

If you're interested in learning more about SQL, check out the accompanying video lesson titled Structured Query Language: Manipulating Databases Using SQL. That lesson will cover the following objectives:

  • Study the uses of database queries
  • Review SQL-specific statements
  • Go over the most important aspects of SQL syntax
  • Learn how to constrict or expand data returns using Boolean operators
  • Review arithmetic operators and comparison operators
Support