07 2019 档案
摘要：Which three are true about the Automatic Workload Repository (AWR)? A)AWR data is stored in the SYSTEM tablespace. B)By default, AWR snapshots are tak
阅读全文
posted @ 2019-07-31 11:10
cnblogs_5359
摘要：Which three are true about the Automatic Workload Repository (AWR)? A)AWR data is stored in the SYSTEM tablespace. B)By default, AWR snapshots are tak
阅读全文
posted @ 2019-07-31 09:45
cnblogs_5359
摘要：Which three are true about the Automatic Workload Repository (AWR)? A)AWR data is stored in the SYSAUX tablespace. B)Automatic AWR snapshots are creat
阅读全文
posted @ 2019-07-30 11:21
cnblogs_5359
摘要：Which two are true about Optimizer Statistics? A)They are gathered by the Manageability Monitor(MMON) background process. B)They can be gathered by ex
阅读全文
posted @ 2019-07-30 09:19
cnblogs_5359
摘要：Which two are true about Oracle's Optimizer statistics? A)They are automatically updated when ddl statements execute. B)They can be calculated exactly
阅读全文
posted @ 2019-07-29 11:15
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
阅读全文
posted @ 2019-07-29 10:37
cnblogs_5359
摘要：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
阅读全文
posted @ 2019-07-26 11:06
cnblogs_5359
摘要：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
阅读全文
posted @ 2019-07-26 10:15
cnblogs_5359
摘要：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
阅读全文
posted @ 2019-07-25 14:01
cnblogs_5359
摘要：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
阅读全文
posted @ 2019-07-25 13:14
cnblogs_5359
摘要：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
阅读全文
posted @ 2019-07-25 10:39
cnblogs_5359
摘要：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
阅读全文
posted @ 2019-07-24 15:06
cnblogs_5359
摘要：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
阅读全文
posted @ 2019-07-24 14:14
cnblogs_5359
摘要：USER1.EMP has a referential integrity constraint defined on EMP.DNO that references USER1.DEPT.DNO. USER1 executes these commands: SQL> UPDATE dept SE
阅读全文
posted @ 2019-07-24 13:27
cnblogs_5359
摘要：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
阅读全文
posted @ 2019-07-18 13:11
cnblogs_5359
摘要：59题、choose three Which three statements are true about naming methods? A) In the Easy Connect method, clients can connect to a database server by usin
阅读全文
posted @ 2019-07-18 10:55
cnblogs_5359
摘要：58题、choose two Which two statements are true about Oracle network connections? A) A listener may listen on behalf of only one database instance at a t
阅读全文
posted @ 2019-07-17 10:02
cnblogs_5359
摘要：57题、choose one Which statement is true about a database in ARCHIVELOG mode? A) Full database backups can be performed when the database is opened. B)
阅读全文
posted @ 2019-07-17 09:28
cnblogs_5359
摘要：56题、choose two In your database, USERS is the default permanent tablespace. Examine the commands and their outcome: SQL> CREATE USER user02 identified
阅读全文
posted @ 2019-07-04 09:56
cnblogs_5359
摘要：55题、choose two Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for
阅读全文
posted @ 2019-07-04 09:23
cnblogs_5359
