Consider a table named "orders" with columns "id", "date", "customer_id", "product_id", and "quantity". Write a SQL query to display the top 3 products that have been ordered the most.

SELECT product_id, SUM(quantity) as total_ordered FROM orders GROUP BY product_id ORDER BY total_ordered DESC LIMIT 3;

SELECT product_id, SUM(quantity) in total_orderedFROM ordersGROUP BY product_idORDER BY total_ordered ASC LIMIT 3;

SELECT product_id, SUM(quantity) as total_ordered FROM orders GROUP BY product_idORDER BY total_ordered DESC LIMIT BY 3;

Why are SQL functions used?

To perform some calculations on the data

To modify individual data itemsa

How can you select unique records from a table?

Select DISTINCT studentID from Student

Select * from Student WHERE studentID = UNIQUE

Select UNIQUE studentID from Student

Show only common records between two tables.

Select * from Student; Intersect Select * from StudentA;

Select * from Student Equals StudentA ;

Select * from Student; Join Select * from StudentA;

Find the cities name with the condition and temperature from table 'whether' where condition = sunny or cloudy but temperature >= 60.

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ AND temperature >= 60

SELECT city, temperature, condition FROM weather WHERE condition = 'cloudy' AND condition 'sunny' OR temperature >= 60

SELECT city, temperature, condition FROM weather WHERE condition 'cloudy AND temperature >= 60 'sunny' OR condition

Consider a table named "orders" with columns "id", "date", "customer_id", "product_id", and "quantity". Write a SQL query to display the top 3 products that have been ordered the most.

SELECT product_id, SUM(quantity) as total_ordered FROM orders GROUP BY product_id ORDER BY total_ordered DESCLIMIT 3;

SELECT product_id, SUM(quantity) by total_ordered FROM orders GROUP BY product_id ORDER BY total_ordered DESCLIMIT 3;

SELECT product_id, SUM(quantity) in total_ordered FROM orders GROUP BY product_id ORDER BY total_ordered DESCLIMIT 3;

Which of the following query is correct for using comparison operators in SQL?

SELECT name, course_name FROM student WHERE age>50 and age <80;

SELECT name, course_name FROM student WHERE age>50 and <80;

SELECT name, course_name FROM student WHERE age>50 and WHERE age<80;

Find all the tuples having temperature greater than 'Paris'.

SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = 'Paris')

SELECT FROM weather WHERE temperature > (SELECT FROM weather WHERE city = 'Paris')

SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = 'Paris')

SELECT * FROM weather WHERE temperature > 'Paris' temperature

What does the following query find? (SELECT DISTINCT r.sid FROM boats b, reserves r WHERE b.bid = r.bid AND b.color = 'red') MINUS (SELECT DISTINCT r.sid FROM boats b, reserves r WHERE b.bid = r.bid AND b.color = 'green')

Find the sailor IDs of all sailors who have reserved red boats but not green boats

Find the sailor IDs of at least one sailor who have reserved red boats but not green boats

Find the sailor Ids of atmost one sailor who have reserved red boats but not green boats

Which of the following is illegal?

SELECT SYSDATE - (SYSDATE + 2) FROM DUAL;

SELECT SYSDATE - (SYSDATE - 2) FROM DUAL;

SELECT SYSDATE - SYSDATE FROM DUAL;

Which of the following query will result in an error?

select dept_id, count(name) from employees;

select avg(salary) from employees group by dept_id;

select dept_id, job_id, avg(salary) from employees group by dept_id, job_id;

select dept_id, avg(salary) from employees group by dept_id;

Which of the following can replace the below query? SELECT Name, ID FROM Student, Courses WHERE Student_ID = Courses_ID;

Select Name, ID from Student natural join Courses;

Select Name,ID from Courses,Student where Student_ID = ID;

Select ID from Student join Courses;

Consider a table named "country" with columns "id", "name", "population", and "continent". Write a SQL query to display the name and population of the 3 most populous countries in Asia.

SELECT name, population FROM country WHERE continent = 'Asia' ORDER BY population DESC LIMIT 3;

SELECT name, population FROM country WHERE continent = 'Asia' GROUP BY population DESC LIMIT 3;

SELECT name, population FROM country WHERE continent == 'Asia' ORDER BY population DESC LIMIT 3;

SELECT name, population FROM country WHERE continent = 'Asia' ORDER BY population ASC LIMIT 3;

To display the detail of employee having „e‟ in their name in descending order of salary the correct SQL statement is :

SELECT * FROM emp WHERE ename LIKE '%e%' ORDER BY SAL DESC;

SELECT * FROM emp WHERE ename LIKE 'e%' ORDER BY SAL ;

SELECT * FROM emp ORDER BY SAL DESC WHERE ename LIKE '%e%' ;

SELECT * FROM emp WHERE ename LIKE '%e%' ORDER BY DESC SAL;

Difference between Commit and Rollback

COMMIT: user permanently save ROLLBACK: user undo those transactions that aren’t saved yet in the database.

