SQL
Master Your SQL Skills
Test your knowledge of SQL with our engaging quiz designed for both beginners and experienced users. Challenge yourself with 10 thought-provoking questions that cover a range of SQL topics.
Features of the quiz:
- 10 multiple-choice questions
- Immediate feedback on your answers
- Enhance your understanding of SQL concepts
1. Select __________ from instructor where dept name= ’Comp. Sci.’; Which of the following should be used to find the mean of the salary ?
A) Mean(salary)
B) Avg(salary)
C) Sum(salary)
D) Count(salary)
2. Point out the correct statement :
A) SQL Server books online is part of Microsoft SQL Server 2012
B) SQL Server books online is not a part of Microsoft SQL Server 2008
C) Resource database is part of System database
D) None of the mentioned
3. CREATE FUNCTION requires __________ permission in the database.
A) ALTER
b) DROP
C) DELETE
D) All of the mentioned
4. How many types of DML triggers are present in SQL Server ?
A) 1
B) 3
C) 5
D) None of of the mentioned
5. Which of the following is not the function of client ?
A) Result formatting and presentation
B) Receive queries
C) Query optimization
D) Compile queries
6. ____________ rolls back a user-specified transaction to the beginning of the transaction.
A) ROLLBACK
B) ROLLBACK WORK
c) SAVE TRANSACTION
d) COMMIT
Point out the correct statement :
A) JDBC use parameter markers
B) When forced parametrization is tried but fails, simple parametrization is still subsequently tried
C) Parameter markers are question marks (?) that replace a constant in an SQL statement
D) All of the mentioned
8. Which of the following foreign key constraint specifies that the deletion fails with an error ?
a) NO ACTION
B) CASCADE
C) SET NULL
D) All of the mentioned
9. _________ permissions default to any valid user.
A) ROLLBACK
B) ROLLBACK WORK
C) COMMIT
D) None of the mentioned
10. The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.
A) Where, from
B) From, where
C) Select, from
D) From, select
{"name":"SQL", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Test your knowledge of SQL with our engaging quiz designed for both beginners and experienced users. Challenge yourself with 10 thought-provoking questions that cover a range of SQL topics.Features of the quiz:10 multiple-choice questionsImmediate feedback on your answersEnhance your understanding of SQL concepts","img":"https:/images/course8.png"}