class 11 Flashcards

1
Q

Databáza

A

organizovaný subor dát, do kt. mám elektronický pristup

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

relačná databáza

A

je založená na relačnom modele, ktorý definuje spôsob uloženia dát

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Primary key

A

uloha- jednoznačne identifkovať záznamy v tabuľke

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

SQL+ def.

A

Structured Query Language

navrhnutý pre manažovanie dát v relačných databázach

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

ako sa deli SQL

A

manipulation, definition

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

metody v SQL

A

select získanie informácií
insert- odoslanie informácií
update - uložit objekt v destinácií
delete - zmazanie

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

zápis v SQL

A
  • bodkočiarka teda znak ; je na konci každého SQL dotazu

- všetky atribúty záznamu/riadku v tabuľke - *

How well did you know this?
1
Not at all
2
3
4
5
Perfectly