Search Header Logo

Week 5-6 Quiz on RDBS

Authored by Darwin Vargas

Computers

12th Grade

Week 5-6 Quiz on RDBS
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the relational model primarily based on?

Graph theory

Set theory and predicate logic

Hierarchical structure

Network topology

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is NOT a type of key in the relational model?

Primary key

Superkey

Unique key

Cryptographic key

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the main purpose of a foreign key?

To uniquely identify rows in a table

To enforce referential integrity between tables

To act as a backup for the primary key

To improve query performance

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A table is in 1NF if:

It has no repeating groups or arrays.

All non-key attributes depend on the primary key.

It has a primary key defined.

It is free of transitive dependencies.

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following violates the rules of 1NF?

Having multiple attributes as part of a primary key

Storing multiple values in a single attribute

Using foreign keys to link tables

Using derived attributes

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A relation is in 2NF if:

It is in 1NF and every non-prime attribute is fully functionally dependent on the primary key.

It has no partial dependencies.

It has no transitive dependencies.

It is in 3NF.

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A candidate key is:

A subset of attributes that can uniquely identify a row but is not the primary key.

A foreign key used in relationships.

A derived attribute.

A redundant attribute.

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?