OCA-16-Controlling Resources and Jobs

Question 1 of 20

1

1. Which of these is performed by the Resource Manager?

Select one or more of the following:

A. Percentages of CPU time are split up.
B. Percentages of memory are split up.
C. Percentages of swap space in *nix and virtual memory in Windows are split up.
D. Disk space is split up.

Explanation

Question 2 of 20

1

2. Which of these can be controlled by Resource Manager?

Select one or more of the following:

A. Active session limits per user groups
B. Assigning priorities
C. Controlling runaway or out-of-control sessions
D. Session idle time limits
E. All of the above

Explanation

Question 3 of 20

1

3. Which of the following is the most significant and most effective allocation method
controlled by the Resource Manager?

Select one or more of the following:

A. Allocate CPU use between competing sessions
B. Allocate CPU use between competing sessions based on priorities
C. Limiting parallel processing
D. Session idle time limits

Explanation

Question 4 of 20

1

4. How can runaway sessions be curtailed and prevented from overwhelming a system?
(Choose two.)

Select one or more of the following:

A. Automatically aborting a session when archive log space is filled
B. Automatically aborting a session when rollback reaches an upper limit
C. Automatically aborting a transaction inside a session when the transaction is
too large
D. Automatically changing the CPU use of a session to a consumer group with a
lower priority

Explanation

Question 5 of 20

1

5. Which of these is a Resource Manager object?

Select one or more of the following:

A. Plan direction
B. Resource consumer plan
C. Resource allocation method
D. Subplan directive

Explanation

Question 6 of 20

1

6. Which of these packages are used to administer the Resource Manager? (Choose two.)

Select one or more of the following:

A. DBMS_RESOURCE_MANAGER
B. DBMS_RESOURCE_MANAGEMENT
C. DBMS_RESOURCE_MANAGE
D. DBMS_RESOURCE_MANAGER_PRIVS
E. DBMS_RESOURCE_MANAGEMENT_PRIVS

Explanation

Question 7 of 20

1

7. A consumer group object can be assigned to which of the following? (Choose two.)

Select one or more of the following:

A. A plan
B. A subplan
C. A consumer group
D. None of the above

Explanation

Question 8 of 20

1

8. If a plan contains two subplans and one consumer group is below the subplan level,
and each of the subplans is allocated 45 percent of CPU cycles each, what is the most
that can be allocated to the consumer group, assuming that the subplans and plan are
fully occupied?

Select one or more of the following:

A. 11 percent
B. 45 percent
C. 5 percent
D. 0 percent
E. None of the above

Explanation

Question 9 of 20

1

9. Which of these can help prevent parallel processing limits from being exceeded, and
help to prevent a database from being swamped by parallel executing queries?

Select one or more of the following:

A. Degree of parallelism
B. Parallel server processes
C. Parallel queue timeouts
D. All of the above
E. None of the above

Explanation

Question 10 of 20

1

10. How many levels of utilization are there for CPU allocation in the Resource Manager?

Select one or more of the following:

A. 0
B. 1
C. 15
D. 8
E. None of the above

Explanation

Question 11 of 20

1

11. Which database parameter has an impact on running the Scheduler jobs?

Select one or more of the following:

A. PARALLEL_MAX_SERVERS
B. JOB_QUEUE_PROCESSES
C. AQ_TM_PROCESSES
D. JOB_SCHEDULE_PROCESSES

Explanation

Question 12 of 20

1

12. Which of these are valid Resource Manager–specific privileges?

Select one or more of the following:

A. GRANT_SYSTEM_PRIVS
B. GRANT_SYSTEM_PRIVILEGES
C. GRANT_SYS_PRIVS
D. None of the above

Explanation

Question 13 of 20

1

13. Which of these are initial default resource consumer groups? (Choose two.)

Select one or more of the following:

A. SYSTEM_GROUP
B. OTHER_GROUP
C. OTHER_SYSTEM_GROUP
D. SYS_GROUP
E. OTHER_GROUPS

Explanation

Question 14 of 20

1

14. With what types of resources does the CREATE_SIMPLE_PLAN procedure work?

Select one or more of the following:

A. *nix cron jobs
B. Oracle Scheduler job classes
C. CPU resource allocations only
D. Creates multiple plans
E. None of the above

Explanation

Question 15 of 20

1

15. How many consumer groups, CPU percentages, and simple plans can the
CREATE_SIMPLE_PLAN procedure create?

Select one or more of the following:

A. 4, 4, and 1
B. 8, 8, and 8
C. 1, 1, and 8
D. 8, 8, and 1
E. None of the above

Explanation

Question 16 of 20

1

16. Why does the pending area exist? (Choose the best answer.)

Select one or more of the following:

A. Because there is only one plan active at one time.
B. Because there is only one plan active at one time, and changing the pending area
changes the running plan.
C. Because there is only one plan active at one time, and changing the pending area
does not change the actively running plan.
D. Because there is only one plan active at one time, and changing the pending area
does not change the actively running plan until the pending area has been validated.
E. None of the above.

