摘要：
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 阅读全文
摘要：
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 阅读全文
摘要：
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 阅读全文
摘要：
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 阅读全文
摘要：
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 阅读全文
摘要：
Note the following points describing various utilities in Oracle Database 11g:1. It enables the transfer of data from one database to another--数据泵(ben 阅读全文
摘要：
The database instance is currently using SPFILE. View the Exhibit and examine the error that you received while running the DB Structure Integrity che 阅读全文
摘要：
While observing the index statistics, you find that an index is highly fragmented, thereby resulting in poor database performance. Which option would 阅读全文