Crowdly

Add to Chrome

DataBase Fundamentals new

Looking for DataBase Fundamentals new test answers and solutions? Browse our comprehensive collection of verified answers for DataBase Fundamentals new at softserve.academy.

Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!

Which of the following is a characteristic of a well-designed database?

Lack of relationships between tables.

❌

Unstructured and unorganized data.

❌

Minimal data redundancy.

✅

High levels of data duplication.

❌

View this question

Which normal form requires that every non-key attribute depends on the entire primary key?

Fourth normal form (4NF).

Third normal form (3NF).

First normal form (1NF).

Second normal form (2NF).

View this question

Match the database term to its correct definition

A database object that improves the speed of data retrieval operations on a table.

A field in one table that uniquely identifies a row of another table or the same table.

A rule that limits the values that can be placed in a column.

A unique identifier for each record in the table.

View this question

What is the purpose of normalization in database design?

To improve data integrity.

✅

To eliminate data redundancy.

✅

To create complex relationships between tables.

❌

To optimize database storage space.

❌

To speed up database queries.

❌

View this question

What is referential integrity in database design?

Protecting the database from unauthorized access.

Maintaining consistency and relationships between related tables.

Optimizing the storage space used by the database.

Ensuring that all data is stored in the correct data type.

View this question

What is true about a foreign key constraint?

A mechanism to enforce referential integrity between related tables.

A rule that defines a unique identifier for each record in a table.

Refers to the column that value must exist.

A set of conditions that must be met for data to be inserted or updated in a table.

View this question

Assuming that we have 2 tables - customers and orders:

Assuming the following query

select * from customers join orders on orders.customer_id = customers.customer_id;

It will not bring the customers that they have never put an order.

True

False

View this question

Assuming that we have 2 tables - customers and orders:

Which SELECT statement brings both the customers with and those without an order?

select * from customers left join orders on orders.customer_id = customers.customer_id where orders.order_id is not null;

select * from customers left join orders on orders.customer_id = customers.customer_id;

select * from customers join orders on orders.customer_id = customers.customer_id;

select * from customers left join orders on orders.customer_id = customers.customer_id where orders.order_id is null;

View this question

Assuming that we have 2 tables - customers and orders:

Which of the following queries is correct to count the customers who have put at least one order?

select count(distinct customers.customers_id) from customers join orders on orders.customer_id = customers.customers_id;

select count(*) from customers join orders on orders.customer_id = customers.customer_id;

View this question

Assuming that we have 2 tables - customers and orders:

Assume also that we have 2 customers and the first customer has 3 orders and the second customer has 5 orders. How many rows will the following select query bring?

select * from customers join orders on orders.customer_id = customers.customer_id;

View this question

Want instant access to all verified answers on softserve.academy?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Add to Chrome

Telegram Instagram TikTok Question Bank