Crowdly

Add to Chrome

Universities
softserve.academy
Check your knowledge: DEVELOPERS Tests

Check your knowledge: DEVELOPERS Tests

Looking for Check your knowledge: DEVELOPERS Tests test answers and solutions? Browse our comprehensive collection of verified answers for Check your knowledge: DEVELOPERS Tests at softserve.academy.

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

What gets printed?

An exception is thrown

100%

View this question

There

are 2 tables: Offices and Cities. They are linked by City_id. At the moment

these tables have the following data

Which

of the next queries will return 3 rows?

SELECT Offices.Name, Cities.Name FROM Offices LEFT OUTER JOIN Cities ON Offices.City_id=Cities.City_id;

100%

SELECT Offices.Name, Cities.Name FROM Offices INNER JOIN Cities ON Offices.City_id=Cities.City_id;

SELECT Offices.Name, Cities.Name FROM Offices RIGHT OUTER JOIN Cities ON Offices.City_id=Cities.City_id;

SELECT Offices.Name, Cities.Name FROM Offices CROSS JOIN Cities

SELECT Offices.Name, Cities.Name FROM Offices FULL OUTER JOIN Cities ON Offices.City_id=Cities.City_id;

View this question

Relations Primary Key - A foreign key is used to ...

cross-tabular communication

100%

indexing the database

database cleanup

View this question

Which SQL statement selects all rows from the Products table and sorts the result by the ProductID column?

SELECT * FROM Products ORDER BY ProductID

100%

SELECT * FROM Products ORDERED BY ProductID

SELECT * FROM Products SORT BY ProductID

SELECT ProductID FROM Products

View this question

A table is in 3NF if the table is in 2NF and what

other condition is met?

There are no functional dependencies

There are

no repeating groups

There

are no non-key attributes that are dependent on another non-key attribute

100%

There are no non-key attributes that are fully

functionally dependent on part of

primary key only

View this question

What

is Primary Key? Choose the most accurate definition.

The

first column in the table;

One

column that uniquely identifies each record in the table and can be

autoincrement;

It’s

the same as Foreign Key.

One or more columns that uniquely identifiy each record in the table;

100%

A column that can contain only unique values;

View this question

The phrase INNER JOIN allows ...

Return all rows from two tables

Return only rows from the first table that do not have the corresponding values from the second table by fields in which 2 tables merge

Return all rows that have corresponding values in the fields on which 2 tables merge

100%

View this question

Which variant describes an AS statement with SQL?

The AS expression is only used with the JOIN expression

The AS expression defines the filter expression

The AS expression of SQL is used to change the column name in the result set

100%

The AS expression defines the sort expression

View this question

q25

Select

the code which uses a JOIN correctly.

SELECT teacher.name, dept.name FROM teacher OUTER JOIN dept ON dept.id

SELECT teacher.name, dept.name FROM teacher JOIN dept ON (dept = id)

SELECT teacher.name, dept.name FROM teacher

LEFT OUTER JOIN dept ON (teacher.dept = dept.id)

100%

SELECT teacher.name, dept.name FROM teacher, dept JOIN WHERE(teacher.dept = dept.id)

SELECT teacher.name, dept.name FROM teacher, dept INNER JOIN ON (teacher.dept = dept.id)

View this question

When

a query doesn’t have an ORDER BY clause, what is the order in which the rows

are returned?

Primary key order

Arbitrary order

100%

Clustered index order

Insertion order

View this question

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

Add to Chrome