Examsoon認證考試題庫－始終致力與爲客戶提供Oracle認證的全真考題及認證學習資料,助您壹次通過Oracle認證考試。
Oracle認證考試1z0-043考古題分享：
1.You observe that a database performance has degraded over a period of time. While investigating the reason, you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to, in order to determine that required size of the database buffer cache?
A. Memory Advisor
B. Segment Advisor
C. SQL Tuning Advisor
D. SQL Access Advisor
E. Automatic Database Diagnostic Monitor (ADDM)
Answer: A
2. One of the tablespace is read-only in your database. The loss of all control files forced you to recreate the control file. Which operation do you need to perform after re-creating the control file and opening the database?
A. drop and re-create the read-only tablespaces
B. rename the read-only data files to their correct file names
C. change the tablespace status from read/write to read-only
D. re-create the read-only tablespace because it is automatically removed
Answer: B
3. In your database, online redo log files are multiplexed and one of the members in a group is lost due to media failure? How would you recover the lost redo log member?
A. import the database from the last export
B. restore all the members in the group from the last backup
C. drop the lost member from the database and then add a new member to the group
D. restore all the database files from the backup and then perform a complete recovery
E. restore all the database files from the backup and then perform an incomplete recovery
Answer: C
4. You are using Oracle Database 10g. Which statement regarding an incomplete 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 RESETLOGS operation
C. You do not need to perform a full backup after the RESETLOGS operation.
D. You do not need to recover all the data files to the same system change number (SCN).
Answer: C
5. 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 regarding only the last committed transaction.
B. It would return only the active transactions in all the undo segments in the database.
C. It would return only the committed transactions in all the undo segments in the database.
D. It would return both active and committed transactions in all the undo segments in the database.
E. It would return information regarding the transactions that began and were committed in the last 30 minutes.
Answer: D
6. You lost the PRODSTD tablespace, which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace?
A. restore the tablespace from the backup; there is no need to apply the redo information
B. restore the full database to recover the data up to the point when you performed the backup
C. restore the tablespace from the backup and then perform a recovery using the backup control file
D. restore the tablespace from the backup and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied
Answer: D
1Z0-043考試資料：
Oracle Database 10g: Administration II
科目編號 : 1Z0-043
科目名稱 : Oracle Database 10g: Administration II
1Z0-043 考試是Oracle認證的 Oracle Database 10g: Administration II 認證考試官方代號，Oracle Database 10g: Administration II 認證作為全球IT領域專家 Oracle 熱門認證之壹，是許多大中IT企業選擇人才標準的必備條件。
10g DBA 認證是業界最廣泛認可的IT技術認證之壹，也是業界最權威、最受尊敬的認證之壹。獲得1Z0-043認證不僅僅能證明您的IT技術能力，更是您進入職場的敲門磚，也是提高您身價的另壹捷徑。
Examsoon的Oracle認證考古題由資深IT認證講師和Oracle産品專家結合PROMETRIC或VUE的真實考試環境最新原題傾心打造。
分享更多證照考試科目代碼：
留言列表
