-- DML (3 commands- Insert, Update, Delete). -- DQL/ DRL (1 command- select). -- TCL (3 commands- commit, rollback, savepoint) -- DCL (2 commands- Grant, Revoke ...
alter table aluno modify cpf varchar(14) not null after nome; alter table aluno modify nome varchar(40) not null; alter table aluno modify curso char(3) default 'SEG'; alter table aluno modify n1 ...
The indexes on a the tables of a large database make a huge difference in its performance and utility. Without an index, locating a single record in a large table can take several seconds; with the ...