摘要:
Which is the correct description of a pinned buffer in the database buffer cache?A. The buffer is currently being accessedB. The buffer is empty and h 阅读全文
posted @ 2017-12-01 11:34
巴啦啦大魔王
阅读(130)
评论(0)
推荐(0)
摘要:
Identify the memory component from which memory may be allocated for:1: Session memory for the shared server2: Buffers for I/O slaves3: Oracle Databas 阅读全文
posted @ 2017-12-01 11:27
巴啦啦大魔王
阅读(128)
评论(0)
推荐(0)
摘要:
Examine the following statement that is used to modify the primary key constraint on the SALES table:SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISAB 阅读全文
posted @ 2017-12-01 11:23
巴啦啦大魔王
阅读(115)
评论(0)
推荐(0)
摘要:
View the Exhibit and examine the privileges granted to the SL_REP user. The EMP table is owned by theSCOTT user. The SL_REP user executes the followin 阅读全文
posted @ 2017-12-01 11:06
巴啦啦大魔王
阅读(113)
评论(0)
推荐(0)
摘要:
Observe the information in the columns:1. The SGA2. The cursor state3. User-session data4. The stack spacea. Text and parsed forms of all SQL statemen 阅读全文
posted @ 2017-12-01 10:57
巴啦啦大魔王
阅读(178)
评论(0)
推荐(0)
摘要:
Note the following points describing various utilities in Oracle Database 11g:1. It enables the transfer of data from one database to another--数据泵(ben 阅读全文
posted @ 2017-12-01 10:40
巴啦啦大魔王
阅读(161)
评论(0)
推荐(0)
摘要:
The database instance is currently using SPFILE. View the Exhibit and examine the error that you received while running the DB Structure Integrity che 阅读全文
posted @ 2017-12-01 10:13
巴啦啦大魔王
阅读(129)
评论(0)
推荐(0)
摘要:
While observing the index statistics, you find that an index is highly fragmented, thereby resulting in poor database performance. Which option would 阅读全文
posted @ 2017-12-01 09:55
巴啦啦大魔王
阅读(163)
评论(0)
推荐(0)
浙公网安备 33010602011771号