SQL Practice Questions - Free SQL Quiz (2023 Update)
Explore Online Courses
Free Courses
Interview Questions
Tutorials
Community
Courses
Free Courses
Interview Questions
Tutorials
Community
Take the Free SQL Practice Test
Instructions:
FREE test and can be attempted multiple times.
60 Minutes
30 Multiple Choice Questions
Fill in the Details to Get Started
Select your preference
Self-learning and knowledge validation
Completed a course & revising
Just curious
By providing your contact details, you agree to our
Terms of Use
&
Privacy Policy
Welcome to your SQL Quiz
Which of the following comes under Data Control Language?
Create, Alter, Drop
select
insert, update, delete
grant, revoke
Which of the following comes under Data Manipulation Language?
Create, Alter, Drop
select
insert, update, delete
grant, revoke
Full form of SQL
Structured Queue Langauge
Structured Query Language
Sequel Queue Language
Structured Queue Langauge
The data in an RDBMS is stored in database objects which are called as
Column
Records
Table
Fields
A collected information which is in an organized form for easier access, management, and various updating is known as
Database
SQL Query
Data structure
RDMS
Which mode allows us for the collection and uploading of data to occur on demand?
Non-cached mode
Cached mode
Mixed mode
All of the mentioned
Which is not a data type in SQL?
FLOAT
NUMERIC
DECIMAL
LARGEINT
What does Dataware house do?
Enterprise Wide data
Multiple subject areas
Occupies large memory
All the above
Conceptual model design is
Only entities visible
No entities visible
Normalization occurs at this level
Foreign keys are specified
What does a foreign key do?
Uniquely identifies a row/record in any another database table
The CHECK constraint ensures that all values in a column satisfy certain conditions
Uniquely identifies each row/record in a database table
Provides a default value for a column when none is specified
Syntax to create database
create database_name
create database database_name
database_name create
create database
Which datatype would get 8000 maximum characters both variable length and non code data
char
varchar
varchar(max)
text
What does 2nf do?
no partial dependences
put related columns into their own table
All non primary fields are dependent on the primary key
Eliminating redundant data
Which of the following constraint ensures that all the values in a column are different
CHECK Constraint
DEFAULT Constraint
UNIQUE Constraint
NOT NULL Constraint
LIKE clause is used to compare a value to similar values using
assignment operator
arithmetic operator
wildcard operator
logical operator
The syntax of select statement is select*from table_name
True
False
WHERE SALARY LIKE '100%'
Finds any values that start with 100
Finds any values that have 100 in any position
Finds any values that end with 2
Finds any values that start with 1 and end with 0
SQL AND & OR operators are called as
wildcard operators
conjoin operators
temporary operators
conjuctive operators
The percent sign (%) in wild card operator:
Matches one or more characters
Matches one character
Get the elements in-between characters
Return none
Which would combine two or more rows
unions
joins
truncate table
Transactions
Is below query the syntax for update statement UPDATE table_name SET column1 = value1, column2 = value2...., columnN = valueN
True
False
Which command is used to delete complete data from an existing table.
delete
del
truncate
remove
Write the syntax for or operator with where clause _____
select from table where statement 1 or statement 2
select * from table where statement 1 or statement 2
select where from table statement 1 or statement 2
none
What does inner join do?
returns rows when there is a match in both tables
returns all rows from the left table, even if there are no matches in the right table
returns all rows from the right table, even if there are no matches in the left table
returns rows when there is a match in one of the tables
Which clause is similar to “HAVING” clause
SELECT
WHERE
FROM
None of the mentioned
The SQL GROUP BY clause is used in collaboration with the
insert
where
select
having
What does Union statement do?
select same number of columns
select same number of column expressions
select same data type
all the above
What is the meaning of “GROUP BY” clause
Group data by column values
Group data by row values
Group data by column and row values
None of the mentioned
What does having clause do?
remove values from data
add values to data
add specify conditions that filter which group results
get filter to data
CREATE PROCEDURE statements cannot be combined with other SQL statements in a single batch.True or False?
True
False
Time is Up!