Which one of the following statements about normal forms is FALSE?

DBMS QUIZ_THEORY_3

Quiz
•
Computers
•
University
•
Hard
Rahul Kumar
Used 3+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
BCNF is stricter than 3NF
Lossless, dependencypreserving decomposition into 3NF is always possible
Lossless, dependencypreserving decomposition into BCNF is always possible
Any relation with two attributes is in BCNF
2.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which of the following concurrency control protocols ensure both conflict serialzability and freedom from deadlock : I. 2phase locking
II. Timestamp ordering
I only
II only
Both I and II
Neither I nor II
3.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Given the basic ER and relational models, which of the following is INCORRECT?
An attributes of an entity can have more that one value
An attribute of an entity can be composite
In a row of a relational table, an attribute can have more than one value
In a row of a relational table, an attribute can have exactly one value or a NULL value
4.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which of the following is TRUE?
Every relation in 2NF is also in BCNF
A relation R is in 3NF if every nonprime attribute of R is fully functionally dependent on every key of R
Every relation in BCNF is also in 3NF
No relation can be in both BCNF and 3NF
5.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which of the following key is required in to handle the data when the encryption is applied to the data so that the unauthorised user cannot access the data?
Primary key
Authorised key
Encryption key
Decryption key
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which command is used to remove a relation from an SQL?
Drop table
Delete
Purge
Remove
7.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
______________ is a set of one or more attributes taken collectively to uniquely identify a record.
Primary Key
Foreign key
Super key
Candidate key
Create a free account and access millions of resources
Similar Resources on Quizizz
15 questions
ER MODEL

Quiz
•
University
13 questions
Week6-ERD-2

Quiz
•
University
15 questions
E-R Modeling

Quiz
•
University
15 questions
Chapt.6 - Normalization

Quiz
•
University
12 questions
Intro to Databases

Quiz
•
12th Grade - University
10 questions
Hands-on Modul 3

Quiz
•
University
10 questions
Normalization in DBMS

Quiz
•
University
10 questions
DBMS QUIZ UNIT 3- NORMALUZATION

Quiz
•
University
Popular Resources on Quizizz
39 questions
Respect and How to Show It

Quiz
•
6th Grade
20 questions
math review

Quiz
•
4th Grade
20 questions
Math Review - Grade 6

Quiz
•
6th Grade
20 questions
Reading Comprehension

Quiz
•
5th Grade
20 questions
Types of Credit

Quiz
•
9th - 12th Grade
20 questions
Taxes

Quiz
•
9th - 12th Grade
10 questions
Human Body Systems and Functions

Interactive video
•
6th - 8th Grade
20 questions
Multiplication Facts

Quiz
•
3rd Grade
Discover more resources for Computers
20 questions
Summer

Quiz
•
KG - University
19 questions
Minecraft

Quiz
•
6th Grade - Professio...
20 questions
3rd Grade Review

Quiz
•
KG - University
15 questions
Minecraft

Quiz
•
University
52 questions
Logos Trivia

Quiz
•
KG - University
7 questions
New national park celebrates Harriet Tubman's legacy

Interactive video
•
11th Grade - University
8 questions
2 Step Word Problems

Quiz
•
KG - University
20 questions
Disney characters

Quiz
•
KG - Professional Dev...