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!

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;

✅

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

❌

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 not 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

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 join orders on orders.customer_id = customers.customer_id;

select * from customers left 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

In MongoDB, data is stored in collections, and each collection contains _____

Rows

Documents

Columns

Tables

MongoDB uses a format called BSON, which stands for:

Basic JSON

Byte JSON

Binary JSON

Big JSON

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