SQL_2
Quiz
•
Computers
•
University
•
Practice Problem
•
Hard
Marvi Shaikh
Used 3+ times
FREE Resource
Enhance your content in a minute
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
What is in the centre of Canada’s flag?
Leaf
Bear
Maple Leaf
Red
2.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
How many bones does an adult human have?
105
207
200
206
3.
MULTIPLE CHOICE QUESTION
45 sec • 2 pts
What is partial dependency?
When a non-key attribute determined by another non-key attribute
When an attribute is determined by part of the primary key
When a determinant is matched with a set of values
When the value of an attribute can determine the value of another
4.
MULTIPLE CHOICE QUESTION
45 sec • 2 pts
Which of the following is NOT a characteristic of a relation?
Each column has a unique name
Rows contain data about an entity
Columns contain data about attributes of the entities
The order of the columns is important
5.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which of the following clause allows us to extract data in a range?
RANGE
BETWEEN
FIND IN
LIKE
6.
MULTIPLE CHOICE QUESTION
1 min • 2 pts
Which of the following statements about the MAX function in SQL are true?
It can be used with numeric, date-time and char data types.
Returns the max value of the attribute.
It is an aggregate function.
All of the above statements are true.
7.
MULTIPLE CHOICE QUESTION
45 sec • 2 pts
What is the purpose of the Boyce-Codd Normal Form (BCNF) in database design?
To eliminate transitive dependencies
To eliminate duplicate records
To enforce referential integrity
To ensure all columns are atomic
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
20 questions
IT Essential UIUX Chapter 1 & 2
Quiz
•
University
20 questions
STM 2013 : FORMATIF T3-FORM & REPORT
Quiz
•
University
20 questions
Chapter 3: Strategic Initiatives for implementing CA
Quiz
•
University
20 questions
DWDM-2
Quiz
•
University
20 questions
HCI - UCD
Quiz
•
University
20 questions
Chapter 1: Introduction to Computer
Quiz
•
University
16 questions
Python Basics
Quiz
•
KG - University
20 questions
Python Recap
Quiz
•
7th Grade - 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
