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!

Consider the STUDENT table:

Calculate the result of the following query:

SELECT AVG(RAITING) 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

Consider the table named COUNTRIES:

Determinethe count of countries for each continent 

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

Consider the STUDENT table

Calculate the result of the following query:

SELECT SUM(RAITING) FROM STUDENT

View this question
General form of a SELECT query looks like
View this question

Consider the following table named USER

How many records will the following query will produce:

        SELECT * FROM USER WHERE NAME LIKE ‘Ivan%’ 

❌
❌
❌
❌
✅
View this question

Consider the following table named USER

How many records will the following query will produce:

        SELECT * FROM USER WHERE NAME LIKE ‘%ivan%’ 

✅
❌
❌
❌
❌
View this question
Select the commands for changing the existing table’s structure
✅
❌
❌
❌
❌
View this question
Which of the following commands will enforce the EMPLOYEE table to not accept negative values in the SALARY field?
❌
❌
❌
✅
View this question
Which of the following key words is used to define an autoincremental field in a table in MS SQL server?
❌
❌
✅
❌
❌
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