Featured Quizzes
User Quizzes
Create Quiz
Data and Charts
Word Search
Badges and Games
About JetPunk
Message Board
Dark Mode
SQL Quiz - Statistics
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%
|
No matching quizzes found
Score Distribution
Percent of People with Each Score
Percentile by Number Answered
Your Score History
You have not taken this quiz
New and Popular