What is the purpose of the FOREIGN KEY in a database?

To ensure data integrity between two tables

To create a backup of the database

In SQL, what is a subquery?

A query that is nested inside another query

A query that modifies the database structure

A query that creates a new table

What is the result of the following SQL statement? SELECT * FROM employees WHERE age > 30;

All employees exactly 30 years old

What is normalization in the context of a relational database?

The process of designing a database to reduce redundancy

The process of optimizing queries

The process of adding new tables

The process of deleting old data

What is the main advantage of indexing in a database?

Simplifies the database structure

What does the WHERE clause do in an SQL statement?

Specifies the conditions for data retrieval

Limits the number of rows returned

Groups rows that have the same values

In SQL, what does the JOIN operation do?

Combines rows from two or more tables

What is a composite key in a relational database?

A primary key consisting of multiple columns

A foreign key with multiple values

A unique key with a single value

What is referential integrity in a database?

Ensuring foreign keys match primary keys

What does the term "atomic" mean in the context of database attributes?

Attributes can have multiple values

What is the purpose of a view in SQL?

To provide a virtual table based on the result set of a query

What is the effect of the following SQL statement? DELETE FROM orders WHERE order_id = 1;

Deletes the order with order_id 1

Deletes orders with order_id greater than 1

Deletes orders with order_id less than 1

In an ERD, what does cardinality specify?

The number of instances of an entity related to another entity

When normalizing a database, what is the main goal of transforming it into the Third Normal Form (3NF)?

To remove transitive dependencies

Given a table students with columns student_id, name, and major, which SQL query lists all students majoring in 'Computer Science'?

SELECT student_id, name FROM students WHERE major = 'Computer Science';

SELECT * FROM students WHERE major = 'Computer Science';

SELECT name FROM students WHERE major = 'Computer Science';

SELECT student_id FROM students WHERE major = 'Computer Science';

You have a table orders with columns order_id, customer_id, and order_date. Write an SQL query to retrieve all orders placed in the last 30 days.

SELECT * FROM orders WHERE order_date >= DATE_SUB(NOW(), INTERVAL 30 DAY);

SELECT * FROM orders WHERE order_date >= NOW() - INTERVAL 30 DAY;

SELECT * FROM orders WHERE order_date > NOW() - 30;

SELECT * FROM orders WHERE order_date >= DATEADD(DAY, -30, GETDATE());

Given the tables employees (columns: employee_id, name, department_id) and departments (columns: department_id, department_name), write an SQL query to list the names of all employees along with their department names.

SELECT name, department_name FROM employees INNER JOIN departments ON employees.department_id = departments.department_id;

SELECT employees.name, departments.department_name FROM employees JOIN departments ON employees.department_id = departments.department_id;

SELECT name, department_name FROM employees, departments WHERE employees.department_id = departments.department_id;

SELECT employees.name, departments.department_name FROM employees LEFT JOIN departments ON employees.department_id = departments.department_id;

Database Management Systems Quiz Quiz

40 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following describes a one-to-one relationship in an ERD?

An entity is related to only one instance of another entity

Multiple entities are related to multiple instances of another entity

An entity is related to many instances of another entity

Many entities are related to a single instance of another entity

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the primary purpose of a supertype/subtype relationship in an ERD?

To normalize the database

To define unique keys

To handle data redundancy

To represent inheritance among entities

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL command is used to create a new table in a database?

INSERT

ALTER

CREATE TABLE

DROP TABLE

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How do you remove a table from a database in SQL?

DELETE TABLE

REMOVE TABLE

DROP TABLE

CLEAR TABLE

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL statement is used to add a new row to a table?

INSERT INTO

ADD ROW

ADD INTO

INSERT ROW

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a PRIMARY KEY in a relational database?

A unique identifier for a record

A field that can be left empty

A command to delete a record

A relationship between tables

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following commands is used to modify the structure of an existing table?

ALTER TABLE

MODIFY TABLE

CHANGE TABLE

UPDATE TABLE

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

40 questions

FAFE1032: PRESENTATION AND GROUP DISCUSSION

Quiz

•

University

40 questions

CNPM 1

Quiz

•

University

35 questions

TQM - 1

Quiz

•

University

35 questions

LearnTube Design UI/UX Quiz 9/3/23

Quiz

•

University

40 questions

Mystique

Quiz

•

University

41 questions

Ch. 5 Economics - Supply

Quiz

•

KG - University

35 questions

SEM I Unit 3 Post test

Quiz

•

9th Grade - University

35 questions

After Winter Break: Review of CATS Expectations

Quiz

•

6th Grade - University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

54 questions

Analyzing Line Graphs & Tables

Quiz

•

4th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

Discover more resources for Other

7 questions

How James Brown Invented Funk

Interactive video

•

10th Grade - University

5 questions

Helping Build the Internet: Valerie Thomas | Great Minds

Interactive video

•

11th Grade - University

12 questions

IREAD Week 4 - Review

Quiz

•

3rd Grade - University

23 questions

Subject Verb Agreement

Quiz

•

9th Grade - University

7 questions

Renewable and Nonrenewable Resources

Interactive video

•

4th Grade - University

19 questions

Review2-TEACHER

Quiz

•

University

15 questions

Pre2_STUDENT

Quiz

•

University

20 questions

Ch. 7 Quadrilateral Quiz Review

Quiz

•

KG - University

Database Management Systems Quiz

Which of the following describes a one-to-one relationship in an ERD?

What is the primary purpose of a supertype/subtype relationship in an ERD?

Which SQL command is used to create a new table in a database?

How do you remove a table from a database in SQL?

Which SQL statement is used to add a new row to a table?

What is a PRIMARY KEY in a relational database?

Which of the following commands is used to modify the structure of an existing table?

What is the purpose of the FOREIGN KEY in a database?

Which SQL clause is used to group rows that have the same values in specified columns?

What does the HAVING clause do in an SQL query?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Other