Test your basic knowledge |

SQL: Structured Query Language

Subject : it-skills

Instructions:

Answer 50 questions in 15 minutes.
If you are not ready to take this test, you can study here.
Match each statement with the correct term.
Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.

This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.

1. A record in a table
varchar(size)
Row
WHERE
MIN()

2. NOT - AND - OR
Comparison Operators
SUM()
FROM
Logical Operators

3. Primary way to do a query in SQL
DBMS - Database Management System
SUM()
SELECT Statement
AS

4. Takes all of the values in that column and adds them together. Only works on columns containing numeric data.
SUM()
AS
Nested Subquery
ANY

5. Specify one or more columns on which to order the display.
ORDER BY
Datatype
Use of Whitespace
SUM()

6. Multiple SQL statements must be separated by semicolons.
char(size)
Commas
Terminating Statements
Nested Subquery

7. A type of allowed data. Every table column has a datatype that restricts specific data in that column.
FROM
DELETE
SELECT Statement
Datatype

8. SQL is a language NOT an _______
Column
application
HAVING
LIKE

9. A popular open source database
DISTINCT
mysql
DBMS - Database Management System
UPDATE

10. A structured list of data of a specific type
Self-Join
Keyword
Table
HAVING

11. Data must be broken into multiple columns correctly. For example - city - state - and zip should always separate columns.
Breaking up data
Logical Operators
Datatype
DISTINCT

12. Although primary keys are not specifically required - most database designers make certain that every table they create has a primary key so that future data manipulation is possible.
varchar(size)
SQL extensions
MAX()
Always define Primary Keys

13. Limits the output of the established groups into the derived result group.
HAVING
Nested Subquery
DBMS - Database Management System
SQL extensions

14. Used to nest subqueries within another subquery.
Database
SQL (Structured Query Language)
Primary Key
Nested Subquery

15. Descending
Table
DESC
Row
UPDATE

16. Combines rows from a SELECT statement's results table into groups in which specified columns have the same value.
GROUP BY
COUNT()
Always define Primary Keys
SELECT *

17. Simplest type of subquery.
Self-Join
Simple Subquery
AVG()
COUNT()

18. Used to select all the information in a specified column.
SUM()
ORDER BY
SELECT *
Terminating Statements

19. A reserved word that is part of the SQL language. Never name a table or column using a keyword.
Simple Subquery
Primary Key
ANY
Keyword

20. Allows you to correlate information between different rows of the same table and combine this information in rows of a result table.
Self-Join
SUM()
Database
Column

21. Usually DBMS specific - these can provide extra functionality or simplified ways to perform specific operations.
DBMS - Database Management System
Logical Operators
Table
SQL extensions

22. Limits the rows that appear in the result to those matching a specified condition
Breaking up data
WHERE
Nested Subquery
DBMS - Database Management System

23. Lets you use a single- or multiple-character wildcards. Also - this command does not function in Microsoft Access.
SELECT
LIKE
Comparison Operators
ANY

24. COUNT() - MAX() - MIN() - SUM() and AVG()
number(size -d)
SELECT *
ASC
Aggregate Functions

25. SQL statements are case- insensitive
Commas
SQL Statement and Case
IN
SELECT Statement

26. Lets you change the values in one or more selected rows of a table.
SUM()
UPDATE
Column
Database

27. A language designed specifically for communicating with databases.
Logical Operators
SQL (Structured Query Language)
Breaking up data
DELETE

28. When selecting multiple columns be sure to specify a _____ BETWEEN each column name but NOT after the last column name.
Commas
Primary Key
GROUP BY
Logical Operators

29. Database software (an application)
DISTINCT
SELECT *
Comparison Operators
DBMS - Database Management System

30. Variable-length character string. Max size is specified in parenthesis.
Table
FROM
Self-Join
varchar(size)

31. _______ column name FROM table name
SELECT
DBMS - Database Management System
SELECT *
mysql

32. Prevents duplicate values witihin a table or group of rows from being used in the evaluation of the function's result
SELECT *
COUNT()
DISTINCT
Breaking up data

33. Alias
number(size -d)
COUNT()
AS
Comparison Operators

