Kartkówka INSERT, UPDATE, DELETE, CREATE, ALTER, DROP

Kartkówka INSERT, UPDATE, DELETE, CREATE, ALTER, DROP

9th Grade

10 Qs

quiz-placeholder

Similar activities

Linux-2 Quiz 2 -- LAMP

Linux-2 Quiz 2 -- LAMP

1st - 12th Grade

15 Qs

Microsoft  Office Word

Microsoft Office Word

4th Grade - University

12 Qs

OCR Computer Science 2.3 Testing

OCR Computer Science 2.3 Testing

8th - 11th Grade

7 Qs

Python Basics Quiz

Python Basics Quiz

6th - 10th Grade

15 Qs

LA1.C1: Introduction to Small Basic

LA1.C1: Introduction to Small Basic

9th Grade

15 Qs

Microsoft Office 2013 - Midterm Review

Microsoft Office 2013 - Midterm Review

9th - 12th Grade

15 Qs

Encryption quiz

Encryption quiz

9th Grade

10 Qs

KIỂM TRA ĐỊNH KÌ CUỐI NĂM HỌC 2024-2025 MÔN TIN HỌC LỚP 3

KIỂM TRA ĐỊNH KÌ CUỐI NĂM HỌC 2024-2025 MÔN TIN HỌC LỚP 3

3rd Grade - University

13 Qs

Kartkówka INSERT, UPDATE, DELETE, CREATE, ALTER, DROP

Kartkówka INSERT, UPDATE, DELETE, CREATE, ALTER, DROP

Assessment

Quiz

Computers

9th Grade

Practice Problem

Medium

Created by

Dominik Augustyniak

Used 11+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

W języku SQL aby stworzyć tabelę, należy zastosować polecenie

ADD TABLE

ALTER TABLE

CREATE TABLE

INSERT TABLE

2.

FILL IN THE BLANK QUESTION

1 min • 1 pt

W języku SQL aby stworzyć bazę danych, należy zastosować polecenie

3.

FILL IN THE BLANK QUESTION

1 min • 1 pt

W języku SQL aby zmodyfikować strukturę danych użyjesz polecenia:

4.

FILL IN THE BLANK QUESTION

1 min • 1 pt

W języku SQL aby usunąć jakąś strukturę (tabelę, bazę) użyjesz polecenia:

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Które z poleceń umożliwia dodanie kolumny zadaniekompletne do tabeli zadania?

CREATE INDEX zadania ADD COLUMN zadaniekompletne int

ALTER TABLE zadania ADD COLUMN zadaniekompletne int

ALTER TABLE zadaniekompletne ADD COLUMN zadania int

ADD COLUMN zadaniekompletne WITH zadania

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Które polecenie usunie z tabeli product wszystkie produkty których cena (price) jest wyższa niż 20?

DELETE FROM product WHERE price>20;

DELETE FROM product WHERE price>=20;

DROP FROM product WHERE price>20;

DELETE product FROM price>20;

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Do zaktualizowania ilości populacji dla dokładnie jednego rekordu użyjesz kwerendy:

UPDATE cities SET population = 771069 WHERE id = 2;

UPDATE cities SET population = 771069 WHERE population=157321;

CHANGE cities SET population = 771069 WHERE id = 2;

MODIFY cities SET population = 771069 WHERE population=157321;

Create a free account and access millions of resources

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

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?