Free Oracle 1Z1-050 Exam Dumps Questions & Answers

View the Exhibits exhibit1 and exhibit2.

Both the processes use PROG_1 as the job template that is already available. The time taken by the jobs are recorded in the TEST_LOG table. While comparing the time taken to create the jobs, the process in exhibit1 takes less time than the process in exhibit2.
What is the reason for this?

• A.  It writes the job metadata to disk in compressed format.
• B.  It creates jobs temporarily in memory only.
• C.  It updates several tables in the SYSTEM tablespace instead of creating new tables.
• D.  It creates less metadata for the jobs.

Which three statements are true regarding the functioning of the Autotask Background Process (ABP)? (Choose three.)

• A.  It is spawned by the MMON background process at the start of the maintenance window.
• B.  It maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks.
• C.  It translates tasks into jobs for execution by the scheduler
• D.  It creates jobs without considering the priorities associated with them.
• E.  It determines the list of jobs that must be created for each maintenance window.

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

View the Exhibit to examine the Automatic SQL Tuning result details.

Which action would you suggest for the selected SQL statement in the Exhibit?

• A.  Run the Access Advisor for the SQL statement.
• B.  Run the Segment Advisor for recommendations.
• C.  Accept the recommended SQL profile.
• D.  Collect statistics for the related objects.

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 added to the fixed SQL plan baseline as a nonfixed plan.
• B.  The tuned plan is not added to the SQL plan baseline.
• C.  The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.
• D.  The tuned plan is added to the fixed SQL plan baseline as a fixed plan.