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

Which two statements about the SQL Management Base (SMB) are true? (Choose two.)

• A.It contains the statement log, the plan history, plan baselines, and SQL profiles.
• B.It is part of the data dictionary and stored in the SYSTEM tablespace.
• C.It stores plans generated by the optimizer using a stored outline.
• D.It is part of the data dictionary and stored in the SYSAUXtablespace.
• E.It contains only SQL profiles generated by SQL Tuning Advisor.

Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g? (Choose all that apply.)

• A.It is created by default with the window size being equal to the AWR retention time.
• B.It does not allow you to change the moving window size,
• C.Adaptive threshold functionalities use it by default to compute statistics.
• D.It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).

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 newly generated plans are directly placed into the SQL plan baseline without being verified.
• C.The plan baselines can be evolved over time to produce better performance
• D.The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.

Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of
data is added to the table daily. To save disk space, you issued the following command:
ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS;
What would be the outcome of this command?

• A.It produces an error because data already exists in the table.
• B.It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.
• C.It produces an error because compression can be enabled at table creation only.
• D.It immediately compresses all existing data as well as new data, resulting from either fresh additions or modifications to existing data.

You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database. Which configuration should you use to accomplish this task?

• A.Specify undo retention guarantee for the database.
• B.Create Flashback Data Archive on the tablespace on which the tables are stored.
• C.Enable supplemental logging for the database.
• D.Enable Flashback Data Archive for the tables.
• E.Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo tablespace for that size.