TomoLink
CompaniesAmazonDatabase ManagementSQL Queries & Joins
DBMS
SQL Queries & Joins

SQL Queries & Joins

dbmssqljoins
1 sections
dbms, sql

MCQ — SQL Fundamentals

Q1Easy

Which SQL clause is used to filter groups after GROUP BY?

Q2Easy

Which JOIN returns all rows from the left table, matching with right table where possible?

Q3Easy

What does the SQL query `SELECT COUNT(*) FROM Employees` return?

Q4Medium

Which is faster for finding existing rows: IN or EXISTS?

Q5Easy

What does the DISTINCT keyword do?

Q6Easy

How do you select rows where a column value is NULL?

Q7Medium

Which aggregate function ignores NULL values?

Q8Easy

What is the result of a CROSS JOIN between two tables with 3 and 4 rows respectively?

Q9Medium

Which clause is executed first in a SELECT statement?

Q10Easy

Which command permanently removes a table from the database?

Dbms Sql Queries Joins | Amazon Dbms | TomoLink