【正文】 YSDATE+139。RESTORE POINT TESTDB06。Which two statements are true regarding the backup taken by using the above RMAN mand?(Choose two.)A. Only data files and the control file are backed up.B. Archived redo logs are backed up only if the database is open during the backup.歸檔重做日志備份只備份期間如果數(shù)據(jù)庫是開放的。C. The backup is deleted after one day, regardless of the default retention policy settings.D. The backup bees obsolete after one day, regardless of the default retention policy settings. 備份變得過時的一天后,無論默認(rèn)保留策略設(shè)置。 want the Automatic SQL Tuning process to stop accepting and implementing the remended SQL profiles automatically. Which action would you perform to achieve this? 你想要自動SQL調(diào)優(yōu)過程停止接受和實(shí)現(xiàn)自動推薦的SQL文件A. Edit the automatic maintenance window group configuration.B. Set the CURSOR_SHARING parameter to EXACT for the database instance.C. Use the procedure to setACCEPT_SQL_PROFILES to FALSE.D. Set the SQLTUNE_CATEGORY parameter to DEFAULT for the database instance. two statements are true regarding the functionality of the remap mand in ASMCMD? 這兩個語句是正確的關(guān)于重新映射的功能在ASMCMD命令嗎?(Choose two.)A. It repairs blocks that have read disk I/O errors. 它修復(fù)塊讀過磁盤I / O錯誤。B. It checks whether the alias metadata directory and the file directory are linked correctly.C. It repairs blocks by always reading them from the mirror copy and writing them to the original location.D. It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location ondisk if the blocks on the original location cannot be read properly.、讀取塊從一個好復(fù)制的ASM鏡子,重寫他們另一個磁盤上的位置如果原始位置上的塊不能正常閱讀。 the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable settingaffect the installation?The safer , easier way to help you pass any IT exams.12 / 193A. The installation terminates with an error.B. The installation proceeds with the default value without warnings and errors.C. The installation proceeds with the default value but it would not be an OFApliant database.D. The installation proceeds with the default value but a message would be generated in the alert log file. 安裝與默認(rèn)值收益但消息將日志文件中生成警報。 SQL Tuning Advisor configuration has default settings in your database instance. Which remendation is automatically implemented after the SQL Tuning Advisor is run as part of theautomatic maintenance task?SQL調(diào)優(yōu)顧問配置默認(rèn)設(shè)置在你的數(shù)據(jù)庫實(shí)例。這建議是自動運(yùn)行SQL調(diào)優(yōu)后實(shí)施顧問上自動維護(hù)任務(wù)的一部分嗎?A. statistics remendationsB. SQL Profile remendationsC. Indexrelated remendationsD. restructuring of SQL remendations the Exhibit to examine the Automatic SQL Tuning result details. Which action would you suggestfor the selected SQL statement in the Exhibit?A. Accept the remended SQL profile.B. Collect statistics for the related objects.C. Run the Access Advisor for the SQL statement. 運(yùn)行SQL語句的訪問顧問。D. Run the Segment Advisor for remendations. 運(yùn)行部分顧問的建議。SQL優(yōu)化指導(dǎo)會分別考察指導(dǎo)任務(wù)中包括的每個SQL語句。創(chuàng)建一個新索引可能會對查詢有幫助，但也可能增加DML 的響應(yīng)時間。因此，應(yīng)使用SQL 訪問指導(dǎo)檢查建議的索引或其它對象對工作量（一組SQL語句）的影響，以確定性能是否有凈提高。 the following code:SQLVARIABLE task_name VARCHAR2(255)。 SQLVARIABLE sql_stmt VARCHAR2(4000)。SQLBEGIN :sql_stmt := 39。SELECT COUNT(*) FROM customersThe safer , easier way to help you pass any IT exams.13 / 193WHERE cust_state_province =39。39。CA39。39。39。:task_name := 39。MY_QUICKTUNE_TASK39。(,:task_name, :sql_stmt)。END。What is the oute of this block of code?A. It creates a task and workload, and executes the task.B. It creates a task and workload but does not execute the task.C. It produces an error because a template has not been created.D. It produces an error because the SQL Tuning Set has not been created. have applications that have frequently executed queries, and produce small and static result sets. 應(yīng)用程序頻繁執(zhí)行的查詢,生產(chǎn)小型和靜態(tài)結(jié)果集。You configure the file in the client machine to set a nonzero value for theOCI_RESULT_CACHE_MAX_SIZE parameter. What is the purpose of this configuration?A. to avoid round trips to the server by enabling caching of query results in client memory為了避免往返服務(wù)器通過啟用緩存查詢結(jié)果的客戶機(jī)的記憶B. to improve performance by storing a copy of the data from the private SQL area of the PGAC. to enhance the query performance by creating a cache in the client memory for sorting operationsD. to avoid the storing of query plans and results in the server by creating a cache in the client memory plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process? (Choose allthat apply.)A. the SQL textB. the execution planC. the execution contextD. the execution frequencyE. the system change number (SCN) the following SQL statements:Transaction T1 INSERT INTO VALUES (5,39。Pole39。)。COMMIT。Transaction T2 UPDATE SET region_name=39。Poles39。 WHERE region_id = 5。 COMMIT。Transaction T3 UPDATE SET region_name=39。North and South Poles39。 WHERE region_id = 5。You want to back out transaction T2. Which option would you use?A. It is possible, but transaction T3 also backs out.B. It is possible with the NOCASCADE_FORCE option.C. It is possible with the NONCONFLICT_ONLY option.D. It is not possible because it has conflicts with transaction T3. have a very large table that your users access frequently. Which of the following advisors will remend any indexes to improve the performance of queries against this table?下面哪個建議將用來提高查詢性能針對這張表A. The Automatic Memory Manager (AMM)B. The SQL Tuning AdvisorC. The Segment AdvisorD. The SQL Access Advisor SQL Access Advisor是伴隨著10G出現(xiàn)的一個優(yōu)化工具,提供對表分區(qū),物化視圖,索引,物化視圖日志優(yōu)化建議. is the advantage of setting the ASMpreferred mirror read for the Stretch cluster configuration?為可伸縮集群設(shè)置ASMpreferred鏡像的優(yōu)勢是什么A. It improves resync operations.B. This feature enables much faster file opens.C. It improves performance as fewer extent pointers a