Crowdly

Add to Chrome

Universities
lms.softserve.university
Course 2000032

Course 2000032

Looking for Course 2000032 test answers and solutions? Browse our comprehensive collection of verified answers for Course 2000032 at lms.softserve.university.

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

Which query correctly finds customers who placed more than 3 orders?

SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id HAVING COUNT(*) > 3;

SELECT customer_id FROM orders WHERE customer_id > 3 GROUP BY customer_id;

SELECT customer_id FROM orders HAVING customer_id > 3;

SELECT customer_id, COUNT(*) FROM orders ORDER BY COUNT(*) > 3;

SELECT customer_id, COUNT(*) FROM orders WHERE COUNT(*) > 3 GROUP BY customer_id;

View this question

Why must non-aggregated columns in a SELECT with GROUP BY typically appear in the GROUP BY clause?

It has no relation to GROUP BY

SQL requires it to know how to group ungrouped columns unambiguously

Aggregated columns must be excluded

It's only required for COUNT

It's optional in standard SQL

View this question

What does a LEFT JOIN return?

Only matching rows from both tables

Only unmatched rows

All rows from the left table, and matched rows from the right (NULL if no match)

All rows from the right table only

Only rows from the right table

View this question

What does a many-to-many (N:M) relationship require to implement in a relational database?

A join (junction) table with foreign keys to both tables

No extra table is needed

A single foreign key column

A unique constraint only

View this question

Which clause limits the number of rows returned?

View this question

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

View this question

How would you send a POST request with a JSON body using fetch?

fetch.post(url, data)

fetch(url, data, 'POST')

fetch(url) alone handles POST automatically

fetch(url).post(data)

fetch(url, { method: 'POST', headers: {'Content-Type': 'application/json'}, body: JSON.stringify(data) })

View this question

Which method attaches an event listener to a DOM element?

element.onEvent()

element.bindEvent()

element.listen("click", handler)

element.addEventListener("click", handler)

element.attachEvent()

View this question

Why are closures useful for creating private variables in JavaScript?

Closures only work with global variables

Variables inside a closure's enclosing scope are not directly accessible from outside, only through the returned inner function(s)

Closures automatically make variables public

Closures delete variables after use

They aren't useful for that purpose

View this question

What is the difference between call() and apply() in terms of how arguments are passed?

call() only works with arrow functions

They are identical in every way

call() takes arguments individually, apply() takes them as an array

apply() takes arguments individually, call() takes them as an array

Neither accepts arguments

View this question

Previous
1
2
3
4
13
Next

Want instant access to all verified answers on lms.softserve.university?

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

Add to Chrome

Telegram Instagram TikTok Question Bank

Terms of Use Contact Us

Add to Chrome

Add to Chrome