SQL

A brightly colored digital illustration showing various elements of SQL, such as tables, databases, and code snippets, with a backdrop of a computer screen displaying SQL queries.

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

10 Questions2 MinutesCreated by QueryMaster42

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

Master Your SQL Skills

More Quizzes