Quiz 1

Due: 4 PM, Wed, 2099-12-31

×

Quiz Rules

  • First place = 1 'Bragging-Right-Card' & 10 'Bragging-Right-Cards' = Gift Card Prize!
  • Think for yourself. Looking up anything = cheating.
  • Spelling errors should not affect score, but try your best.
  • Answers should only contain letters, numbers, and spaces. No special characters.
  • Answers should not be more than 100 characters.
  • Email: [email protected] with any feedback.

Triviafy

Q1: DB Type

Categories: SQL

Difficulty: Medium

SQL is a programming language that is used by most _____ database management systems.

Triviafy question image

Hint: Manage data stored in tabular form.

To Answer Quiz Questions: Create Account > Add To Slack > Select your team's Slack channel.

Q2: Fundamentals

Categories: SQL

Difficulty: Easy

If used, the SQL _____ clause always comes at the end of a query.

Triviafy question image

Hint: no hint

To Answer Quiz Questions: Create Account > Add To Slack > Select your team's Slack channel.

Q3: Fundamentals

Categories: SQL

Difficulty: Easy

If your SQL statement contains an aggregation you must use the _____ clause.

Triviafy question image

Hint: no hint

To Answer Quiz Questions: Create Account > Add To Slack > Select your team's Slack channel.

Q4: Read Code

Categories: SQL

Difficulty: Medium

"t3" is considered a _____.

Triviafy question image

Hint: no hint

To Answer Quiz Questions: Create Account > Add To Slack > Select your team's Slack channel.

Q5: Sorting

Categories: SQL

Difficulty: Hard

What is the SQL code missing to print age from greatest to least?

Triviafy question image

Hint: no hint

To Answer Quiz Questions: Create Account > Add To Slack > Select your team's Slack channel.

Q6: Query Skills

Categories: SQL

Difficulty: Hard

What is the missing SQL code in order to update the "logintable" email for this specific user?

Triviafy question image

Hint: no hint

To Answer Quiz Questions: Create Account > Add To Slack > Select your team's Slack channel.

Q7: Cannot Undo

Categories: SQL

Difficulty: Medium

What is the missing SQL code to delete the "users_table" and all of its data?

Triviafy question image

Hint: no hint

To Answer Quiz Questions: Create Account > Add To Slack > Select your team's Slack channel.

Q8: Bug Fix

Categories: SQL

Difficulty: Hard

What word(s) is/are missing in this SQL statement?

Triviafy question image

Hint: no hint

To Answer Quiz Questions: Create Account > Add To Slack > Select your team's Slack channel.

Q9: Join

Categories: SQL

Difficulty: Hard

What type of join is this?

Triviafy question image

Hint: no hint

To Answer Quiz Questions: Create Account > Add To Slack > Select your team's Slack channel.

Q10: New Row

Categories: SQL

Difficulty: Hard

What is the missing SQL code to add a new row to the "userstable"?

Triviafy question image

Hint: no hint

To Answer Quiz Questions: Create Account > Add To Slack > Select your team's Slack channel.

Share This Quiz PDF With Team
Logo cheering purple