Crowdly

Додати до Chrome

Університети
softserve.academy
Database & SQL Basics Lite Edition [Ukr+Eng sub, 2016]

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

Шукаєте відповіді та рішення тестів для Database & SQL Basics Lite Edition [Ukr+Eng sub, 2016]? Перегляньте нашу велику колекцію перевірених відповідей для Database & SQL Basics Lite Edition [Ukr+Eng sub, 2016] в softserve.academy.

Отримайте миттєвий доступ до точних відповідей та детальних пояснень для питань вашого курсу. Наша платформа, створена спільнотою, допомагає студентам досягати успіху!

What is the query for creating the PRODUCT table which contains the following fields: ID (primary key), NAME (product name) and PRICE (the product’s unit price)

CREATE TABLE PRODUCT (ID INT PRIMARY KEY, NAME VARCHAR(50), PRICE NUMERIC(6,2))

CREATE TABLE PRODUCT (ID INT, NAME VARCHAR(50), PRICE INT)

CREATE TABLE PRODUCT (ID INT PRIMARY KEY, NAME VARCHAR(50), PRICE)

CREATE TABLE PRODUCT (ID INT NOT NULL, NAME TEXT, PRICE NUMERIC(6,2))

CREATE TABLE PRODUCT (ID PRIMARY KEY, NAME VARCHAR(50), PRICE NUMERIC(6,2))

Переглянути це питання

Choose statements that relate to desktop (file-server) RDMS

Data is processed on a local PC

Data is stored on a local PC or on a file server

Data is stored on a server

Data is processed on a server

Rapid development

Переглянути це питання

Which adjectives refer to data models

Переглянути це питання

Choose statements that relate to client-server RDMS

Data is processed on a local PC

Data is stored on a local PC or on a file server

Data is stored on a server

Data is processed on a server

Rapid development

Переглянути це питання

What is database?

any set of information stored in a computer memory

a mathematical notion referring to relation theory

collection of information that is organized so that it can easily be accessed, managed, and updated

a graphical representation of tables

organized collection of data

Переглянути це питання

PRIMARY KEY is one or several fields of a table that contain a reference to the foreign key field in another table.

Переглянути це питання

Consider the following table named STUDENT

ID	NAME	ID_INSTITUTE	RATING
1	Левицький А.
2	Стернюк У.	I1	3.8
3	Войтенко М.	I2	3.5
4	Бабич О.	I2	4.1

and the next table INSTITUTE

ID	NAME
I1	Computer science
I2	Mathematics
I3	Physics

which have a relationship by the field ID_INSTITUTE

What is the query that would produce the following result set:

NAME OF STUDENT	NAME OF INSTITUTE
Стернюк У.	Computer science
Войтенко М.	Mathematics
Бабич О.	Mathematics

SELECT STUDENT.NAME [NAME OF STUDENT], INSTITUTE.NAME [NAME OF INSTITUTE]

FROM STUDENT LEFT JOIN INSTITUTE

ON STUDENT.ID_INSTITUTE=INSTITUTE.ID

SELECT STUDENT.NAME [NAME OF STUDENT], INSTITUTE.NAME [NAME OF INSTITUTE]

FROM INSTITUTE RIGHT JOIN STUDENT

ON INSTITUTE.ID = STUDENT.ID_INSTITUTE

SELECT STUDENT.NAME [NAME OF STUDENT], INSTITUTE.NAME [NAME OF INSTITUTE]

FROM STUDENT FULL JOIN INSTITUTE

ON STUDENT.ID_INSTITUTE=INSTITUTE.ID

SELECT STUDENT.NAME [NAME OF STUDENT], INSTITUTE.NAME [NAME OF INSTITUTE]

FROM STUDENT, INSTITUTE

WHERE STUDENT.ID_INSTITUTE=INSTITUTE.ID

SELECT STUDENT.NAME [NAME OF STUDENT], INSTITUTE.NAME [NAME OF INSTITUTE]

FROM STUDENT JOIN INSTITUTE

ON STUDENT.ID_INSTITUTE=INSTITUTE.ID

Переглянути це питання

Consider the following table named STUDENT

ID	NAME	ID_INSTITUTE	RATING
1	Левицький А.
2	Стернюк У.	I1	3.8
3	Войтенко М.	I2	3.5
4	Бабич О.	I2	4.1

and the next table INSTITUTE

ID	NAME
I1	Computer science
I2	Mathematics
I3	Physics

which have a relationship by the field ID_INSTITUTE

How many records would the following query produce

SELECT STUDENT.ID, STUDENT.NAME, INSTITUTE.NAME

FROM STUDENT FULL JOIN INSTITUTE

ON STUDENT.ID_INSTITUTE=INSTITUTE.ID

4

3

7

2

5

Переглянути це питання

If a table in a database has a foreign key then

Key field of this table could be a field of relationship

It must contain at least one record

It must have a complex key

It is related with another table of the DB

It is not related with another table of the DB

Переглянути це питання

Consider the EMPLOYEE table containing the employee’s ID, his name, salary and the ID number of his manager.

Check the queries which produce the information about employees who earn more than their managers:

SELECT SALARY

FROM EMPLOYEE E FULL JOIN EMPLOYEE M

ON E.ID = M.MANAGER_ID

WHERE E.SALARY > M.SALARY

SELECT *

FROM EMPLOYEE E JOIN EMPLOYEE M

ON E.ID = M.MANAGER_ID

WHERE E.SALARY > M.SALARY

SELECT *

FROM EMPLOYEE E, EMPLOYEE M

WHERE E.ID = M.MANAGER_ID AND E.SALARY > M.SALARY

SELECT *

FROM EMPLOYEE

HAVING SALARY = MAX(SALARY)

SELECT *

FROM EMPLOYEE

WHERE SALARY = MAX(SALARY)

Переглянути це питання

Попередня
1
2
3
4
5
6
7
Наступна

Хочете миттєвий доступ до всіх перевірених відповідей на softserve.academy?

Отримайте необмежений доступ до відповідей на екзаменаційні питання - встановіть розширення Crowdly зараз!

Додати до Chrome

Telegram Instagram TikTok Question Bank

Умови використання Зв'яжіться з нами

Додати до Chrome

Додати до Chrome