Quiz 1

Due: Fri, 2 PM See Rules
×

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 (Medium)

Categories: SQL

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 (Easy)

Categories: SQL

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 (Easy)

Categories: SQL

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 (Medium)

Categories: SQL

"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 (Hard)

Categories: SQL

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 (Hard)

Categories: SQL

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 (Medium)

Categories: SQL

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 (Hard)

Categories: SQL

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 (Hard)

Categories: SQL

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 (Hard)

Categories: SQL

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