[DBA] 16 SQL commands

. The DML , DDL, DCL, TCL ...

--- The Data Manipulation Language (DML) commands: 

■ SELECT 

■ INSERT 

■ UPDATE 

■ DELETE 

■ MERGE 

 --- The Data Definition Language (DDL) commands: 

■ CREATE 

■ ALTER 

■ DROP 

■ RENAME 

■ TRUNCATE 

■ COMMENT 

 --- The Data Control Language (DCL) commands: 

■ GRANT 

■ REVOKE 

 --- The Transaction Control Language (TCL) commands: 

■ COMMIT 

■ ROLLBACK 

■ SAVEPOINT .

[DBA] Oracle Enterprise Manager

. Oracle Enterprise Manager (Oracle 11gR2) 為了用Web管理Database, 

所以有了Database Control; 

 為了管好Instances,所以有了Application Server Control; 

 為了管理上面兩個再加一點料,所以有了Grid Control; 

 摻在一起,做成撒尿牛丸之後,就是Oracle Enterprise Manager (EM) 了. 

 So, Oracle Enterprise Manager comes in three forms: 

■ Database Control 

■ Application Server Control 

■ Grid Control