Oracle Database 11g: New Features for Administrators - 1Z1-050무료 덤프문제 풀어보기
Observe the following warning in an RMAN session of your database instance:
WARNING: new failures were found since last LIST FAILURE command
Which statement describes the scenario that must have produced this warning?
WARNING: new failures were found since last LIST FAILURE command
Which statement describes the scenario that must have produced this warning?
정답: A
Which three statements are true regarding persistent lightweight jobs? (Choose three.)
정답: B,C,E
Which statement is true regarding the retention policy for the incidents accumulated in the Automatic Diagnostic Repository (ADR)?
정답: B
You are managing an Oracle Database 11 g database. You want to take the of size 100 TB on tape drive, but you have tape drives of only 10 GB each, quickly and efficiently?
정답: C
Evaluate the following function code:
CREATE FUNCTION get_dept_avg(dept_id NUMBER)
RETURN NUMBER
RESULT_CACHE RELIES_ON (EMPLOYEES)
IS
avgsal NUMBER(6);
BEGIN
SELECT AVG(SAU\RY)INTO avgsal
FROM EMPLOYEES
WHERE DEPARTMENTJD = dept_id;
RETURN avgsal;
END get_dept_avg;
Which statement is true regarding the above function?
CREATE FUNCTION get_dept_avg(dept_id NUMBER)
RETURN NUMBER
RESULT_CACHE RELIES_ON (EMPLOYEES)
IS
avgsal NUMBER(6);
BEGIN
SELECT AVG(SAU\RY)INTO avgsal
FROM EMPLOYEES
WHERE DEPARTMENTJD = dept_id;
RETURN avgsal;
END get_dept_avg;
Which statement is true regarding the above function?
정답: B
Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?
정답: A
Which two changes and their effect on the system can be tested by using the Database Replay feature? (Choose two.)
정답: A,C
Which two statements about workload capture and replay operations are true? (Choose two.)
정답: C,D
View the Exhibit to examine a portion of the output from the VALIDATE DATABASE command.
Which statement is true about the block corruption detected by the command?
Which statement is true about the block corruption detected by the command?
정답: B
Which tasks are run automatically as part of the Automated Maintenance Task by default? (Choose all that apply.)
정답: A,C,E
You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set? (Choose two.)
정답: C,D