
Тест_БД
Quiz
•
Computers
•
Professional Development
•
Practice Problem
•
Hard
Юрий Шалухин
Used 4+ times
FREE Resource
Enhance your content in a minute
25 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Имеются элементы запроса: 1. SELECT employees.name, departments.name; 2. ON employees.department_id=departments.id; 3. FROM employees; 4. LEFT JOIN departments. В каком порядке их нужно расположить, чтобы выполнить поиск имен всех работников со всех отделов?
1,4,2,3
1,2,4,3
1,3,4,2
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Как расшифровывается SQL?
structured query language
strict question line
strong question language
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Для создания новой таблицы в существующей базе данных используют команду:
NEW TABLE
CREATE TABLE
MAKE TABLE
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Запрос для выборки всех значений из таблицы «Persons» имеет вид:
SELECT ALL Persons
SELECT * FROM Persons
SELECT .[Persons]
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Какое выражение используется для возврата только разных значений?
SELECT DISCINCT
SELECT DIFFERENT
SELECT UNIQUE
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Для подсчета количества записей в таблице «Persons» используется команда:
COUNT ROW IN Persons
SELECT COUNT(*) FROM Persons
SELECT ROWS FROM Persons
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Наиболее распространенным является тип объединения:
INNER JOIN
FULL JOIN
LEFT JOIN
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
20 questions
Javascript Fundamental Practice
Quiz
•
Professional Development
20 questions
MS Office
Quiz
•
Professional Development
20 questions
Табличный процессор Excel
Quiz
•
Professional Development
20 questions
Викторина "Безопасность Интернета"
Quiz
•
5th Grade - Professio...
20 questions
class 8
Quiz
•
Professional Development
20 questions
Fr Paul's 66th Birthday Quizizz
Quiz
•
Professional Development
20 questions
ITF+ Ch1 - Core Hardware Components
Quiz
•
Professional Development
25 questions
Кибербезопасность
Quiz
•
Professional Development
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Figurative Language Review
Quiz
•
6th Grade
Discover more resources for Computers
10 questions
How to Email your Teacher
Quiz
•
Professional Development
6 questions
3RD GRADE DECLARATION OF INDEPENDENCE EXIT TICKET
Quiz
•
Professional Development
19 questions
Black History Month Trivia
Quiz
•
6th Grade - Professio...
22 questions
Multiplying Exponents with the Same Base
Quiz
•
9th Grade - Professio...
40 questions
Flags of the World
Quiz
•
KG - Professional Dev...
