최신Oracle9i dba new features for Oracle7.3 and Oracle9 ocps - 1Z0-035무료샘플문제
문제1
Click the Exhibit button and examine the extract from a SQL*Plus session.
Assuming that there is at least one row for each value shown in the HIGH_VALUE column, what is the result of the ALTER TABLE statement?
Click the Exhibit button and examine the extract from a SQL*Plus session.
Assuming that there is at least one row for each value shown in the HIGH_VALUE column, what is the result of the ALTER TABLE statement?
정답: A
문제2
Examine the statement:
DROP TABLESPACE IND2 INCLUDING CONTENTS AND DATAFILES;
What is the result of the statement?
Examine the statement:
DROP TABLESPACE IND2 INCLUDING CONTENTS AND DATAFILES;
What is the result of the statement?
정답: B
문제3
What is true regarding a shared, server-side parameter file for a Real Application Clusters database?
What is true regarding a shared, server-side parameter file for a Real Application Clusters database?
정답: B
문제4
When should you delete rows from a partition before dropping it?
When should you delete rows from a partition before dropping it?
정답: D
문제5
What must you do to enable Automated SQL Execution Memory Management?
What must you do to enable Automated SQL Execution Memory Management?
정답: B
문제6
An index-organized table (IOT) called SPARSE has had many records deleted.
Which command reorganizes the IOT so that the empty space is removed, while minimizing the impact for users?
An index-organized table (IOT) called SPARSE has had many records deleted.
Which command reorganizes the IOT so that the empty space is removed, while minimizing the impact for users?
정답: B
문제7
Examine this statement:
SELECT *
FROM ( SELECT class_id, crs_id
FROM classes
ORDER BY start_date DESC)
WHERE ROWNUM < 11;
What will happen when this executes?
Examine this statement:
SELECT *
FROM ( SELECT class_id, crs_id
FROM classes
ORDER BY start_date DESC)
WHERE ROWNUM < 11;
What will happen when this executes?
정답: C
문제8
Which configuration file must be edited to enable connection pooling?
Which configuration file must be edited to enable connection pooling?
정답: C
문제9
Examine this fragment from a SQL*Plus session:
SQL> SELECT name, value FROM v$sysstat 2> WHERE name LIKE 'work area executions%';
NAME VALUE
work area executions - optimal 1544 work area executions - onepass 11 work area executions - multipass 1038
What can you conclude about the setting of the PGA_AGGREGATE_TARGET initialization parameter?
Examine this fragment from a SQL*Plus session:
SQL> SELECT name, value FROM v$sysstat 2> WHERE name LIKE 'work area executions%';
NAME VALUE
work area executions - optimal 1544 work area executions - onepass 11 work area executions - multipass 1038
What can you conclude about the setting of the PGA_AGGREGATE_TARGET initialization parameter?
정답: B
문제10
Which three table transformations can be done using online redefinition of tables? (Choose three.)
Which three table transformations can be done using online redefinition of tables? (Choose three.)
정답: A,B,E
문제11
Consider this RMAN command:
RMAN> CONFIGURE RETENTION POLICY CLEAR;
What is the effect of this command?
Consider this RMAN command:
RMAN> CONFIGURE RETENTION POLICY CLEAR;
What is the effect of this command?
정답: C
문제12
Consider the following statement:
SQL> EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS (2> ownname => 'OE', 3> estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, 4> method_opt => 'for all columns size AUTO');
What is the effect of 'for all columns size AUTO' of the METHOD_OPT option?
Consider the following statement:
SQL> EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS (2> ownname => 'OE', 3> estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, 4> method_opt => 'for all columns size AUTO');
What is the effect of 'for all columns size AUTO' of the METHOD_OPT option?
정답: A
문제13
What is the maximum number of parallel recovery servers when the FAST_START_PARALLEL_ROLLBACK parameter is set to HIGH?
What is the maximum number of parallel recovery servers when the FAST_START_PARALLEL_ROLLBACK parameter is set to HIGH?
정답: B