h1

Cap.14 Tranzactii nivele de izolare si procesare concurenta

March 24, 2010

1) INSERT INTO cu SELECT

DBA – admin-ul bd (cand sunt putini useri)

DBO – in momentul crearii tabelelor, view-urilor, query-urilor respectivul user devine database owner (dbo)

2) GRANT DELETE

3) GRANT USAGE si create domain – acces pt.useri la domenii create

4) REVOKE si GRANT – optiunea cascade

5) Folosire GRANT si REVOKE simultan

6) Cele 4 niveluri ale tranzactiilor:

7) Deadlock – situatii de inter-blocare, nivelul serializable

8) SET TRANSACTION: (setarea unui nivel de izolare al tranzactiei -unul din cele 4)

9) COMMIT pt.update permanent la bd:

10) Constrangeri multi-tabela:

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: