Search Header Logo

SQL IC

Authored by Marcin Zielinski

Professional Development

1st - 3rd Grade

Used 6+ times

SQL IC
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Polecenie SQL wykorzystywane do modyfikowania rekordów

MODIFY

UPDATE

CHANGE

SELECT

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

SELECT order_no, order_line, avg(qty) FROM customer_Order_Line. Po czym grupować, by nie wyrzuciło błędu?

order_line

order_no, order_line

order_no

qty

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Ograniczenie rekordów zamówienie klienta których średnia cena linii jest większa od 10 - za pomocą czego dodamy ograniczenia?

WHERE

GROUP BY

HAVING

ORDER BY

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Prawidłowa kolejność zapytania SQL

SELECT

FROM

GROUP BY

WHERE

HAVING

ORDER BY

SELECT

HAVING

GROUP BY

WHERE

FROM

ORDER BY

SELECT

FROM

HAVING

GROUP BY

WHERE

ORDER BY

SELECT

FROM

WHERE

GROUP BY

HAVING

ORDER BY

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Co służy do grupowania w grupach?

ROLLUP

CUBE

GROUP BY

ORDER

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

FUNKCJA AGREGUJĄCA SUMA POJEDYNCZYCH WARTOŚCI REKORDÓW

SUM(qty)

DISTINCT SUM(qty)

SUM DISTINCT qty

SUM(DISTINCT qty)

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Złączenie bazujące na nazwach kolumn obu tabel

JOIN ON

JOIN USING

NATURAL JOIN

INNER JOIN

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?