-
编辑 删除
043-013
13. You executed the following query:SELECT operation, undo_sql, table_name FROM flashback_transaction_query;Which statement is correct regarding the query output?A. It would return information regard...
-
编辑 删除
043-012
12. You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? (Choose two.)A. Flashback logs are not archi...
-
编辑 删除
043-010
10. The current time zone for one of the user sessions is set to thedatabase local time zone. For one application, the user session requires the time zone to be set to the local operating system time ...
-
编辑 删除
043-009
9.Exhibit L1 L2 L3Low Group: 10 0 100Other Groups 0 ...
-
编辑 删除
043-008
8. You are using Oracle Database 10g. Which statement regarding anincomplete recovery is true?A. You do not need to restore all the data files.B. You do not need to open the database with the RESE...
-
编辑 删除
043-007
7. In your database, online redo log files are multiplexed and one of themembers in a group is lost due to media failure?How would you recover the lost redo log member?A.import the database from t...
-
编辑 删除
043-015
15. You work as a database administrator at Certkiller .com. In yourproduction database there is a job, CALC_STAT, which has been scheduled to run every Friday at 5.00 p.m. CALC_STAT updates the optim...
-
编辑 删除
043-011
11. You work as a database administrator at Certkiller .com. Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning, while querying the ...
-
编辑 删除
043-006
6.ExhibitYou executed the following command to perform. a backup of theUSERStablespace:RMAN > BACKUP TABLESPACE USERS;Which type of backup would this command perform?A. backup setB. image copyC. i...
-
编辑 删除
043-005
5. You are performing a block media recovery on the tools01.dbf data filein the SALES database using RMAN. Which two statements are correct in thisscenario? (Choose two.)A. You must ensure that the SA...
-
编辑 删除
043-004
4. You have set some of the initialization parameters as:DB_BLOCK_SIZE=8KBSGA_MAX_SIZE=2GBSGA_TARGET =0SHARED_POOL_SIZE=120MBDB_CHCHE_SIZE=896MBSTREAM_POOL_SIZE=0LARGE_POOL_SIZE=110MBWhich two stateme...
-
编辑 删除
043-003
3. One of the tablespace is read-only in your database. The loss of allcontrol file forced you to recreate the control file. Which operation doyou need to perform. after re-creating the control file a...
-
编辑 删除
043-002
2.ExhibitIn your production database, the total waits and the time waited for logfile parallel write are significantly high. While investigating thereason, you find that there are three redo log group...
-
编辑 删除
使用LOCK_SGA锁住内存
如果让内存中得SGA被交换到操作系统上的虚拟内存。那么由于io因素会导致数据库的性能下降。 可以用lock sga的方法将sga锁住 oracle用户修改initSID.ora中lock_sga=true ...
-
编辑 删除
043-001
1.You observe that a database performance has degraded overa period of time. While investigating the reason, you find the size ofthe database buffer cache is not large enough to cache all the needed d...
-
编辑 删除
shutdown immediate 后无法连接数据库的解决办法
下面是方法是从网上收集到的，这里整理给大家使用（已测试安装成功） Oracle 10G 关闭数据库（shutdown immediate ）后，通过SQL Plus 连接数据库:conn sys/his@orc0 as sysdba ，出现如下...
