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

43 questions

Traffic Code Exam 9 (22.17-22.29)

Quiz

•

University

40 questions

งานส่วนหน้าโรงแรม

Quiz

•

University

36 questions

RPH LONG QUIZ 2

Quiz

•

University

41 questions

Four Corners 2, Unit 4 Quiz

Quiz

•

9th Grade - Professio...

40 questions

Review For Exam 4

Quiz

•

University

44 questions

Final Test OBM101

Quiz

•

7th Grade - University

39 questions

FUNDILO FINALS

Quiz

•

University

42 questions

LearnTube Data Structure and Algorithm Quiz 11/2/23

Quiz

•

University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

10 questions

Probability Practice

Quiz

•

4th Grade

15 questions

Probability on Number LIne

Quiz

•

4th Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

6 questions

Appropriate Chromebook Usage

Lesson

•

7th Grade

10 questions

Greek Bases tele and phon

Quiz

•

6th - 8th Grade

Discover more resources for Other

12 questions

IREAD Week 4 - Review

Quiz

•

3rd Grade - University

20 questions

Endocrine System

Quiz

•

University

7 questions

Renewable and Nonrenewable Resources

Interactive video

•

4th Grade - University

30 questions

W25: PSYCH 250 - Exam 2 Practice

Quiz

•

University

5 questions

Inherited and Acquired Traits of Animals

Interactive video

•

4th Grade - University

20 questions

Implicit vs. Explicit

Quiz

•

6th Grade - University

7 questions

Comparing Fractions

Interactive video

•

1st Grade - University

38 questions

Unit 8 Review - Absolutism & Revolution

Quiz

•

10th Grade - 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