SQL
Master SQL Quiz
Test your SQL knowledge with our engaging quiz designed for beginners and seasoned database enthusiasts alike. Challenge yourself with questions covering a range of SQL topics, including basic syntax, fun
- Multiple-choice questions
- Learn while you play
- Improve your SQL skills
1 - What is returned by MOD(1000,30)?
A - 33
B - 30
C - 3
D - 10
2. What does SQL stand for?
A) Structured Query Language
B) Strong Question Language
C) Structured Question Language
3 - Which of the following is not true about Natural Joins?
A - Natural join is based on all columns in two tables having same name
B - It selects rows from the two tables having different values in the matched columns.
C - If columns having same names have different data types, it returns error.
D - None of the above. Show Answer
4 - Which of the following is not true about the MAX and MIN functions?
A - Both can be used for any data type.
B - MAX returns the maximum value.
C - MIN returns the minimum value.
D - All are true.
5 - Which of the following is not true about inserting news rows to a table?
A - The INSERT INTO statement is used for inserting new rows to a table
B - You cannot insert rows with NULL values to a table.
C - You may insert a new row containing values for each column.
D - All of the above
6 - Which of the following is true about the CREATE TABLE statement?
A - This is a DML statement.
B - This statement also record information in the data dictionary.
C - You don’t need any privilege to use this statement.
D - All of the above.
7 - Which of the following minimal code would create a sequence named loc_seq as a primary key of the LOCATIONS table?
A - create sequence loc_seq;
B - create sequence loc_seq on locations;
C - create loc_seq;
D - None of the above.
8- Which of the following code would create a role named student_admin?
A - CREATE student_admin;
B - GRANT student_admin;
C - CREATE ROLE student_admin;
D - ROLE student_admin;
9. Which SQL statement is used to extract data from a database?
A- SELECT
B- OPEN
C- GET
D- EXTRACT
10 - Which SQL statement is used to update data in a database?
A- MODIFY
B- UPDATE
C- SAVE AS
D- SAVE
{"name":"SQL", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Test your SQL knowledge with our engaging quiz designed for beginners and seasoned database enthusiasts alike. Challenge yourself with questions covering a range of SQL topics, including basic syntax, functions, and best practices.Multiple-choice questionsLearn while you playImprove your SQL skills","img":"https:/images/course5.png"}