OCA: Oracle Database 11g Administrator Certified Associate Study Guide- P23: There is high demand for professionals in the information technology (IT) industry, and Oracle certifications are the hottest credential in the database world. You have made the right decision to pursue certification, because being Oracle Database 11g certified will give you a distinct advantage in this highly competitive market. | ALTER SYSTEM ARCHIVE LOG GROUP statement - ANALYZE ANY privilege 1031 shared servers 649-650 tablespaces 528 ALTER SYSTEM ARCHIVE LOG GROUP statement 917-918 ALTER SYSTEM CHECKPOINT statement 848 ALTER SYSTEM KILL SESSION statement 741 ALTER SYSTEM SET statement auditing 696 resources 688 691 ALTER SYSTEM SWITCH LOGFILE statement 848 ALTER TABLE statement auditing option 697 constraints 319 triggers 733 ALTER TABLE ADD statement 310-312 ALTER TABLE ADD CONSTRAINT statement 321-324 ALTER TABLE DISABLE CONSTRAINT statement 325 ALTER TABLE DISABLE PRIMARY KEY CASCADE statement 325 ALTER TABLE DROP statement 314-315 ALTER TABLE DROP CONSTRAINT statement 325 ALTER TABLE DROP PRIMARY KEY CASCADE statement 325 ALTER TABLE DROP UNIQUE statement 325 ALTER TABLE ENABLE statement 325-326 ALTER TABLE ENABLE ROW MOVEMENT statement 905 ALTER TABLE MODIFY statement 313 320 325 ALTER TABLE MODIFY CONSTRAINT statement 572 ALTER TABLE MOVE statement 566 ALTER TABLE READ ONLY statement 317 ALTER TABLE RENAME COLUMN statement 314 ALTER TABLE RENAME TO statement 317 ALTER TABLE SET UNUSED COLUMNS clause 315 ALTER TABLESPACE statement 754 ALTER TABLESPACE ADD DATAFILE statement 538 551 ALTER TABLESPACE APPL_DATA statement 538 ALTER TABLESPACE BEGIN BACKUP statement 540 868-869 ALTER TABLESPACE END BACKUP statement 540 868 ALTER TABLESPACE READ ONLY statement 540 ALTER TABLESPACE READ WRITE statement 540 ALTER TABLESPACE USER_DATA statement 539 ALTER TRIGGER statement 733 ALTER USER DEFAULT ROLE statement 684 ALTER USER PASSWORD statement 669 ALTER USER privilege 679 ALTER USER PROFILE statement 666 ALTER USER QUOTA statement 666 ALTER VIEW statement 347-349 AMM Automatic Memory Management 822-824 ampersands positional notation for variables 50 substitute variables 45 47-49 ANALYZE ANY privilege 679 1032 ANALYZE_DB procedure - auditing ANALYZE_DB procedure 797 ANALYZE event triggers 731 AND DATAFILES clause 537 AND operators 33-34 83 ANSI syntax for joins Cartesian 209-210 inner 202 .
