database integrity

Question 1

what is data integrity ?

Answer 1

it refers to the accuracy,consistency, and reliability of storing data.

Question 2

what is the differences between staic and referential integrity?

Answer 2

static refers to the correctness and consistency of individual data check like constraints- datat type,length
attribute domains
keys
relation cardinal

Question 3

referential integrity

Answer 3

ensure consistency between table
ensure relational link

Question 4

referential integrity -cascade and set null

Answer 4

set to null-> set null
propagate the chnage->cascade

Question 5

update

Answer 5

update x
set x
where m

Question 6

cascade

Answer 6

create table s( .., k integer references R on update cascade);

Question 7

delete

Answer 7

delete from table
where x=f;

Question 8

types of static intergrity

Answer 8

aufzahlungtypen und wertebereichseinschränkungen

Question 9

constraints

Answer 9

check (x)
x not null
primary ke<y(x,x)
foreign key(x) references m

Question 10

trigger reaction

Answer 10

create trigger
cascade/no cascade
before/after
update/insert/ delete x on f(table)
referencing old as oldname new as newname
for each row
when
set

Question 11

temporal data

Answer 11

Temporal data management involves storing, querying, and analyzing data over time. Some databases support temporal features, such as temporal tables or temporal databases, which allow for the storage and querying of temporal data. Temporal databases enable the tracking of changes to data over time, querying historical data at specific points in time, and handling temporal constraints and validity periods.

Question 12

transaction time versionierung

Answer 12

create table studiengebühren
(x,x,x,x always as row start ,generated always as row end,
period fro sytem_time ,
)with system versioning

Question 13

how to write recursive

Answer 13

with recursive table_name as
——————base case—————–
(select x
from tablename
where x=o)
————–union…….
select.f.x
from table name f
join table_name on e.x=e.f

Question 14

sql injection

Answer 14

sql injection is by adding sql such as 1=1 thus jeorpardizing the integrity

Question 15

how to improvae security

Answer 15

by using parameterised insteads of constructed
salting\hashing