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. Fixed-length character string. Size is specified in parenthesis. Max 255 bytes.
number(size -d)
Nested Subquery
Keyword
char(size)

2. Usually DBMS specific - these can provide extra functionality or simplified ways to perform specific operations.
DELETE
Simple Subquery
SQL extensions
Terminating Statements

3. Provides a numerical tally of how many rows meet a specific set of criteria.
COUNT()
mysql
Row
AVG()

4. Database software (an application)
SELECT Statement
DELETE
DESC
DBMS - Database Management System

5. 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.
Always define Primary Keys
mysql
HAVING
SELECT Statement

6. Limits the output of the established groups into the derived result group.
Primary Key
HAVING
Always define Primary Keys
COUNT()

7. A type of allowed data. Every table column has a datatype that restricts specific data in that column.
Datatype
SELECT
Primary Key
LIKE

8. A column or set of columns whose values uniquely identify every row in a table.
Database
GROUP BY
Use of Whitespace
Primary Key

9. A popular open source database
DESC
GROUP BY
Keyword
mysql

10. Prevents duplicate values witihin a table or group of rows from being used in the evaluation of the function's result
DISTINCT
AVG()
SQL extensions
COUNT()

11. Method used to copy multiple records at one time using a SELECT statement
INSERT INTO
Logical Operators
Database
SQL (Structured Query Language)

12. Takes a single numeric or alphabetic cloumn and finds the LOWEST constant value within it.
ANY
DELETE
MIN()
Primary Key

13. Specifies the tables or views from which rows and columns are retrieved
Commas
DBMS - Database Management System
Table
FROM

14. Specify one or more columns on which to order the display.
ORDER BY
ANY
DBMS - Database Management System
MIN()

15. Takes all of the values in that column and adds them together. Only works on columns containing numeric data.
number(size -d)
INSERT INTO
SUM()
SELECT Statement

16. When selecting multiple columns be sure to specify a _____ BETWEEN each column name but NOT after the last column name.
Commas
mysql
Column
DISTINCT

17. A single field in a table. All tables are made up of one or more columns.
Keyword
MAX()
Column
varchar(size)

18. All extra whitespace within a SQL statement is is ignored when that statement is processed.
Row
DBMS - Database Management System
WHERE
Use of Whitespace

19. Takes a single numeric or alphabetic cloumn and finds the HIGHEST constant value within it.
Database
Use of Whitespace
Simple Subquery
MAX()

20. _______ column name FROM table name
AVG()
DESC
SELECT
SELECT Statement

21. SQL statements are case- insensitive
SQL extensions
HAVING
Database
SQL Statement and Case

22. Denotes that the search condition is TRUE for at least one element that the subquery returns.
HAVING
SUM()
SQL (Structured Query Language)
ANY

23. Primary way to do a query in SQL
DBMS - Database Management System
AVG()
LIKE
SELECT Statement

24. Ascending
Nested Subquery
COUNT()
ORDER BY
ASC

25. Allows you to delete selected rows.
GROUP BY
DISTINCT
DELETE
Datatype

26. NOT - AND - OR
SQL (Structured Query Language)
mysql
Logical Operators
AVG()

27. Limits the rows that appear in the result to those matching a specified condition
LIKE
ORDER BY
Table
WHERE

28. The container - usually a file or set of files - to store organized data
SQL Statement and Case
Simple Subquery
application
Database

29. Combines rows from a SELECT statement's results table into groups in which specified columns have the same value.
GROUP BY
Use of Whitespace
ASC
Always define Primary Keys

30. Simplest type of subquery.
IN
FROM
SELECT *
Simple Subquery

31. Descending
DESC
HAVING
Breaking up data
Use of Whitespace

32. Variable-length character string. Max size is specified in parenthesis.
IN
SELECT
varchar(size)
Keyword

33. = Equals - < Less Than - > Greater Than - <= Less Than or Equal To - >= Greater Than or Equal To - <> Not Equal - ! Negation of
COUNT()
Comparison Operators
mysql
SQL extensions

34. 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.
Keyword
AVG()
Nested Subquery
MAX()

35. Data must be broken into multiple columns correctly. For example - city - state - and zip should always separate columns.
Nested Subquery
Table
Breaking up data
UPDATE

36. COUNT() - MAX() - MIN() - SUM() and AVG()
AS
SELECT Statement
SUM()
Aggregate Functions

37. Used to select all the information in a specified column.
Database
MAX()
SELECT *
varchar(size)

38. Allows a comparison with multiple values from a list.
IN
Commas
Self-Join
varchar(size)

39. Lets you use a single- or multiple-character wildcards. Also - this command does not function in Microsoft Access.
LIKE
mysql
DELETE
GROUP BY

40. A language designed specifically for communicating with databases.
char(size)
SQL (Structured Query Language)
HAVING
ANY

41. Alias
SELECT *
AS
Simple Subquery
DISTINCT

42. SQL is a language NOT an _______
Row
Nested Subquery
application
ANY

43. Multiple SQL statements must be separated by semicolons.
WHERE
Primary Key
Terminating Statements
SELECT

44. Number value with a maximum number of digits of "size" total - with a maximum number of "d" digits to the right of the decimal.
SELECT Statement
number(size -d)
Logical Operators
ORDER BY

45. Lets you change the values in one or more selected rows of a table.
IN
UPDATE
Column
Commas

46. Used to nest subqueries within another subquery.
INSERT INTO
FROM
ANY
Nested Subquery

47. A reserved word that is part of the SQL language. Never name a table or column using a keyword.
Terminating Statements
Commas
Keyword
Logical Operators

48. A record in a table
AS
number(size -d)
varchar(size)
Row

49. A structured list of data of a specific type
SELECT
Keyword
Database
Table

50. Allows you to correlate information between different rows of the same table and combine this information in rows of a result table.
SELECT Statement
ANY
Terminating Statements
Self-Join

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