Explanation

Question 17 of 20

1

17. How can you tell if a job is disabled in the Oracle Scheduler?

Select one or more of the following:

A. Use the DBA_SCHEDULER view.
B. Use the DBA_SCHEDULER_JOBS view.
C. Use the DBA_JOBS view.
D. All of the above.
E. None of the above.

Explanation

Question 18 of 20

1

18. If a Scheduler job completes and it will run again in the future, what is its STATE setting?

Select one or more of the following:

A. COMPLETE
B. RUNNABLE
C. EDIBLE
D. SCHEDULED

Explanation

Question 19 of 20

1

19. If you create a job using the CREATE_JOB procedure, how many times can it be executed?

Select one or more of the following:

A. Once
B. As many times as it is scheduled
C. Never
D. Twice
E. None of the above

Explanation

Question 20 of 20

1

20. Which query can be used to find the names of Oracle Scheduler metadata views?

Select one or more of the following:

A. SELECT table_name FROM dictionary WHERE table_name LIKE 'DBA%SCHED%';
B. SELECT table_name FROM dictionary WHERE table_name LIKE 'DBA%PLAN%';
C. SELECT table_name FROM dictionary WHERE table_name LIKE 'DBA%JOB%';
D. SELECT table_name FROM dictionary WHERE table_name LIKE 'DBA%RSRC%';

	Created by Jamonero Blanco almost 8 years ago

OCA OCA Quiz on OCA-16-Controlling Resources and Jobs, created by Jamonero Blanco on 30/01/2017.

OCA-16-Controlling Resources and Jobs

Question 1 of 20

1. Which of these is performed by the Resource Manager?

Select one or more of the following:

Explanation

Question 2 of 20

2. Which of these can be controlled by Resource Manager?

Select one or more of the following:

Explanation

Question 3 of 20

3. Which of the following is the most significant and most effective allocation method controlled by the Resource Manager?

Select one or more of the following:

Explanation

Question 4 of 20

4. How can runaway sessions be curtailed and prevented from overwhelming a system? (Choose two.)

Select one or more of the following:

Explanation

Question 5 of 20

5. Which of these is a Resource Manager object?

Select one or more of the following:

Explanation

Question 6 of 20

6. Which of these packages are used to administer the Resource Manager? (Choose two.)

Select one or more of the following:

Explanation

Question 7 of 20

7. A consumer group object can be assigned to which of the following? (Choose two.)

Select one or more of the following:

Explanation

Question 8 of 20

8. If a plan contains two subplans and one consumer group is below the subplan level, and each of the subplans is allocated 45 percent of CPU cycles each, what is the most that can be allocated to the consumer group, assuming that the subplans and plan are fully occupied?

Select one or more of the following:

Explanation

Question 9 of 20

9. Which of these can help prevent parallel processing limits from being exceeded, and help to prevent a database from being swamped by parallel executing queries?

Select one or more of the following:

Explanation

Question 10 of 20

10. How many levels of utilization are there for CPU allocation in the Resource Manager?

Select one or more of the following:

Explanation

Question 11 of 20

11. Which database parameter has an impact on running the Scheduler jobs?

Select one or more of the following:

Explanation

Question 12 of 20

12. Which of these are valid Resource Manager–specific privileges?

Select one or more of the following:

Explanation

Question 13 of 20

13. Which of these are initial default resource consumer groups? (Choose two.)

Select one or more of the following:

Explanation

Question 14 of 20

14. With what types of resources does the CREATE_SIMPLE_PLAN procedure work?

Select one or more of the following:

Explanation

Question 15 of 20

15. How many consumer groups, CPU percentages, and simple plans can the CREATE_SIMPLE_PLAN procedure create?

Select one or more of the following:

Explanation

Question 16 of 20

16. Why does the pending area exist? (Choose the best answer.)

Select one or more of the following:

Explanation

Question 17 of 20

17. How can you tell if a job is disabled in the Oracle Scheduler?

Select one or more of the following:

Explanation

Question 18 of 20

18. If a Scheduler job completes and it will run again in the future, what is its STATE setting?

Select one or more of the following:

Explanation

Question 19 of 20

19. If you create a job using the CREATE_JOB procedure, how many times can it be executed?

Select one or more of the following:

Explanation

Question 20 of 20

20. Which query can be used to find the names of Oracle Scheduler metadata views?

3. Which of the following is the most significant and most effective allocation method
controlled by the Resource Manager?

4. How can runaway sessions be curtailed and prevented from overwhelming a system?
(Choose two.)

8. If a plan contains two subplans and one consumer group is below the subplan level,
and each of the subplans is allocated 45 percent of CPU cycles each, what is the most
that can be allocated to the consumer group, assuming that the subplans and plan are
fully occupied?

9. Which of these can help prevent parallel processing limits from being exceeded, and
help to prevent a database from being swamped by parallel executing queries?

15. How many consumer groups, CPU percentages, and simple plans can the
CREATE_SIMPLE_PLAN procedure create?