SQL Online Quiz Questions and Answers

Consider the below-shown database and write a query to get the employee details whose name starts with ‘A’.

Consider the below-shown database and write a query to find the average experience of all the employees at DataFlair.

Consider the below-shown database and write a query to draw out details of employees from Pune and Indore with experience of 2 years or more in DataFlair.

Consider the below-shown database and write a query to count the number of employees at each location of the DataFlair office.

Consider the below-shown database and write a query to display the top 5 employees based on their experience of working in the field.

Which of the query below is likely to run into an error?

Which of the below queries results have only 10 rows being shown in the result displayed?

Which of the following commands do we need to run to select a database for our queries to be run on?

Predict the expected output of the query given below:
SELECT salary*10 AS New_Salary FROM DataFlair;

What happens when we run the below query but emp_id ‘AR5’ doesn’t exist in our table.
SELECT * FROM DataFlair_info WHERE emp_id = ‘AR5’

Which of the below Query can be used to set the new Auto – increment value to 500 in our table.

Which of the following returns the average value of any numeric column in SQL?

Choose the correct query using the IFNULL function of SQL to replace the NULL value in the experience column of DataFlair with 0.

Which of the following query uses the Default constraint to set the default value of experience to 0?

Which of the following query returns the unique records in our table DataFlair?

Write a query to grab the current time of the system?

We can use nesting in the stored procedures for?

Which of the below is an invalid query?

Which of the following network protocols needs to be enabled to allow SQL to access the IP address of the system?

Below are some constraint classes of SQL given. Find the one which is not a constraint class in SQL.

Which of the below is not a supported date or time format in SQL?

What is one major problem of creating indexes in SQL?

Write a query to create a view or virtual table and view it, from the DataFlair table named DataFlair_Indore with all the details of the Indore office.

Write a query to count the number of non-matching records in the DataFlair table?

What is the one thing we need to pay attention to when we need to use constraints?