SQL Quiz - Statistics

Jump to: Answer Stats | Score Distribution | Your Scores

General Stats

This quiz has been taken 100 times
The average score is 4 of 10

Answer Stats

Question	Answer	% Correct
You would use _____ join to get the matching rows from two tables in a query	Inner	74%
The ___ clause is interpreted as a series of OR statements	IN	71%
____ join would create many to many relationships between tables.	CROSS	50%
Which schema typically holds information about the user-created tables?	information schema	47%
___ is also called a parameterized view	Table Value Function with Parameter	44%
Modern databases allow you to save the output from a block of SQL query into these constructs which don't take any space on disk	Common Table Expression	41%
The practice of checking if the table exists before creating it makes a SQL script ____	Idempotent	35%
If you want to distribute the rows in a table based on a certain key and order them by a primary key you would use ____ functions	Window	35%
You can specify the columns in a Common Table Expressions in the following way	with cte( columnA, columnB) as (select * from table)	32%
To profile data in a data the best way is to ____	Use Group by Business Key	12%

Score Distribution

Percent of People with Each Score

Percentile by Number Answered

Your Score History

You have not taken this quiz

Countries of the World Quiz

Random Capital to Country

NBA Basketball Teams Quiz

Country Flags Quiz #1

Brand Logos Quiz #1

NFL Football Teams Quiz

Elements of the Periodic Table

Countries that Start with A

Word Scramble - Countries

U.S. State Capitals Quiz

Europe Capitals Quiz