SQL Online Quiz with Answers
SQL is sometimes called the language of analytics. And analysing things is the primary nature of human beings. Let us now move ahead and collectively check our skills in the analytics domain.
Without wasting any further time let us start with our SQL Online quiz now.
0 of 25 Questions completed
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
0 of 25 Questions answered correctly
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
- Review / Skip
Which of the following triggers are not available for MySQL?CorrectIncorrect
Which of the query below is used to put a value in a variable we need to define for our SQL query?CorrectIncorrect
Write a query to display the base pay and name of each employee at DataFlair using the following formula to calculate base pay:
BP = 20000 + (experience*5000)
Also, display the results with the highest-paid employee being the first.CorrectIncorrect
Write a query to find the company domain mail-id of each employee at DataFlair. Given the company domain being @dataflair.com.CorrectIncorrect
In SQL the package definition is made up of which two elements?CorrectIncorrect
What are the data definition commands in SQL known as popularly?CorrectIncorrect
Which type of join is the query written below?
INNER JOIN tableName2
ON tableName1.matchingColumn = tableName2.matchingColumn ;CorrectIncorrect
What is the major difference in the operation of the UNION and UNION ALL clause in SQL?CorrectIncorrect
Which of the queries below can be used to alter the DataFlair table such that we can add a new gender column to our table?CorrectIncorrect
Which of the following query if run will Truncate the DataFlair table?CorrectIncorrect
Write a query in SQL using just two words to extract the time of the system as of now?CorrectIncorrect
Write a query to find the second employee in terms of experience in increasing order? (first being the one with max experience)CorrectIncorrect
We can’t use subqueries with which of the clauses given below?CorrectIncorrect
Which of the following is a type of subquery we can use in SQL?CorrectIncorrect
Which of the following is not a built-in function in SQL?CorrectIncorrect
What is the difference if we truncate a table and if we drop a table?CorrectIncorrect
Which of the below queries can be used to rename the table DataFlair to DataFlair_Info?CorrectIncorrect
Which of the following query is correct to perform union on DataFlair and location tables?CorrectIncorrect
Which all languages support the integration of SQL with them?CorrectIncorrect
When the SQL query is executed the result is?CorrectIncorrect
Write a query to find the average pay of employees at Dataflair assuming that the pay of each is calculated by the formula Pay = (experience*1.5*10000).CorrectIncorrect
Write a query to draw out details of all the employees whose name starts with ‘A’ or are based in Pune.CorrectIncorrect
Which of the following query returns the results in ascending order of the experience column?CorrectIncorrect
Which of the following is the type of trigger available in SQL?CorrectIncorrect
What is the major difference between the implicit and explicit cursor?CorrectIncorrect
With this, we end the SQL Online Quiz. Knowledge of all SQL Topics in-depth would help you score high in your tests and soar up in your upcoming interviews. All the best!