34. All extra whitespace within a SQL statement is is ignored when that statement is processed.
AVG()
Use of Whitespace
Self-Join
LIKE

35. Ascending
ASC
Commas
MIN()
DESC

36. Provides a numerical tally of how many rows meet a specific set of criteria.
COUNT()
WHERE
Primary Key
SELECT Statement

37. Allows a comparison with multiple values from a list.
Column
DBMS - Database Management System
GROUP BY
IN

38. Denotes that the search condition is TRUE for at least one element that the subquery returns.
DELETE
mysql
ANY
Database

39. Method used to copy multiple records at one time using a SELECT statement
number(size -d)
Column
INSERT INTO
SELECT Statement

40. Number value with a maximum number of digits of "size" total - with a maximum number of "d" digits to the right of the decimal.
DELETE
number(size -d)
AS
Terminating Statements

41. Takes a single numeric or alphabetic cloumn and finds the LOWEST constant value within it.
DBMS - Database Management System
ORDER BY
MAX()
MIN()

42. Fixed-length character string. Size is specified in parenthesis. Max 255 bytes.
SUM()
UPDATE
SQL extensions
char(size)

43. Specifies the tables or views from which rows and columns are retrieved
DBMS - Database Management System
Simple Subquery
Row
FROM

44. Takes average of each of the numeric values in the column.Can only be used in conjuction with the DISTINCT keyword and only works on numeric columns.
SELECT
AVG()
Logical Operators
char(size)

45. A column or set of columns whose values uniquely identify every row in a table.
INSERT INTO
Primary Key
HAVING
MAX()

46. = Equals - < Less Than - > Greater Than - <= Less Than or Equal To - >= Greater Than or Equal To - <> Not Equal - ! Negation of
DESC
MAX()
Comparison Operators
GROUP BY

47. A single field in a table. All tables are made up of one or more columns.
Column
Comparison Operators
HAVING
SELECT

48. Allows you to delete selected rows.
Simple Subquery
DELETE
DISTINCT
Terminating Statements

49. Takes a single numeric or alphabetic cloumn and finds the HIGHEST constant value within it.
MIN()
Always define Primary Keys
Aggregate Functions
MAX()

50. The container - usually a file or set of files - to store organized data
SELECT Statement
Database
ANY
MIN()

Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?

Major Subjects
Tests & Exams AP CLEP DSST GRE SAT GMAT	Certifications CISSP go to https://www.isc2.org/ PMP ITIL RHCE MCTS More...	IT Skills Android Programming Data Modeling Objective C Programming Basic Python Programming Adobe Illustrator More...	Business Skills Advertising Techniques Business Accounting Basics Business Strategy Human Resource Management Marketing Basics More...
Soft Skills Body Language People Skills Public Speaking Persuasion Job Hunting And Resumes More...	Vocabulary GRE Vocab SAT Vocab TOEFL Essential Vocab Basic English Words For All Global Words You Should Know Business English More...	Languages AP German Vocab AP Latin Vocab SAT Subject Test: French Italian Survival Norwegian Survival More...	Engineering Audio Engineering Computer Science Engineering Aerospace Engineering Chemical Engineering Structural Engineering More...
Health Sciences Basic Nursing Skills Health Science Language Fundamentals Veterinary Technology Medical Language Cardiology Clinical Surgery More...	English Grammar Fundamentals Literary And Rhetorical Vocab Elements Of Style Vocab Introduction To English Major Complete Advanced Sentences Literature Homonyms More...	Math Algebra Formulas Basic Arithmetic: Measurements Metric Conversions Geometric Properties Important Math Facts Number Sense Vocab Business Math More...	Other Major Subjects Science Economics History Law Performing-arts Cooking Logic & Reasoning Trivia

Test your basic knowledge |

SQL: Structured Query Language

Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?

Let me suggest you:

Browse all subjects

Browse all tests

Most popular tests

Major Subjects

Tests & Exams

Certifications

IT Skills

Business Skills

Soft Skills

Vocabulary

Languages

Engineering

Health Sciences

English

Math

Other Major Subjects

Browse all subjects

Browse all tests

Most popular tests