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.

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

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

Rows

Columns

Documents

Tables

MongoDB uses a format called BSON, which stands for:

Big JSON

Byte JSON

Binary JSON

Basic JSON

The process of combining data from multiple collections in MongoDB is known as:

Joining

Aggregation

Merging

Grouping

In MongoDB, the unique identifier for each document is called:

Index

Shared Key

Primary Key

✅

Unique Key

❌

View this question

In MongoDB, a collection is similar to what concept in relational databases?

Schema

Table

Column

Row

MongoDB stores data in the form of

Tables

Rows and columns

Documents

Key-value pairs

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