최신Oracle Database 11g: New Features for Administrators - 1Z1-050무료샘플문제
문제1
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?
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?
정답: C
문제2
You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?
You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?
정답: D
문제3
Which two statements are true regarding hot patching? (Choose two.)
Which two statements are true regarding hot patching? (Choose two.)
정답: A,C
문제4
Examine the following PL/SQL block:
DECLARE
my_plans plsjnteger;
BEGIN
My_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE (sql_Id =>
?9twu5t2dn5xd?;
END;
Which statement is true about the plan being loaded into the SQL plan baseline by the above command?
Examine the following PL/SQL block:
DECLARE
my_plans plsjnteger;
BEGIN
My_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE (sql_Id =>
?9twu5t2dn5xd?;
END;
Which statement is true about the plan being loaded into the SQL plan baseline by the above command?
정답: A
문제5
To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code:
BEGIN
dbms_advisor.create_task(dbms_advisor.sqlaccess_advisor,lTASK1l);
END;
/
BEGIN
dbms_advisor.set_task_parameter(lTASK1l,lANALYSIS_SCOPElllALLl);
dbms_advisor.set_task_parameter(lTASK1,,,MODE,llCOMPREHENSIVEl);
END;
/
BEGIN
dbms_advisor.execute_task('TASK1');
dbms_output.put_line(dbms_advisor.get_task_script('TASK11));
END;
/
The blocks of code execute successfully; however, you do not get the required outcome.
What could be the reason?
To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code:
BEGIN
dbms_advisor.create_task(dbms_advisor.sqlaccess_advisor,lTASK1l);
END;
/
BEGIN
dbms_advisor.set_task_parameter(lTASK1l,lANALYSIS_SCOPElllALLl);
dbms_advisor.set_task_parameter(lTASK1,,,MODE,llCOMPREHENSIVEl);
END;
/
BEGIN
dbms_advisor.execute_task('TASK1');
dbms_output.put_line(dbms_advisor.get_task_script('TASK11));
END;
/
The blocks of code execute successfully; however, you do not get the required outcome.
What could be the reason?
정답: B
문제6
Evaluate the following command and Its output:
SQL>SELECT * FROM dba_temp_free_space;
TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
LMTEMP 250609664 101048576 149561088
Which two statements correctly interpret the output? (Choose two.)
Evaluate the following command and Its output:
SQL>SELECT * FROM dba_temp_free_space;
TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
LMTEMP 250609664 101048576 149561088
Which two statements correctly interpret the output? (Choose two.)
정답: A,B
문제7
View the Exhibit for some of the parameter settings.
You start a session and issue the following command:
SQL>CREATE INDEX emp_ename ON emp(ename)
TABLESPACE users INVISIBLE;
What is the outcome of the above command?
View the Exhibit for some of the parameter settings.
You start a session and issue the following command:
SQL>CREATE INDEX emp_ename ON emp(ename)
TABLESPACE users INVISIBLE;
What is the outcome of the above command?
정답: B
문제8
You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?
You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?
정답: C
문제9
View the Exhibit to observe the error.
You receive this error regularly and have to shut down the database instance to overcome the error. What can the solution be to reduce the chance of this error in future, when implemented?
View the Exhibit to observe the error.
You receive this error regularly and have to shut down the database instance to overcome the error. What can the solution be to reduce the chance of this error in future, when implemented?
정답: C
문제10
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?
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?
정답: D
문제11
Which three are the valid statements in relation to SQL plan baselines? (Choose three.)
Which three are the valid statements in relation to SQL plan baselines? (Choose three.)
정답: A,B,C
문제12
An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the
ORDERS table using the following command:
SQL>CREATE INDEX ord_custname_ix ON orders(custname);
The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause.
You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.
Which is the most efficient method of performing this task?
An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the
ORDERS table using the following command:
SQL>CREATE INDEX ord_custname_ix ON orders(custname);
The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause.
You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.
Which is the most efficient method of performing this task?
정답: B
문제13
You are managing an Oracle Database 11 g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command:
RMAN>BACKUP
SECTION SIZE 300M
TABLESPACE users;
What configuration should be effected to accomplish faster and optimized backups by using the above command?
You are managing an Oracle Database 11 g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command:
RMAN>BACKUP
SECTION SIZE 300M
TABLESPACE users;
What configuration should be effected to accomplish faster and optimized backups by using the above command?
정답: A
문제14
Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs?
Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs?
정답: D