DBMS QUIZ_THEORY_3

DBMS QUIZ_THEORY_3

University

10 Qs

quiz-placeholder

Similar activities

Data Storage

Data Storage

University - Professional Development

15 Qs

IMS.

IMS.

University

10 Qs

DBMS concepts(Hard)

DBMS concepts(Hard)

University

10 Qs

Understanding Database Normalisation Concepts

Understanding Database Normalisation Concepts

11th Grade - University

10 Qs

Rdbms unit 2

Rdbms unit 2

University

10 Qs

DSDW

DSDW

University

5 Qs

DBMS QUIZ UNIT 3- NORMALUZATION

DBMS QUIZ UNIT 3- NORMALUZATION

University

10 Qs

Chapter 7: Database

Chapter 7: Database

University

10 Qs

DBMS QUIZ_THEORY_3

DBMS QUIZ_THEORY_3

Assessment

Quiz

Computers

University

Hard

Created by

Rahul Kumar

Used 3+ times

FREE Resource

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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

BCNF is stricter than 3NF

Lossless, dependency­preserving decomposition into 3NF is always possible

Lossless, dependency­preserving 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. 2­phase locking

II. Time­stamp 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 non­prime 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

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?