Relational databases

0.0(0)
Studied by 0 people
call kaiCall Kai
Locked
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/4

encourage image

There's no tags or description

Looks like no tags are added yet.

Last updated 8:04 PM on 8/15/26
Name
Mastery
Learn
Test
Matching
Spaced
Call with Kai
Chat

No analytics yet

Send a link to your students to track their progress

5 Terms

1
New cards

Wat zijn de 3 subtalen van sql

DML - Data modification language

DDL - Data definition language

DCL - Data control language

2
New cards

Waarvoor staat ACID

Atomicity

Consistency

Isolation

Durability

3
New cards

unieke index maken

CREATE UNIQUE INDEX idx_klant_email ON Klanten (Emailadres);

4
New cards

non-clustered index aanmaken

CREATE NONCLUSTERED INDEX idx_naam_stad ON Klanten (Achternaam, Woonplaats);

5
New cards

Clustered index maken

CREATE CLUSTERED INDEX idx_factuur_id ON Facturen (Factuurnummer);