
SQL and Database Concepts Quiz
Quiz
•
English
•
University
•
Practice Problem
•
Easy
Thùy Trinh
Used 9+ times
FREE Resource
Enhance your content in a minute
40 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which operator combines the result sets of two or more SELECT statements and returns all rows, including duplicates?
UNION
UNION ALL
INTERSECT
EXCEPT
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The most widely used data model today, which organizes data in tables with rows and columns, is the:
Hierarchical Model
Network Model
Relational Model
Object-Oriented Model
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The `BETWEEN` operator is used in a `WHERE` clause to:
Select values that are exactly one of two specified values
Indicate values that fall within a specified range (inclusive)
Select values that are outside a specified range
Compare two string values for partial matches
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In the three-schema architecture, which level describes how a record is stored?
External Level
Conceptual Level
Physical Level
View Level
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The `IF UPDATE (column_name)` clause within a trigger allows you to:
Update a specific column when the trigger fires.
Check if a specific column was affected by an UPDATE statement that fired the trigger.
Prevent updates to a specific column.
Define a trigger that only fires when a specific column is updated.
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which type of JOIN selects records that have matching values in both tables?
INNER JOIN
LEFT OUTER JOIN
RIGHT OUTER JOIN
FULL OUTER JOIN
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The `EXISTS` operator is used with a subquery to:
Compare a value to a set of values returned by the subquery
Test for the existence of any record in the subquery's result
Return all records from the subquery
Check if a subquery returns a NULL value
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
45 questions
English Clinic - Level 4 - Test
Quiz
•
4th Grade - University
40 questions
Revision
Quiz
•
University
40 questions
春休み課題範囲をチェック!
Quiz
•
11th Grade - University
40 questions
W0 - Welcome back to school
Quiz
•
10th Grade - University
40 questions
SỬA BÀI CLASSROOM TUẦN 14
Quiz
•
6th Grade - University
45 questions
Cohesion
Quiz
•
University
36 questions
SOL 1 - REVIEW UNIT 4
Quiz
•
University
40 questions
Bollywood
Quiz
•
University
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Figurative Language Review
Quiz
•
6th Grade
