SQL-Data-Engineer - ITBootcamp România

Welcome to your SQL-Data-Engineer

Ime

Prezime

Telefon

Email

Which statement about VARCHAR and INT is correct?

VARCHAR stores numbers, INT stores text

Both VARCHAR and INT store text

Both VARCHAR and INT store numbers

VARCHAR stores text, INT stores whole numbers

Which condition finds scores from 80 and above?

Score > 80

Score >= 80

Score = 80

Score <= 80

Which SQL operator requires at least one condition to be true?

AND

NOT

OR

XOR

Which query returns only the Name column from Students?

Students table used in some questions: Ana (Age 20, Score 85), Marko (Age 17, Score 70), Sara (Age 22, Score 90).

SELECT Name FROM Students;

SELECT Students.Name;

GET Name Students;

SELECT * Name FROM Students;

Which operator means “not equal to” in standard SQL?

=

>

AND

Which data type is most appropriate for a product price such as 1299.95?

DECIMAL

INT

FLOAT

BOOLEAN

What does this condition mean? WHERE Age >= 18

Age is less than 18

Age is equal to 18

Age is greater than or equal to 18

Age is greater than 18

Which query correctly returns all columns from a table named Employees?

Students table used in some questions: Ana (Age 20, Score 85), Marko (Age 17, Score 70), Sara (Age 22, Score 90).

SELECT Employees;

SELECT * FROM Employees;

GET * FROM Employees;

SELECT ALL Employees;

What does this condition match? WHERE Age >= 18 AND Age <= 25

People aged exactly 18

People aged 25 and above

People aged less than 18

People aged between 18 and 25

Given the Students table (Ana age 20, Marko age 17, Sara age 22), who matches WHERE Age < 20?

Ana

Sara

Marko

Ana and Sara

Which condition matches rows where Status is either ‘New’ or ‘Open’?

Status = 'New' AND Status = 'Open'

Status NOT IN ('New', 'Open')

Status = 'New' OR Status = 'Open'

Status = 'Closed'

What is the result of 7 * 3 + 1?

24

21

22

28

What is the result of 20 / 4 in a numeric SQL expression?

4

20

80

5

Which SQL operator requires both conditions to be true?

OR

NOT

AND

IN

Which condition matches someone aged 20 with score 90?

Age = 20 OR Score > 70

Age > 20 AND Score > 70

Age = 20 AND Score > 70

Age = 20 AND Score = 70

Given the Students table (Ana score 85, Marko score 70, Sara score 90), who matches WHERE Score >= 85?

Ana

Marko

Sara

Ana and Sara

Which condition finds rows where Age is exactly 18?

Age > 18

Age = 18

Age LIKE 18

Age 18

Which data type is most appropriate for a person’s age?

VARCHAR

INT

FLOAT

DATE

Given Score = 75, which expression is True?

Score > 80

Score >= 80

Score < 80

Score = 80

Which query correctly filters students older than 18?

SELECT * FROM Students WHERE Age >= 18;

SELECT * FROM Students WHERE Age < 18;

SELECT * FROM Students WHERE Age = 18;

SELECT * FROM Students WHERE Age > 18;