cnblogs_5359

摘要： Which three are true about Optimizer Statistics? A)They can be gathered manually B)They are automatically updated by DML statements C)They contain the 阅读全文

摘要： Which two are true about PL/SQL objects? A)They must be in an invalid state to be recompiled. B)They can never be manually recompiled. C)They can be m 阅读全文

摘要： Which is true about invalid PL/SQL objects? A)They are automatically recompiled against the new definition of a referenced object when they are called 阅读全文

摘要： Examine these attributes for the profile assigned to USER1 whose password is oracle_4U • PASSWORD_REUSE_MAX is 5 • PASSWORD_REUSE_TIME is 10 • PASSWOR 阅读全文

摘要： Examine these attributes for the profile assigned to USER1 whose password is oracle_4U. • PASSWORD_REUSE_MAX is 5. • PASSWORD_REUSE_TIME is 10. • PASS 阅读全文

摘要： Which four statements are true about truncating a table? A)Any insert triggers for the table will be executed. B)Any of the table’s indexes are also t 阅读全文

摘要： Each row in the TRANS_SUMMARY table contains details of one product. Each row in the TRANS_MONTHLY table contains transaction details either for new p 阅读全文

摘要： Examine these commands and their output: SQL> SELECT * FROM emp; ENO ENAME 100 Adam 101 Alan SQL> INSERT INTO emp VALUES(102,'Ben'); 1 row created. SQ 阅读全文

摘要： USER1.EMP has a referential integrity constraint defined on EMP.DNO that references USER1.DEPT.DNO. USER1 executes these commands: SQL> UPDATE dept SE 阅读全文

摘要： 60题、choose one When does a database checkpoint occur? A) When there is an online redo log switch. B) When the SHUTDOWN ABORT command is issued. C) Whe 阅读全文