COMMIT: user undo those transactions that aren’t saved yet in the database. ROLLBACK: user permanently save

COMMIT: user not permanently save ROLLBACK: user undo those transactions that are saved yet in the database.

COMMIT in SQL is a transaction control language command ROLLBACK in SQL is not a transaction control language command

Break the Query Round-1

Authored by HARIHARAN 20ITA13

Computers

University

Used 1+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

30 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Write the SQL query to get the third maximum salary of an employee from a table named employees.

SELECT * FROM(

SELECT employee_name, salary, DENSE_RANK()

OVER(ORDER BY salary DESC)r FROM Employee)

WHERE r=3;

SELECT * FROM(

SELECT employee_name, salary, DENSE_RANK()

OVER(ORDER BY salary ASC)r FROM Employee)

WHERE r=5;

SELECT * FROM(

SELECT employee, salary, DENSE_RANK()

OVER(GROUP BY salary )a FROM Employee)

WHERE r=2;

None of these

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If the SQL table has duplicate rows, the duplicate rows must be removed.
Let’s assume the following table as our dataset:

DELETE table WHERE ID IN (SELECT ID, COUNT(ID) FROM table ORDER BY ID HAVING COUNT (ID) > 5);

REMOVE FROM table where ID IN (SELECT ID, COUNT(ID) FROM table BY ID HAVING COUNT (ID) > 1);

DELETE FROM table WHERE ID IN (SELECT ID, COUNT(ID) FROM table GROUP BY ID HAVING COUNT (ID) > 1);

None of these

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Syntax for SQL CAST function

CAST(expression TO [data type])

CAST(expression AS [data type])

CAST(expression IN [data type])

CAST(expression FOR [data type])

MULTIPLE SELECT QUESTION

45 sec • 1 pt

What are the operators available in SQL?

Arithmetic Operators

Relational Operator

Logical

Operations

Comparison

Operators

MULTIPLE SELECT QUESTION

45 sec • 1 pt

The ways to get the count of records in a table?

SELECT * FROM table1

SELECT COUNT(*) FROM table1

None of these

SELECT rows FROM

sysindexes

WHERE id =

OBJECT_ID(table1) AND indid

< 2

FILL IN THE BLANK QUESTION

1 min • 1 pt

Write a SQL query to find the names of employees that begin with ‘A’?
Consider Table name and column name are emp_details and EmpName

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Consider a table named "employees" with columns "id", "name", "department", and "salary". Write a SQL query to display the names of employees who earn more than the average salary.

SELECT emp_name FROM employee WHERE salary > (SELECT AVG(salary) FROM employees);

All of these

SELECT name FROM employee WHERE salary < (SELECT AVG(salary) FROM employee);

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

25 questions

Understanding Loops in Programming

Quiz

•

University

25 questions

sheet 3

Quiz

•

University

25 questions

Computer Programming Midterms

Quiz

•

University

25 questions

COMP1: Quiz No. 1

Quiz

•

University

25 questions

Layering Models

Quiz

•

University

25 questions

Simple Machines

Quiz

•

KG - University

25 questions

Computer Application TQ1

Quiz

•

1st Grade - University

25 questions

Advanced Game Design Midterm

Quiz

•

University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

29 questions

Alg. 1 Section 5.1 Coordinate Plane

Quiz

•

9th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

11 questions

FOREST Effective communication

Lesson

•

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

Discover more resources for Computers

12 questions

IREAD Week 4 - Review

Quiz

•

3rd Grade - University

7 questions

Fragments, Run-ons, and Complete Sentences

Interactive video

•

4th Grade - University

7 questions

Renewable and Nonrenewable Resources

Interactive video

•

4th Grade - University

10 questions

DNA Structure and Replication: Crash Course Biology

Interactive video

•

11th Grade - University

5 questions

Inherited and Acquired Traits of Animals

Interactive video

•

4th Grade - University

5 questions

Examining Theme

Interactive video

•

4th Grade - University

20 questions

Implicit vs. Explicit

Quiz

•

6th Grade - University

7 questions

Comparing Fractions

Interactive video

•

1st Grade - University

Break the Query Round-1

Write the SQL query to get the third maximum salary of an employee from a table named employees.

If the SQL table has duplicate rows, the duplicate rows must be removed.Let’s assume the following table as our dataset:

Syntax for SQL CAST function

What are the operators available in SQL?

The ways to get the count of records in a table?

Write a SQL query to find the names of employees that begin with ‘A’?Consider Table name and column name are emp_details and EmpName

Consider a table named "employees" with columns "id", "name", "department", and "salary". Write a SQL query to display the names of employees who earn more than the average salary.

Consider a table named "orders" with columns "id", "date", "customer_id", "product_id", and "quantity". Write a SQL query to display the top 3 products that have been ordered the most.

Why are SQL functions used?

How can you select unique records from a table?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

If the SQL table has duplicate rows, the duplicate rows must be removed.
Let’s assume the following table as our dataset:

Write a SQL query to find the names of employees that begin with ‘A’?
Consider Table name and column name are emp_details and EmpName