data

Question

Which symbol do you use if you need to choose all the columns from the table to the result query?

Answer 1

SELECT … FROM … GROUP BY … ORDER BY … WHERE

Answer 2

SELECT … WHERE … ORDER BY … GROUP BY

Answer 3

SELECT … FROM … WHERE … GROUP BY … ORDER BY

Answer 4

SELECT … FROM … WHERE … ORDER BY … GROUP BY

Answer 5

DESCRIBE LOCATIONS

Answer 6

SELECT * FROM LOCATIONS

Answer 7

SHOW STRUCTURE LOCATIONS

Answer 8

PRINT LOCATIONS

Answer 9

each row of one table must be join with each row of another table

Answer 10

each row of one table must be join with each row of another table even if the tables do not have any columns in common

Answer 11

the rows from both tables must be displayed even if they do not satisfy the JOIN condition

Answer 12

a Cartesian product of the two tables must be displayed

Answer 13

Single-column subqueries

Answer 14

Multiple-column subqueries

Answer 15

Multiple-row subqueries

Answer 16

Single-row subqueries

Answer 17

Multiple-row subqueries

Answer 18

Single-row subqueries

Answer 19

Multiple-column subqueries

Answer 20

Single-column subqueries

Answer 21

I, II, and III

Answer 22

inner query

Answer 23

outer query

Answer 24

main query

Answer 25

I, II and III

Answer 26

single-row operators (>, =, >=, <, <>, <=) and multiple-column operators (IN, ANY, ALL)

Answer 27

single-column operators (>, =, >=, <, <>, <=) and multiple-column operators (IN, ANY, ALL)

Answer 28

multiple-row operators (>, =, >=, <, <>, <=) and single-row operators (IN, ANY, ALL)

Answer 29

single-row operators (>, =, >=, <, <>, <=) and multiple-row operators (IN, ANY, ALL)

Answer 30

last, outer

Answer 31

first, inner

Answer 32

last, inner

Answer 33

first, outer

Answer 34

curly braces

Answer 35

double quotes

Answer 36

single quotes

Answer 37

parentheses

Answer 38

outer queries

Answer 39

compound queries

Answer 40

subqueries

Answer 41

inner queries

Answer 42

REMOVE TABLE

Answer 43

ALTER TABLE

Answer 44

DROP TABLE

Answer 45

DELETE TABLE

Answer 46

SELECT last_name AS 'Employee', hire_date AS 'Hire Date' FROM employees;

Answer 47

SELECT last_name "Employee", hire_date "Hire Date" FROM employees;

Answer 48

SELECT last_name Employee, hire_date Hire Date FROM employees;

Answer 49

SELECT last_name AS Employee, hire_date AS Hire Date FROM employees;

Answer 50

SELECT last_name || ' has been working since ' || hire_date Employee Information FROM employees;

Answer 51

SELECT last_name || ' has been working since ' || hire_date 'Employee Information' FROM employees;

Answer 52

SELECT last_name || " has been working since " || hire_date "Employee Information" FROM employees;

Answer 53

SELECT last_name || ' has been working since ' || hire_date "Employee Information" FROM employees;

Answer 54

he number of employees within each department will be displayed

Answer 55

An error will occur since the GROUP BY clause is missing

Answer 56

The unique department ids will be displayed

Answer 57

The number of departments will be displayed

Answer 58

SELECT department_id Dep, COUNT(last_name) Num FROM employees GROUP BY department_id HAVING Num > 5

Answer 59

SELECT department_id Dep, COUNT(last_name) FROM employees GROUP BY Dep

Answer 60

SELECT last_name Name FROM employees WHERE Name like 'K%'

Answer 61

SELECT last_name Name FROM employees ORDER BY Name

Answer 62

WHERE salary > 5000 AND salary > 18000

Answer 63

WHERE salary > 5000 AND salary < 18000

Answer 64

WHERE salary < 5000 AND salary > 18000

Answer 65

WHERE salary > 5000 OR salary < 18000

Answer 66

WHERE salary > 5000 AND job_id = 'IT_PROG'

Answer 67

WHERE salary > 5000 OR job_id = 'IT_PROG'

Answer 68

WHERE salary > 5000 AND job_id = "IT_PROG"

Answer 69

WHERE salary > 5000 AND job_id = IT_PROG

Answer 70

WHERE department_id BETWEEN 60 AND 90

Answer 71

WHERE department_id BETWEEN 90 AND 60

Answer 72

WHERE department_id = 90 OR department_id = 60

Answer 73

WHERE department_id = 90 AND department_id = 60

Answer 74

WHERE department_id = 90 OR department_id = 60

Answer 75

WHERE department_id NOT IN (90, 60)

Answer 76

WHERE department_id = 90 AND department_id = 60

Answer 77

WHERE department_id IN (90, 60)

Answer 78

WHERE last_name LIKE 'K%' and first_name LIKE 'K%'

Answer 79

WHERE last_name LIKE 'K_' and first_name LIKE 'K_'

Answer 80

WHERE last_name = 'K%' and first_name = 'K%'

Answer 81

WHERE last_name and first_name = 'K%'

	Erstellt von Алмат Мейржан vor fast 7 Jahre

Nächster

data

Beschreibung

Zusammenfassung der Ressource

Frage 1

Frage 2

Frage 3

Frage 4

Frage 5

Frage 6

Frage 7

Frage 8

Frage 9

Frage 10

Frage 11

Frage 12

Frage 13

Frage 14

Frage 15

Frage 16

Frage 17

Frage 18

Frage 19

Frage 20

Frage 21

Frage 22

Frage 23

Frage 24

Frage 25

Frage 26

Frage 27

Frage 28

Frage 29

Frage 30

Frage 31

Frage 32

Frage 33

Frage 34

Frage 35

Frage 36

Frage 37

Frage 38

Frage 39

Frage 40

Frage 41

Frage 42

Frage 43

Frage 44

Frage 45

Frage 46

Frage 47

Frage 48

Frage 49

Frage 50

ähnlicher Inhalt