Adding SQL quiz questions

[jdwilkin4]

developerquiz.org currently has over 600 quiz questions. We are looking to expand on the SQL questions and we encourage other developers to add their quiz questions to the site.

You can find the complete list of questions below.
https://github.com/freeCodeCamp/Developer_Quiz_Site/blob/main/src/data/sql-quiz.ts

You can add your own questions to the top of that file.
Please first check to make sure your question doesn't already exist in the file before creating a PR.

Here is an example format for the questions.

  {
    Question:
      "Which of the following relational database management systems (RDBMS) should never be used to store data in a production app?",
    Answer: "Microsoft Access",
    Distractor1: "Microsoft SQL Server",
    Distractor2: "MongoDB",
    Distractor3: "PostgreSQL",
    Explanation:
      "Microsoft Access does not offer as much security, availability, and stability as SQL Server.",
    Link: "https://en.wikipedia.org/wiki/Microsoft_Access",
  },

For the link field, please make sure to use a freeCodeCamp article, freeCodeCamp YouTube video or official documentation.
If you choose to reference a video, please make sure to include the timestamp for the topic covered.

You can read more about how to create timestamps in this helpful article.

This issue will not be assigned to anyone and will remain open for multiple contributors.
Please do not assign yourself to this issue or close it.

Happy contributing!

[erictleung]

Some places to get questions from:

• https://www.edureka.co/blog/interview-questions/sql-interview-questions
• https://www.geeksforgeeks.org/sql-interview-questions/
• https://intellipaat.com/blog/interview-question/sql-interview-questions/
• https://mindmajix.com/sql-interview-questions
• https://www.toptal.com/sql/interview-questions

[jdwilkin4]

Hi @erictleung !

Even though these are respected tech blogs, we do also have to remember that we are competing with them in terms of google search rankings.
The goal is to have our projects promote our publication articles, youtube videos or official documentation over competing publications.
There is nothing wrong with those tech sites, but we also don't want to be providing them with more traffic to their sites.

So that's why we limit the scope of these questions to just our material or official docs. 👍

[erictleung]

@jdwilkin4 makes sense, thanks! That makes sense. I was thinking it is a place to get ideas for questions, but definitely link to freeCodeCamp resources when possible 👍

[raykotab]

Hi! I am trying to make my first contribution and I wonder:
Would a question about the NOW() SQL function be appropriate or too advanced in this case?

[jdwilkin4]

Hi @raykotab !

I think that question would work since the function returns the date and time.
I don't think it would be too advanced.

[raykotab]

Wonderful @jdwilkin4! Then i'll try my luck with my first PR.

[GulabSinghSikarwar]

@jdwilkin4 , I have added a few SQL questions. for this issue #203,

[IshuKrPathak]

Hello
loved to contribute on this repository.
Can you please assign me .

[jdwilkin4]

@Ishukumarpathak
This issue will not be assigned to anyone and will remain open for multiple contributors.
If you are interested in contributing, read through the contributing docs and create a PR with your questions 👍

[Nene-S]

Is it possible to add multi-choice question? and if yes what is the format?

[jdwilkin4]

@J-ell

Well the website is already following a multiple choice format

Can you explain more on what you mean by multiple choice?

[Nene-S]

I mean questions with more than one answers. for example:
In git which of the following syntax is used to add changes to the staging area or indexed? select all that apply
(a) git add file.txt
(b) git add .
(c) git mv file.txt
(d) git add
where the answer is both a and b

[jdwilkin4]

@J-ell

In that situation you would just write out "Both git add filename and git mv filename"

Our design doesn't support adding A), B), C) D) in front of the answers since we are just using buttons. 👍

[jdwilkin4]

If people have questions about this issue, or questions in general on how to contribute, please use the GitHub discussions area.
It will be easier to track conversations over there 👍

[jdwilkin4]

For anyone interested in contributing, please read through the contributing documentation first.