Online SQL Quiz for Programmers

Which of the following triggers are not available for MySQL?

Which of the query below is used to put a value in a variable we need to define for our SQL query?

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.

Write a query to find the company domain mail-id of each employee at DataFlair. Given the company domain being @dataflair.com.

In SQL the package definition is made up of which two elements?

What are the data definition commands in SQL known as popularly?

Which type of join is the query written below?
SELECT *
FROM tableName1
INNER JOIN tableName2
ON tableName1.matchingColumn = tableName2.matchingColumn ;

What is the major difference in the operation of the UNION and UNION ALL clause in SQL?

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?

Which of the following query if run will Truncate the DataFlair table?

Write a query in SQL using just two words to extract the time of the system as of now?

Write a query to find the second employee in terms of experience in increasing order? (first being the one with max experience)

We can’t use subqueries with which of the clauses given below?

Which of the following is a type of subquery we can use in SQL?

Which of the following is not a built-in function in SQL?

What is the difference if we truncate a table and if we drop a table?

Which of the below queries can be used to rename the table DataFlair to DataFlair_Info?

Which of the following query is correct to perform union on DataFlair and location tables?

Which all languages support the integration of SQL with them?

When the SQL query is executed the result is?

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).

Write a query to draw out details of all the employees whose name starts with ‘A’ or are based in Pune.

Which of the following query returns the results in ascending order of the experience column?

Which of the following is the type of trigger available in SQL?

What is the major difference between the implicit and explicit cursor?