freetimelearn@gmail.com
Facebook
Twitter
Linkedin
Google
HOME
TUTORIALS
BASICS OF COMPUTER SCIENCE
HTML
HTML5
CSS
CSS3
BOOTSTRAP
BOOTSTRAP 4
MATERIALIZE CSS
JAVASCRIPT
JQUERY
AJAX
ANGULARJS
C - LANGUAGE
JAVA
PHP
PYTHON
REFERENCES
PRACTICE TEMPLATES
Bootstrap Templates
PHP PROJECTS
Bootstrap 3 Plugins
Bootstrap 4 Plugins
PLUGINS
Static Menus
Responsive Menus
Dropdown
Tabs & Pills
Modal Boxes (Dialog box)
Gallery Plugins
Sliders
Buttons
Dynamic Forms
Forms
Image Effects
Examples
HTML
HTML5
CSS
CSS3
BOOTSTRAP3
JAVASCRIPT
JQUERY
ANGULARJS
INTERVIEW QUESTIONS
New
QUIZ
New
MORE
Online HTML Editor
New
GENERAL KNOWLEDGE
New
SCHOOL MATHEMATICS
Blog
SQL QUIZ
Home
/
SQL Quiz
Online Quiz
HTML & HTML5 Quiz
Section 1
Section 2
Section 3
Section 4
Section 5
Section 6
CSS & CSS3 Quiz
Section 1
Section 2
Section 3
Section 4
Section 5
Bootstrap3 & 4 Quiz
Section 1
Section 2
Section 3
Section 4
Section 5
Materialize CSS Quiz
Section 1
Section 2
Section 3
JavaScript Quiz
Section 1
Section 2
Section 3
Section 4
Section 5
jQuery Quiz
Section 1
Section 2
Section 3
Section 4
Section 5
Ajax Quiz
Section 1
Section 2
Section 3
AngularJS Quiz
Section 1
Section 2
Section 3
Section 4
Section 5
Section 6
C Language Quiz
Section 1
Section 2
Section 3
Section 4
Section 5
Section 6
Section 7
PHP Quiz
Section 1
Section 2
Section 3
Section 4
Section 5
Section 6
Section 7
Section 8
Java Quiz
Section 1
Section 2
Section 3
Section 4
Section 5
Section 6
Section 7
Python Quiz
Section 1
Section 2
Section 3
Section 4
Section 5
Section 6
Angular Quiz
Node JS Quiz
React JS Quiz
SQL Quiz
1 .
A view is which of the following?
A)
A virtual table that can be accessed via SQL commands
B)
A virtual table that cannot be accessed via SQL commands
C)
A base table that cannot be accessed via SQL commands
D)
A base table that can be accessed via SQL commands
Correct Answer :
Option (A)
A virtual table that can be accessed via SQL commands
Show Answer
2 .
The SQL keyword(s) ________ is used with wildcards.
A)
IN only
B)
LIKE only
C)
NOT IN only
D)
IN and NOT IN
Correct Answer :
Option (B)
LIKE only
Show Answer
3 .
Which of the following is one of the basic approaches for joining tables?
A)
Subqueries
B)
Union Join
C)
Natural join
D)
All of the above
Correct Answer :
Option (D)
All of the above
Show Answer
4 .
Which of the following statements is true concerning subqueries?
A)
Involves the use of an inner and outer query.
B)
Does not start with the word SELECT.
C)
Cannot return the same result as a query that is not a subquery.
D)
All of the above.
Correct Answer :
Option (A)
Involves the use of an inner and outer query.
Show Answer
5 .
The command to eliminate a table from a database is:
A)
REMOVE TABLE CUSTOMER;
B)
DROP TABLE CUSTOMER;
C)
DELETE TABLE CUSTOMER;
D)
UPDATE TABLE CUSTOMER;
Correct Answer :
Option (B)
DROP TABLE CUSTOMER;
Show Answer
6 .
Which of the following is the correct order of keywords for SQL SELECT statements?
A)
SELECT, FROM, WHERE
B)
FROM, WHERE, SELECT
C)
WHERE, FROM,SELECT
D)
SELECT,WHERE,FROM
Correct Answer :
Option (A)
SELECT, FROM, WHERE
Show Answer
7 .
Which of the following is a correlated subquery?
A)
Uses the result of an inner query to determine the processing of an outer query.
B)
Uses the result of an outer query to determine the processing of an inner query.
C)
Uses the result of an inner query to determine the processing of an inner query.
D)
Uses the result of an outer query to determine the processing of an outer query.
Correct Answer :
Option (B)
Uses the result of an outer query to determine the processing of an inner query.
Show Answer
8 .
ON UPDATE CASCADE ensures which of the following?
A)
Normalization
B)
Data Integrity
C)
Materialized Views
D)
All of the above.
Correct Answer :
Option (B)
Data Integrity
Show Answer
9 .
A subquery in an SQL SELECT statement is enclosed in:
A)
braces -- {...}.
B)
parenthesis -- (...) .
C)
brackets -- [...].
D)
CAPITAL LETTERS.
Correct Answer :
Option (B)
parenthesis -- (...) .
Show Answer
10 .
SQL data definition commands make up a(n) ________ .
A)
DDL
B)
DML
C)
HTML
D)
XML
Correct Answer :
Option (A)
DDL
Show Answer
Finish Quiz
1
2
3
4
5
6
7
8
9
10
Prev Section
Next Section
Online Quiz
HTML & HTML5 Quiz
Section 1
Section 2
Section 3
Section 4
Section 5
Section 6
CSS & CSS3 Quiz
Section 1
Section 2
Section 3
Section 4
Section 5
Bootstrap3 & 4 Quiz
Section 1
Section 2
Section 3
Section 4
Section 5
Materialize CSS Quiz
Section 1
Section 2
Section 3
JavaScript Quiz
Section 1
Section 2
Section 3
Section 4
Section 5
jQuery Quiz
Section 1
Section 2
Section 3
Section 4
Section 5
Ajax Quiz
Section 1
Section 2
Section 3
AngularJS Quiz
Section 1
Section 2
Section 3
Section 4
Section 5
Section 6
C Language Quiz
Section 1
Section 2
Section 3
Section 4
Section 5
Section 6
Section 7
PHP Quiz
Section 1
Section 2
Section 3
Section 4
Section 5
Section 6
Section 7
Section 8
Java Quiz
Section 1
Section 2
Section 3
Section 4
Section 5
Section 6
Section 7
Python Quiz
Section 1
Section 2
Section 3
Section 4
Section 5
Section 6
Angular Quiz
Node JS Quiz
React JS Quiz
SQL Quiz
Follow Us on Facebook