You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.<br /> Which three storage options support the use of HCC?（）<p> You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.<br /> Which three storage options support the use of HCC?（）</p>..

第1题

[单选题] Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements. What would you do with these SQL statements?（）

A、Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans. B、Capture the plans from the previous version using STS and then load them into the stored outline. C、Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB). D、Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.

点击查看答案

第2题

[单选题] You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? （）

A、to minimize plan regression due to the use of a new optimizer version B、to completely avoid the use of new plans generated by a new optimizer version C、to prevent plan capturing when the SQL statement is executed after the database upgrade D、to keep the plan in the plan history so that it can be used when the older version of the optimizer is used

点击查看答案

第3题

[单选题] You use Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. You create a game where a ball drops from the top to the bottom of a window. You plan to create a single animation for the game. You need to ensure that the animation shows the ball bounce. What should you do?（）

A、Use the KeySpline property of a SplineDoubleKeyFrame object. B、Use the EasingFunction property of an EasingDoubleKeyFrame object. C、Use the DecelerationRatio and AutoReverse properties of a StoryBoard object. D、Use the DecelerationRatio and AccelerationRatio properties of a StoryBoard object.

点击查看答案

第4题

[] You use Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. You plan to use an existing Windows Forms control named MyWinFormControl in the MyControls assembly. You need to ensure that the control can be used in your application. What should you do?（） You use Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. You plan to use an existing Windows Forms control named MyWinFormControl in the MyControls assembly. You need to ensure that the control can be used in your application. What should you do?（）

A、A.
B.
C.
D.

点击查看答案

第5题

[单选题] You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?（）

A、The tuned plan is not added to the SQL plan baseline. B、The tuned plan is added to the fixed SQL plan baseline as a fixed plan. C、The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan. D、The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.

点击查看答案

第6题

[单选题] You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?（）

A、The tuned plan is not added to the SQL plan baseline. B、The tuned plan is added to the fixed SQL plan baseline as a fixed plan. C、The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan. D、The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.

点击查看答案

第7题

[多选题] You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories. You plan to create the database using SQL statements. Which three techniques can you use to achieve this?（）

A、Use Oracle Managed Files (OMF). B、Specify the SEED FILE_NAME_CONVERT clause. C、Specify the PDB_FILE_NAME_CONVERT initialization parameter. D、Specify the DB_FILE_NAMECONVERT initialization parameter. E、Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).

点击查看答案

第8题

[] Refer to the exhibit. ROUTE.com is planning to implement a secure OSPF network to support traffic between clients on the 172.16.10.0/24 network and the file server on the 172.16.20./24 network. You have been asked to review the implementation and verification plans. Which statement about the plan is true?（） Refer to the exhibit. ROUTE.com is planning to implement a secure OSPF network to support traffic between clients on the 172.16.10.0/24 network and the file server on the 172.16.20./24 network. You have been asked to review the implementation and verification plans. Which statement about the plan is true?（）

A、A. It is complete as written B、B. It should include a task that verifies that the interarea routes are using the proper MED C、C. The plan should include a task that verifies that load sharing is active on the appropriate links D、D. The plan should include a task that verifies end - to - end connectivity between the clients and the file server

点击查看答案

第9题

[单选题] View the Exhibit exhibit1 to examine the series of SQL commands. View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline. The baseline in the first row of the Exhibit is created when OPTIMIZER_MODE was set to FIRST_ROWS. Which statement is true if the SQL query in exhibit1 is executed again when the valueof OPTIMIZER_MODE is set to FIRST_ROWS?（）

A、The optimizer uses a new plan because none of the plans in the exhibit2 are fixed plans. B、The optimizer uses the plan in the second row of the exhibit2 because it is an accepted plan. C、The optimizer uses the plan in the first row of the exhibit2 because it is the latest generated plan. D、The optimizer uses the plan in the first row of the exhibit2 because OPTIMIZER_MODE was set to FIRST_ROW during its creation.

点击查看答案

第10题

[多选题] You 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?（）

A、the SQL text SQL B、the execution plan C、the execution context D、the execution frequency E、the system change number (SCN)

点击查看答案

请使用微信扫码支付