Can a primary key be used as a foreign key in another table?

Yes, to form a relationship between the tables.

No, a primary key cannot be used as a foreign key.

Yes, but only in the same table.

Yes, but it will no longer function as a primary key.

Which of the following is a part of Data Definition Language (DDL)?

CREATE TABLE Employees (ID int, Name varchar(255));

UPDATE Employees SET Salary = 50000;

DELETE FROM Employees WHERE ID = 101;

What is the primary goal of referential integrity in database systems?

To make sure tables do not try to reference data which does not exist

To ensure that all primary keys have unique values

To allow the deletion of a primary key at any time

To duplicate data across multiple tables for backup purposes

What must happen before a primary key can be deleted according to referential integrity rules?

All dependent records must be deleted

All foreign keys must be updated

The table must be locked for editing

What is a cascading delete?

Deleting a primary key and all dependent records in one action

Deleting the database file from the server

Deleting all records that do not have a foreign key

Deleting records in a random order

What is data redundancy?

The repeated occurrence of data within a database

The process of normalizing data

The encryption of data for security purposes

The intentional deletion of data to save space

How can a relational database help to reduce data redundancy?

By storing data in individual tables and linking them with relationships

By storing all data in a single table

By not using primary and foreign keys

By avoiding the normalization process

What does a data dictionary in a DBMS store?

All the information about the database, such as fields, datatypes, keys

Interactive features like buttons or menus

User-friendly features like forms

What is the purpose of normalization in databases?

To remove or reduce the repetition of the data or redundancy

To complicate the structure of the database

To duplicate rows in the database

Which of the following is a requirement for a database to be in the First Normal Form (1NF)?

No repeated group of attributes

All attributes should be multi-valued

Partial dependency is permitted

What does it mean for an attribute to be atomic in the context of 1NF?

The attribute cannot be broken into meaningful parts

The attribute can be divided into smaller parts

The attribute should be a composite attribute

The attribute should be duplicated

What is a requirement for a database to be in the Second Normal Form (2NF)?

It should be in 1NF and have no partial dependency

It should be in 1NF and allows non-key dependency

What is a requirement for a database to be in the Third Normal Form (3NF)?

It should be in 1NF and 2NF with no non-key dependency

It should be in 1NF and 2NF with partial dependency

I want to select EVERY column and entry in my "actors" table. How can I do that?

SELECT * FROM actors WHERE age > 30;

SELECT name, age FROM actors WHERE age < 30;

I want to select all columns in my "actors" table for all actors older than 30. How can I do that?

SELECT * FROM actors WHERE age > 30;

SELECT name, age FROM actors WHERE age < 30;

Database Review

Authored by Dana Paz

Other

12th Grade

Used 3+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

30 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a limitation of using a file-based approach to data storage due to data redundancy?

Data is stored in one central location

Data is repeated in more than one file

Data is structured in tables, rows, and columns

All users have access to all data if a single flat file

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is one of the benefits of relational databases over file-based approaches?

Increased data redundancy

Decreased data integrity

Reduced data redundancy

Decreased data privacy

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What aspect of security is enhanced by giving different users different access rights in a relational database?

Data redundancy

Data integrity

Data privacy

Data accessibility

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is an entity in a database system?

A unique identifier for each tuple

A field within a table

The concept that we want to model and store information about

A field in one table that links to a primary key in another table

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a primary key in a database?

A field in one table that links to a primary key in another table

A data item represented as a field within a table

A unique identifier for each tuple

The concept or object in the system that we want to model and store information about

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a foreign key in a database?

A unique identifier for each tuple

A data item represented as a field within a table

A field in one table that links to a primary key in another table

The concept or object in the system that we want to model and store information about

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the term used to describe all the data about one entity in the database?

A) Attribute

B) Tuple/Record

C) Table

D) Field

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

Apple

Others

Already have an account?

Similar Resources on Wayground

26 questions

Inst 2_Liderazgo y Emprendimiento

Quiz

•

12th Grade

27 questions

de todos

Quiz

•

5th Grade - University

26 questions

3Instalace

Quiz

•

12th Grade

27 questions

Gabriele D'Annunzio l'onomaturgo e genio del marketing

Quiz

•

12th Grade

26 questions

Evolution of Media (Review)

Quiz

•

12th Grade

32 questions

Career Management Test 2.01

Quiz

•

9th - 12th Grade

26 questions

Ortografía

Quiz

•

7th - 12th Grade

30 questions

komputer akuntansi

Quiz

•

12th Grade

Popular Resources on Wayground

5 questions

This is not a...winter edition (Drawing game)

Quiz

•

1st - 5th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

10 questions

Identify Iconic Christmas Movie Scenes

Interactive video

•

6th - 10th Grade

20 questions

Christmas Trivia

Quiz

•

6th - 8th Grade

18 questions

Kids Christmas Trivia

Quiz

•

KG - 5th Grade

11 questions

How well do you know your Christmas Characters?

Lesson

•

3rd Grade

14 questions

Christmas Trivia

Quiz

•

5th Grade

20 questions

How the Grinch Stole Christmas

Quiz

•

5th Grade

Discover more resources for Other

26 questions

Christmas Movie Trivia

Lesson

•

8th Grade - Professio...

15 questions

Christmas Song Emoji Pictionary

Quiz

•

7th - 12th Grade

20 questions

Christmas Movies

Quiz

•

1st - 12th Grade

55 questions

CHS Holiday Trivia

Quiz

•

12th Grade

20 questions

Christmas Movie Trivia

Quiz

•

9th - 12th Grade

29 questions

christmas facts

Lesson

•

5th - 12th Grade

20 questions

Christmas Trivia

Quiz

•

5th - 12th Grade

20 questions

Stages of Meiosis

Quiz

•

9th - 12th Grade

Database Review

What is a limitation of using a file-based approach to data storage due to data redundancy?

What is one of the benefits of relational databases over file-based approaches?

What aspect of security is enhanced by giving different users different access rights in a relational database?

What is an entity in a database system?

What is a primary key in a database?

What is a foreign key in a database?

What is the term used to describe all the data about one entity in the database?

What is the term used to describe the data in one row of a table in the database?

What is the term used to describe a column or field in a table in the database?

Can a primary key be used as a foreign key in another table?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Other