
Quiz 3
Quiz
•
Other
•
University
•
Practice Problem
•
Easy
Maryam Ahmad
Used 4+ times
FREE Resource
Enhance your content in a minute
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
What is the primary purpose of normalization in databases?
Improve execution speed
Increase redundancy
Eliminate update anomalies
Avoid using foreign keys
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which normal form removes partial dependencies?
First Normal Form (1NF)
Second Normal Form (2NF)
Third Normal Form (3NF)
Boyce-Codd Normal Form (BCNF)
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
In functional dependency A → B, which of the following is true?
A determines nothing
A determines B
B determines A
A is always a foreign key
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which operation in relational algebra selects specific rows based on a condition?
SELECT (σ)
PROJECT (π)
JOIN (⋈)
UNION (∪)
5.
MULTIPLE CHOICE QUESTION
3 mins • 1 pt
Which of the following is a valid PROJECT operation?
σDNO=4(EMPLOYEE)
πLNAME, SALARY(EMPLOYEE)
EMPLOYEE × DEPARTMENT
EMPLOYEE − WORKS_ON
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which type of JOIN includes only matching tuples based on a condition?
Left outer join
Equijoin
Natural join
Cartesian product
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
What SQL command is used to give privileges to users?
AUTHORIZE
PERMIT
GRANT
ALLOCATE
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
15 questions
Accountic Basic NOCTI Sample Questions (Set 2)
Quiz
•
9th Grade - University
16 questions
Adopt me Questions #1
Quiz
•
KG - University
15 questions
TXT THEORY
Quiz
•
8th Grade - Professio...
10 questions
DTO30053 DRT3A Topic 2
Quiz
•
University
10 questions
BME 302 - Topic 2
Quiz
•
University
11 questions
Fortnite
Quiz
•
5th Grade - Professio...
20 questions
Service Quality
Quiz
•
1st Grade - University
10 questions
Basic concept of income tax
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
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th 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
Discover more resources for Other
7 questions
How James Brown Invented Funk
Interactive video
•
10th Grade - University
5 questions
Helping Build the Internet: Valerie Thomas | Great Minds
Interactive video
•
11th Grade - University
12 questions
IREAD Week 4 - Review
Quiz
•
3rd Grade - University
23 questions
Subject Verb Agreement
Quiz
•
9th Grade - University
7 questions
Renewable and Nonrenewable Resources
Interactive video
•
4th Grade - University
19 questions
Review2-TEACHER
Quiz
•
University
15 questions
Pre2_STUDENT
Quiz
•
University
20 questions
Ch. 7 Quadrilateral Quiz Review
Quiz
•
KG - University
