摘要：
Identify the logical structure that will never have more than one data segment created for it.A.external tableB.partitioned tableC.partitioned indexD. 阅读全文
摘要：
You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows:Warning (%): 90Critical (%): 95Which background process is r 阅读全文
摘要：
16.Note the following functionalities of various background processes:1: Record the checkpoint information in data file headers.--CKPT2: Perform recov 阅读全文
摘要：
Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.)A. Shared SQL Area will be allocated in the shared poolB. Share 阅读全文
摘要：
These are points that describe the contents of different memory components:1: Descriptive information or metadata about schema objects that are querie 阅读全文
摘要：
You have executed this command to change the size of the database buffer cache:SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582;System altered.To verify th 阅读全文
摘要：
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 阅读全文