home

SQL Quiz

SQL Quiz for database lovers
Quiz by snktheone
Rate:
Last updated: January 15, 2023
You have not attempted this quiz yet.
More quiz info >>
First submittedJanuary 14, 2023
Times taken30
Average score40.0%
Report this quizReport
Quiz and answer stats >>
Friends stats >>
4:00
The quiz is paused. You have remaining.
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) ✓
Comments
No comments yet
Save Your Progress

Copyright H Brothers Inc, 2008–2024

Contact Us | Go To Top | View Desktop Site