Featured Quizzes
User Quizzes
Create Quiz
Data and Charts
Word Search
Badges and Games
About JetPunk
Message Board
Dark Mode
SQL Quiz
SQL Quiz for database lovers
Rate:
Last updated: January 15, 2023
You have not attempted this quiz yet.
More quiz info >>
| First submitted | January 14, 2023 |
| Times taken | 100 |
| Average score | 40.0% | Report this quiz | Report |
4:00
The quiz is paused. You have remaining.
Copied!
Scoring
You scored / = %
This beats or equals
% of test takers
also scored 100%
The average score is
Your high score is
Your fastest time is
Keep scrolling down for answers and more stats ...
1. 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
Temporary Table
Table
Functions
2. You would use _____ join to get the matching rows from two tables in a query
Left
Full
Right
Inner
3. Which schema typically holds information about the user-created tables?
dbo
information schema
public
system
4. ___ is also called a parameterized view
Stored Procedure with Parameters
Scalar Function with Parameter
Table Value Function with Parameter
Deterministic Function with Parameter
5. 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
SQL
Window
Query
User-Defined
6. The ___ clause is interpreted as a series of OR statements
IN
APPLY
AND
HAVING
7. To profile data in a data the best way is to ____
Use Group by Business Key
Use Rank by Business Key
Use Group by Primary Key
Use Rank by Primary Key
8. ____ join would create many to many relationships between tables.
OUTER
CROSS
INNER
LEFT
9. The practice of checking if the table exists before creating it makes a SQL script ____
Unique
Idempotent
Atomic
Ephermal
10. You can specify the columns in a Common Table Expressions in the following way
with (columnA, columnB) from cte( ) as (select * from table)
with from cte() as (select * from table)(columnA, columnB)
with cte( columnA, columnB) as (select * from table)
with cte() as (select * from table)(columnA, columnB)
Save Your Stats
Your Next Quiz
How many countries do you know? In this quiz, you've got 15:00 to name as many as you can. Go!
Name all 50 states in the USA. Easy, right?
Fill in the map by guessing languages. When you guess a language, all the countries that use it as an official language will be filled in.
Can you guess the countries that have been mashed together in these images?
Comments
No comments yet
New and Popular