Search Header Logo

DBMS Q2

Authored by Nero 1

English

1st - 5th Grade

Used 6+ times

DBMS Q2
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a super key?

A set of attributes that can uniquely identify a row in a table

A set of attributes that can uniquely identify a row in a table with no redundant attribute

A column or group of columns used to identify a row uniquely in a table


A column or group of columns in a table that reference the primary key of another table

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following statements about candidate keys is true?

They can contain redundant attributes

They are a set of attributes that can uniquely identify a row in a table with no redundant attribute

They are a subset of the primary key

They are a subset of the foreign key

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a primary key?


A set of attributes that can uniquely identify a row in a table


A set of attributes that can uniquely identify a row in a table with no redundant attribute

A column or group of columns used to identify a row uniquely in a table

A column or group of columns in a table that reference the primary key of another table

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a foreign key?

A set of attributes that can uniquely identify a row in a table

A set of attributes that can uniquely identify a row in a table with no redundant attribute

A column or group of columns used to identify a row uniquely in a table

A column or group of columns in a table that reference the primary key of another table

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is not a type of functional dependency in DBMS?

Multivalued Dependency

Trivial Functional Dependency

Non-Trivial Functional Dependency

Binary Dependency

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What characterizes a transitive dependency in a database?


It is a direct relationship between values in the same table.


It is an indirect relationship between values in different tables.

It is an indirect relationship between values in the same table.

It does not cause a functional dependency.

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What are the three types of anomalies that occur when a database is not normalized?

Addition, Modification, Deletion

Insertion, Update, Deletion

Insert, Edit, Remove

Add, Change, Delete

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?