STRUCTURED QUERY LANGUAGE TEST

Progress

1.

Which one is a non-relational database?

2.

What is the SQL query used to retrieve all the data from the customer table?

3.

 Which of the following is the original purpose of SQL?

4.

Which of the following database cannot be dropped?

5.

In SQL, which command is used to change a table's storage characteristics?

6.

We can use one table to create another table using the below query. True or False ?

CREATE TABLE TestTable AS

SELECT customername, contactname

FROM customers;

7.

What can be the condition in the "WHERE" clause in a SQL query?

8.

The HAVING clause does which of the following?

9.

Which command is used to change the definition of a table in SQL ?

10.

Select ________ dept_name from instructor; 

Here which of the following displays the unique values of the column?

11.

What is the significance of the statement “HAVING COUNT (emp_id)>2” in the following MySQL statement?

SELECT d.name, COUNT (emp_id) emp_no  
FROM department d INNER JOIN Employee e  
ON d.dept_id=e.emp_id      
GROUP BY d.name      
HAVING COUNT (emp_id)>2    

12.

If you don't specify ASC or DESC after a SQL ORDER BY clause, the following is used by default

13.

What is the meaning of the “HAVING” clause in MySQL?

14.

Identify the average salary of the jobs 'MANAGER' and 'ANALYST'. Display job, average salary if the identified average salary is more than 1500.

15.

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

16.

Select two options which do not belong to the Purpose of Delete

17.

Analyse the following Query and Mark the answer whether it's the correct query or not?

SELECT Name, Age, Firstname, Lastname
FROM EMPLOYEE     
GROUP BY NAME, SALARY;  

18.

Find the names of the countries whose condition is sunny

19.

Find all the cities whose humidity is 89

20.

Which syntax is used for Drop Index (idx_pname) from the Person table in MYSQL?

21.

You can delete a view with _____________ Command.

22.

Find the name of these cities with temperature and condition whose condition is neither sunny nor cloudy

23.

How to create index idx_pname for multiple columns (Lastname, Firstname) in a Person table?

24.

Select ID, name, dept name, salary * 1.1 where instructor;

The query given below will not give an error. Which one of the following has to be replaced to get the desired output?

25.

The SQL WHERE clause used for 

26.

If emp_id contains the following set {-1, -2, 2, 3, -3, 1}, what will be the output on the execution of the following MySQL statement?

SELECT emp_id
FROM person
ORDER BY emp_id;

27.

Which SQL Query is used for updating the ContactName in the Customers table?

28.

What is the significance of the statement of the below query?

SELECT branch_name, COUNT (DISTINCT customer_name)     
FROM depositor, account           
WHERE depositor.account_number = account.account_number   
GROUP BY branch_id          

29.

Select ID, GPA from student grades order by GPA ____________.

In order to give only 10 ranks, on the whole, we should use.

30.

Analyze the following Query and Mark the answer whether it's a correct query or not?

Select OrderID, Shipdate
From Orders  
Where CustomerID=20
Order by Shipdate;

31.

Can you validate the statement?

An ORDER BY can be used in a subquery.

True or False?

32.

What is "Subquery"?

33.

Which of the following statement(s) is TRUE regarding subqueries?

34.

Which of the following is true about sub-queries?

35.

Which of the following multi-row operators can be used with a sub-query?

36.

A ______ index is created based on only one table column.

37.

A Key which is a set of one or more columns that can identify a record uniquely is called?

38.

Does an Index help to speed up?

39.

Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?

40.

Can you validate the statement?

We can use the index on columns that contain a high number of NULL values.

True or False?

41.

Below image depicts:

42.

How many tables may include with a join? 

43.

What are the joins available in SQL?

44.

Analyze the following tables and output and choose the correct query to achieve the output.

45.

Analyze the following tables and output and choose the correct query to achieve the output.

46.

In the absence of WHERE condition this JOIN will function like a _______.

47.

List all orders, showing order number, customer name and credit limit of a customer.

Orders Table:  
Order_Number, Customer, Product_Amount
Customers Table:  
Customer_Number, Customer_Name, Credit_Limit

 Which of the below query satisfy the above question?

48.

Choose the correct query for the below scenario.

 

49.

What is the syntax for joining two tables? Pick Two

50.

Can you validate the statement?

Join is different from Inner join.

True or False?

51.

Use below table (Salesemployee) and answer the following question
What is the output of following query ?
SELECT SUM(Salary) from Salesemployee 
where Name = 'Tom';  

 

52.

Use below table (Salesemployee) and answer the following question
What is the output of following query ?
SELECT Count(*) from Salesemployee 
WHERE Salary >=500 and Dept = 'Marketing';

 

53.

Use below table (Salesemployee) and answer the following question
What is the output of following query ?
SELECT Count(*) from Salesemployee 
WHERE Salary >=500 and Dept = 'Sales';

 

54.

Use below table (Salesemployee) and answer the following question
What is the output of following query ?
SELECT Count(*) from Salesemployee 
WHERE Salary >500;  

 

55.

The SQL Statement

SELECT ROUND(45.926, -1) FROM DUAL;

56.

Use below table (Salesemployee) and answer the following question
What is the output of following query ?
SELECT COUNT(*) from Salesemployee 
WHERE Employee_ID % 2 <> 0 ;  

 

57.

Use below table (Salesemployee) and answer the following question
What is the output of following query?
SELECT MIN(Salary) from Salesemployee 
WHERE Gender = 'Female';  

 

58.

Use below table (Salesemployee) and answer the following question
What is the output of following query ?  
SELECT MIN(Salary) from Salesemployee   
WHERE Employee_ID % 2 != 0 ;    

 

59.

Use below table (Salesemployee) and answer the following question
What is the output of following query ?
SELECT Count(Salary) from Salesemployee 
where name Like 'S%';

 

60.

Use below table (Salesemployee)  and answer the following question

What is the output of the following query?

SELECT SUM(Salary) from Salesemployee     
WHERE Gender = 'Male';      
        

Assessment complete! Thank you for you time.
We are redirecting you to the result page, Please click on 'SUBMIT'