logo

Crowdly

Browser

Add to Chrome

Database & SQL Basics Lite Edition [Ukr+Eng sub, 2016]

Looking for Database & SQL Basics Lite Edition [Ukr+Eng sub, 2016] test answers and solutions? Browse our comprehensive collection of verified answers for Database & SQL Basics Lite Edition [Ukr+Eng sub, 2016] 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 commands will make the EMPLOYEE table to set the FIRSTNAME field value as ‘unknown’ in case if one is omitted in the INSERT statement?
❌
❌
❌
✅
View this question
Which of the following commands will enforce the EMPLOYEE table to not accept duplicate values in the LASTNAME field?
❌
0%
0%
0%
View this question
Which of the following commands will enforce the EMPLOYEE table to not accept null values in the LASTNAME field?
❌
❌
❌
✅
View this question

What is wrong with this query:

SELECT   *

FROM EMPLOYEE

WHERE DEPARTMENT = (SELECT DEPARTMENT

FROM EMPLOYEE

WHERE SALARY > 1000)

❌
✅
❌
❌
❌
View this question

Which of the given statements describes the action of the following query:

SELECT *

FROM PRODUCTS

WHERE NOT EXISTS

(SELECT * FROM ORDERS

 WHERE ORDERS.ID_PRODUCT = PRODUCTS.ID)

✅
❌
❌
❌
❌
View this question

Consider the table named COUNTRIES:

Determine the average population on each continent. 

0%
0%
0%
0%
100%
View this question

Consider the STUDENT table

Calculate the result of the following query:

SELECT COUNT(*) FROM STUDENT 

View this question

Consider the table named COUNTRIES

The following query:

SELECT CONTINENT, COUNT(COUNTRY)

FROM COUNTRIES

GROUP BY CONTINENT

HAVING SUM(POPULATION) > 300

would give us the information about: 

0%
100%
0%
0%
0%
View this question
True-false question: I the WHERE section of SELECT command one can use aggregate functions
100%
0%
View this question

Consider the table named COUNTRIES:

Determine the average population on each continent. 

0%
0%
0%
100%
0%
View this question

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

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

Browser

Add to Chrome