1Z0-055 試験問題を無料オンラインアクセス

While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences? (Choose two.)

• A.The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.
• B.The plan baselines can be evolved over time to produce better performance.
• C.The newly generated plans are directly placed into the SQL plan baseline without being verified.
• D.The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.

Which statements are true regarding the creation of an incident package file by using the EM Workbench Support? (Choose all that apply.)

• A.You can add or remove the trace files to the package.
• B.You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.
• C.You cannot create an incremental incident package when the physical files are purged from the ADR.
• D.You can add SQL test cases to the incident package.

View the Exhibit exhibit1 to observe the maintenance window property.
View the Exhibit exhibit2 to examine the output of the query.
Which two statements describe the conclusions? (Choose two.)

• A.The window duration should be increased.
• B.RESOURCE_PERCENTAGE should be decreased.
• C.RESOURCE_PERCENTAGE should be increased.
• D.The repeat time for the window should be decreased.

You issued the following command:
CREATE GLOBAL TEMPORARY TABLE admin_work_area
(startdate DATE,
enddate DATE,
class CHAR(20))
ON COMMIT DELETE ROWS
TABLESPACE tbs_t1;
An index is then created on the ADMIN_WORK_AREA temporary table.
Which two statements are true regarding the TBS_T1 tablespace in the above command? (Choose two.)

• A.It can be a default or nondefault temporary tablespace for the database.
• B.It stores both the temporary table as well as its indexes.
• C.It stores only the temporary table but not its indexes.
• D.It must be a nondefault temporary tablespace for the database.
• E.It must be the default temporary tablespace of the user who issues the command.

You are working on the APPDB database as a DBA. The database has a default Flashback Data Archive DFLA1 created on it.
You issued the following command to drop the Flashback Archive FLA1:
DROP FLASHBACK ARCHIVE fla1;
What is the effect of this command?

• A.The Flashback Data Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.
• B.The Flashback Data Archive FLA1 and historical data are dropped.
• C.The tablespace having Flashback Archive is dropped.
• D.The Flashback Data Archive FLA1 is dropped only if it is empty.