Busy. Please wait.
Log in with Clever
or
show password
Forgot Password?
Don't have an account?  Sign up 
Sign up using Clever
or
Username is available taken
show password

Your email address is only used to allow you to reset your password. See our Privacy Policy and Terms of Service.

Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.

SQL ch3 review Test

Enter the letter for the matching Answer
incorrect
1.
A _____ ___ is a column that does not exist in the database but can be computed using data in the existing columns.
incorrect
2.
34.SQL has special functions, called ___ ___ to calculate sums, averages, counts, max values, and min values.
incorrect
3.
34.When you need to sort data on two columns, the more important column is called the _____ (or the ___ ) and the less important column is called the ____ or the ____.
incorrect
4.
You form ___ ___ by connecting two or more simple conditions using the AND, OR and NOT operators.
incorrect
5.
A ___ has this form: column name, comparison operator, and then either another column name or a value
incorrect
6.
34.It is possible to place one query inside another. The inner query is called a ____; the subquery is evaluated __.
incorrect
7.
34.The column on which data is to be sorted is called a ____ or simply a ___.
A.
subquery, first
B.
major sort key (primary sort key), minor sort key(secondary sort key)
C.
computed column
D.
simple condition
E.
sort key, key
F.
compound conditions
G.
aggregate functions
Type the Answer that corresponds to the displayed Question.
incorrect
8.
After you type the word SELECT, you list the columns that you want to include in the query results. This portion of the command is called?
incorrect
9.
Next you type the word FROM followed by the name of the table that contains the data you need to query. This portion of the command is called?
incorrect
10.
An ____ which consists of the IN operator followed by a collection of values, provides a concise way of phrasing certain conditions.
incorrect
11.
A ____ is simply a question represented in a way that the DBMS can understand.
incorrect
12.
In SQL, you specify the results order by using the __ clause.
incorrect
13.
Finally, after the word WHERE you list any conditions that apply to the data you want to retrieve. This optional portion of the command is called the?
incorrect
14.
34.The ____ is used to restrict the groups that will be included.

edit
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

  Normal Size     Small Size show me how
Created by: kat1350
Popular Computers sets