SQL Quiz


Play this quiz that will help you to excel in SQL certification exams, placements etc. This SQL quiz consist of 10 questions that you need to solve in 10 minutes. We’ve specially designed this quiz so that you can quickly acquaint to the pattern of questions you can be asked in placement drives, certification exams etc. This SQL test enables you to assess your knowledge of SQL.

Take the Free Practice Test



SQL MCQs

Practice DBMS (SQL) MCQ Questions, which will help you to understand Database related concepts and also helps you to prepare for placements, technical rounds, interviews, competitive exams etc.

SQL Quiz

Try Free SQL Quiz, to start a quiz you need to login first, after login you will get start quiz button and then by clicking on that you can start quiz. You will get 10 Minutes to answer all questions.

SQL Quiz

1. The variables in the triggers are declared using

-
@
#
$

2. To specify a normal join, using the keyword inner is?

Mandatory
Optional
Independent
Free

3. Point out the wrong statement.

We can have an INSTEAD OF insert/update/delete trigger on a table that successfully executed
DML Triggers are used to evaluate data after data manipulation using DML statements
INSTEAD OF triggers cause their source DML operation to skip
AFTER triggers cause their source DML operation to skip

4. Determine data type for the given column? Column Name: Price ; Description: Cost of an item in rupees and paise ; Example: 200.21

VARCHAR2(50)
NUMBER
NUMBER(5,2)
NUMBER(6)

5. Which of the following statements are TRUE regarding subqueries?

A subquery can retrieve zero or more rows
A subquery can appear on either side of a comparison operator
There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement
Both A and B

6. Stack is also called __________

First In First Out (LIFO)
Last In First Out (LIFO)
First In Last Out (FILO)
First Come First Served (FCFS)

7. Which of the following statement(s) is/are FALSE about OLAP?

OLAP involves long running slow transactions that read lot of data
OLAP involves frequent insert, update and delete operations
OLAP requires data to be in De-Normalized form for optimal processing
Both B and C

8. What is syntax for delete the view?

DELETE VIEW view_name;
DROP VIEW view_name/table_name;
DROP VIEW view_name;
DROP VIEW table_name;

9. Which of the following is the syntax for views where v is view name?

Create view v as "query name";
Create "query expression" as view;
Create view v as "query expression";
Create view "query expression";

10. Which statement is TRUE regarding ALTER statement?

ALTER TABLE cannot be used to remove a column
ALTER table can be used to change size of data type, not the data type itself
ALTER table can be used to add a column but it must be NOT NULL
None of the above

Results