SQL
SQL Mastery Quiz
Test your knowledge of SQL with our engaging quiz! Whether you're a beginner or an experienced database professional, this quiz is designed to challenge your understanding of SQL concepts and practices.
You will explore:
- SQL clauses and commands
- Data types and manipulation
- Joins and indexes
- Real-world applications of SQL
1. 'Having' clause is used with
Group By
Order By
Both of above
None of the above
2. Which of the following is the original purpose of SQL?
To specify the syntax and semantics of SQL data definition language
To specify the syntax and semantics of SQL manipulation language
To define the data structures
All of the above.
3. Which of the following do you need to consider when you make a table in SQL?
Data types
Primary keys
Default values
All of the above.
4. The SQL keyword BETWEEN is used:
For ranges.
To limit the columns displayed.
As a wildcard.
None of the above is correct
5. Which of the following is valid SQL for an Index?
CREATE INDEX ID;
CHANGE INDEX ID;
ADD INDEX ID;
REMOVE INDEX ID;
6. Which type of join returns all rows that satisfy the join condition?
Inner join
Outer join
Semi join
Anti-join
7. Find the temperature in increasing order of all cities
SELECT city FROM weather ORDER BY temperature;
SELECT city, temperature FROM weather;
SELECT city, temperature FROM weather ORDER BY temperature;
SELECT city, temperature FROM weather ORDER BY city;
8. Grant is a command from SQL type:
DDL
DCL
DML
All of the above
9. SQL Query and modification commands make up
DDL
DML
HTML
XML
10. The SQL keywords(s) _____ is used with wildcards.
LIKE only
IN only
NOTIN only
IN and NOT IN
{"name":"SQL", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Test your knowledge of SQL with our engaging quiz! Whether you're a beginner or an experienced database professional, this quiz is designed to challenge your understanding of SQL concepts and practices.You will explore:SQL clauses and commandsData types and manipulationJoins and indexesReal-world applications of SQL","img":"https:/images/course5.png"}