随笔分类 -  V$视图

1 2 下一页
052-129
摘要：A database user SMITH tries to query the V$SESSION view and fails to access it as follows:SQL> connect smith/smithConnected. SQL> SELECT * FROM v$sess 阅读全文
posted @ 2017-12-12 18:33 巴啦啦大魔王 阅读(267) 评论(0) 推荐(0)
052-128
摘要：Which statements listed below describe the data dictionary views?1. These are stored in the SYSTEM tablespace2. These are the based on the virtual tab 阅读全文
posted @ 2017-12-12 18:18 巴啦啦大魔王 阅读(201) 评论(0) 推荐(0)
052-125
摘要：You want to check the details of few errors that users have reported. You search for the alert log file and execute few commands to find the location 阅读全文
posted @ 2017-12-12 17:26 巴啦啦大魔王 阅读(103) 评论(0) 推荐(0)
052-75
摘要：Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice 阅读全文
posted @ 2017-12-08 13:22 巴啦啦大魔王 阅读(113) 评论(0) 推荐(0)
052-50
摘要：Which two statements are true about alerts? (Choose two.)A.Clearing an alert sends the alert to the alert history.B.Response actions cannot be specifi 阅读全文
posted @ 2017-12-07 13:25 巴啦啦大魔王 阅读(103) 评论(0) 推荐(0)
052-49
摘要：View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, you executed the following command:SQL> SELECT reason,met 阅读全文
posted @ 2017-12-07 11:35 巴啦啦大魔王 阅读(77) 评论(0) 推荐(0)
053-275
摘要：You have enabled resumable space allocation in your database by setting theRESUMABLE_TIMEOUT parameter set to a nonzero value.Which three statements a 阅读全文
posted @ 2017-11-16 16:31 巴啦啦大魔王 阅读(150) 评论(0) 推荐(0)
053-619
摘要：View the Exhibit and note the contents of V$DIAG_INFO.Which statement is true about the ADR? A. The text alert log file will be available in Diag Trac 阅读全文
posted @ 2017-11-15 17:06 巴啦啦大魔王 阅读(82) 评论(0) 推荐(0)
053-602
摘要：On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am.Which option must you use to check wheth 阅读全文
posted @ 2017-11-15 15:41 巴啦啦大魔王 阅读(109) 评论(0) 推荐(0)
053-462
摘要：Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY, and NLS_CHARACTERSET parameters?A. V$VALID_NLS_VALUESB. NLS_VALID_VAL 阅读全文
posted @ 2017-11-14 18:16 巴啦啦大魔王 阅读(95) 评论(0) 推荐(0)
053-441
摘要：Which Scheduler view(s) can be queried to see which jobs are currently executing? (Choose all that apply.)A. DBA_SCHEDULER_JOB_RUN_DETAILSB. DBA_SCHED 阅读全文
posted @ 2017-11-14 16:28 巴啦啦大魔王 阅读(97) 评论(0) 推荐(0)
053-428
摘要：Which of the following are prerequisite steps to transport a database? (Choose all that apply.)A. Query the V$TRANSPORTABLE_PLATFORMS view in the sour 阅读全文
posted @ 2017-11-14 15:25 巴啦啦大魔王 阅读(116) 评论(0) 推荐(0)
053-426
摘要：The following query will provide what information about transportable tablespaces for the currentdatabase? (Choose all that apply.)select d.platform_n 阅读全文
posted @ 2017-11-14 15:09 巴啦啦大魔王 阅读(91) 评论(0) 推荐(0)
053-424
摘要：Which of these components correctly identify the unique value of the NAME column in the DBA_RESUMABLE view?A. Username, instance number, session IDB. 阅读全文
posted @ 2017-11-14 15:03 巴啦啦大魔王 阅读(85) 评论(0) 推荐(0)
053-421
摘要：When tuning Automatic PGA Memory Management, which of the following views will provide the information specified?A. The V$PGA_TARGET_ADVICE view shows 阅读全文
posted @ 2017-11-14 14:50 巴啦啦大魔王 阅读(121) 评论(0) 推荐(0)
053-366
摘要：If you are going to run a TSPITR recovery, which view will help you to determine which objects will be lost during the TSPITR?A. TS_OBJECTS_TO_BE_DROP 阅读全文
posted @ 2017-11-13 14:01 巴啦啦大魔王 阅读(147) 评论(0) 推荐(0)
053-359
摘要：What view would you use to determine if a given tablespace is fully self-contained for the execution of a tablespace point-in-time recovery?A. TS_CHEC 阅读全文
posted @ 2017-11-13 10:32 巴啦啦大魔王 阅读(125) 评论(0) 推荐(0)
053-345
摘要：What view might you use to try to determine how long a particular backup will take?A. V$SESSION_EVENTB. V$SESSIONC. V$WAITSD. V$WAITSTATE. V$SESSION_L 阅读全文
posted @ 2017-11-10 17:59 巴啦啦大魔王 阅读(75) 评论(0) 推荐(0)
053-344
摘要：In what view are you likely to see the following output?SID SERIAL# EVENT SECONDS_IN_WAIT121 269 RMAN backup & recovery I/O 2129 415 SQL*Net message f 阅读全文
posted @ 2017-11-10 17:57 巴啦啦大魔王 阅读(74) 评论(0) 推荐(0)
053-329
摘要：If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status ofMEDIA_CORRUPT, what RMAN command would you run to correct the problem?A. re 阅读全文
posted @ 2017-11-10 16:12 巴啦啦大魔王 阅读(108) 评论(0) 推荐(0)

1 2 下一页