17. SQL

Question 1

EXTENSIÓN PROCEDURAL DE SQL (3)

Answer 1

SQL/PSM
PL/SQL (Oracle)
Transact-SQL (Microsoft)

Question 2

SISTEMAS GESTORES DE BASES DE DATOS (8+1)

Answer 2

Oracle
SQL Server
MySQL
MariaDB
Informix
IBM DBZ
PostgreSQL
MaxDB
*SQlite

Question 3

PRINCIPIOS ACID DE SQL (4)

Answer 3

Atomicidad
Consistencia
Aislamiento
Durabilidad

Question 4

SENTENCIAS SQL QUE PUEDEN DISPARAR UN TRIGGER (3)

Answer 4

INSERT
UPDATE
DELETE

Question 5

COMANDOS SQL DDL (3)

Answer 5

CREATE
ALTER
DROP

Question 6

COMANDOS SQL DML (6+1)

Answer 6

SELECT
INSERT
UPDATE
DELETE
TRUNCATE*
MERGE
UNION

Question 7

CONSTRAINTS DE SQL (6)

Answer 7

NOT NULL
UNIQUE
PRIMARY KEY
FOREIGN KEY
CHECK
DEFAULT

Question 8

COMANDOS SQL DCL (2)

Answer 8

GRANT
REVOKE

Question 9

COMANDOS SQL TCL (4)

Answer 9

COMMIT
ROLLBACK
SAVEPOINT
RELEASE SAVEPOINT

Question 10

NIVELES DE AISLAMIENTO EN TRANSACCIONES SQL (4)

Answer 10

Read uncommited
Read commited
Repetible read
Serializable

Question 11

EFECTOS EN LECTURA (3)

Answer 11

Sucia
No repetible
Fantasma

Question 12

TIPOS DE JOIN SQL (6)

Answer 12

CROSS JOIN
INNER JOIN
LEFT OUTER JOIN
RIGHT OUTER JOIN
FULL OUTER JOIN
NATURAL JOIN