Question Practice

Which query effectively filters results from DANCE and MUSIC tables based on both conditions being met?

Attempt the question, check the explanation, and continue with similar questions to build confidence before exams.

MCQ_SA

Single Answer MCQ

Q-00093892

SELECT * FROM DANCE, MUSIC WHERE DANCE.class = '7A' AND MUSIC.class = '8A'

SELECT * FROM DANCE INNER JOIN MUSIC ON DANCE.class = MUSIC.class

SELECT * FROM DANCE JOIN MUSIC WHERE DANCE.Name = MUSIC.Name

SELECT * FROM DANCE, MUSIC WHERE DANCE.Name = MUSIC.Name AND DANCE.class = '7A'

Video Explanation

Watch Video Solution

Keep Practising

Students who asked this also explored

Continue with nearby questions to strengthen the same chapter concept while you still have the context fresh in mind.

Q1.

What command is used to retrieve data from a database?

Q2.

Which SQL function can be used to count the number of rows in a query?

Q3.

To sort query results in descending order, which keyword should be used?

Q4.

What type of SQL function is CONCAT()?