SQL
Master Your SQL Skills
Test your knowledge of SQL with our comprehensive quiz designed for beginners and experts alike! This quiz covers essential concepts and commands that every SQL developer should know.
Challenge yourself with questions about:
• SQL basics
• Data manipulation
• Fun
• Database structures
1. What is the full form of SQL?
Structured Query Language
Structured Query List
Simple Query Language
None of these
2. Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
Data Definition Language(DDL)
Data Manipulation Language(DML)
Both of above
None
3. Which operator performs pattern matching?
BETWEEN operator
LIKE operator
EXISTS operator
None of these
4. What operator tests column for the absence of data?
EXISTS operator
NOT operator
IS NULL operator
None of these
5. In SQL, which command(s) is(are) used to change a table's storage characteristics?
ALTER TABLE
MODIFY TABLE
CHANGE TABLE
All of the above
6. A command that lets you change one or more fields in a record is
Insert
Modify
Look up
None of these
7. Which SQL keyword is used to retrieve a maximum value?
TOP
MOST
MAX
None of these
8. What is a view?
A view is a special stored procedure executed when certain event occurs.
A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are
A view is a database diagram
None of these
9. The SQL statement SELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL;
6789
2345
1234
456789
10.Which of the following group functions ignore NULL values?
MAX
COUNT
SUM
All Of the above
{"name":"SQL", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Test your knowledge of SQL with our comprehensive quiz designed for beginners and experts alike! This quiz covers essential concepts and commands that every SQL developer should know.Challenge yourself with questions about:• SQL basics• Data manipulation• Functions and operators• Database structures","img":"https:/images/course3.png"}