#64. Consider an Oracle instance that is using Automatic Shared Memory Management. You set some of the System Global Area (SGA) parameters as shown below: SGA_TARGET = 200 MB SHARED_POOL_SIZE= 20 MB DB_KEEP_CACHE_SIZE = 30 MB Which two statements are correct in this scenario? (Choose two.)
#65. An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?
#66. You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ‘ora_%t_%s_%r.log’. Which statement regarding the archived redo log files, created in an earlier incarnation of the database, is true?
#67. Exhibit View the exhibit and examine the query output. You are logged in as user SYSTEM. You plan to relocate the Ultra Search occupant back to the SYSAUX tablespace from the OCCU_TBS tablespace by using a SQL statement. Which command would you use?
#68. You explicitly specified the tablespace usage threshold values while creating a tablespace. You need to revert the database-wide default tablespace usage threshold values for the tablespace. Which PL/SQL package would you use?
#70. You have 100 segments in the USERS tablespace. You get an alert that the USERS tablespace is running low on space. You decide to shrink some segments. Which option would you use to determine which segment to shrink?
gen. 0.063
Forum
Master braindump