1. Backward recovery is which of the following?
a. Where the before-images are applied to the database
b. Where the after-images are applied to the database
c. Where the after-images and before-images are applied to the database
d. Switching to an existing copy of the database
2. Which of the following could cause data to be unavailable?
a. Data becoming lost or inaccurate
b. The database server
c. Planned database maintenance activities
d. All of the above.
3. If both data and database administration exist in an organization, the database administrator is responsible for which of the following?
a. Data modeling
b. Database design
c. Metadata
d. All of the above.
4. Poor data administration can lead to which of the following?
a. single definition of the same data entity
b. Familiarity with existing data
c. Missing data elements
d. All of the above.
5. A traditional data administrator performs which of the following roles?
a. Tune database performance
b. Establish backup and recovery procedures
c. Resolve data ownership issues
d. Protect the security of the database.
6. Failure to control confidentiality may lead to loss of competitiveness.
a. True
b. False
7. Which schema does this window group reside?
a. system
b. sysdba
c. sys
d. Both B and C
8. After creating a job, you may need to set job arguments if-
a. The inline job action is a stored procedure or other executable that requires arguments.
b. The job references a named program object and you want to override one or more default program arguments.
c. The job references a named program object and one or more of the program arguments were not assigned a default value.
d. All mentioned above.
9. In the Scheduler, most components are database objects like a table, which enables you to use normal oracle privileges. Select the correct basic elements of the scheduler.
a. Programs
b. Schedules
c. Events
d. Chains
e. All of the above.
10. The Scheduler can pass an event-based job for the message content of the event that started the job. To pass an event-based job which of the following rules will be applied?
a. The job must use a named program of type STORED_PROCEDURE
b. One of the named program's arguments must be a metadata argument with metadata_attribute set to EVENT_MESSAGE
c. The stored procedure that implements the program must have an argument at the position corresponding to the named program's metadata argument. The argument type must be the data type of the queue where your application queues the job-start event
d. Both A & B
e. All mentioned above
11. Select the correct method for creating jobs.
a. Named Program
b. Named Schedule
c. Named Program and Schedule
d. All mentioned above
12. A chain can become stalled when no steps are running, no steps are scheduled to run, no event steps are waiting for an event, and the evaluation_interval for the chain is NULL.
a. True
b. False
13. Which scenario are the chains automatically disabled by the scheduler?
a. The program that one of the chain steps points to is dropped
b. The nested chain that one of the chain steps points to is dropped
c. The event schedule that one of the chain event steps points to is dropped
d. All mentioned above
14. Which process specifies the maximum number of processes that can be created for the execution of jobs?
a. job_queue_processes
b. dbms_scheduler
c. dbms_scheduler.create_job
d. set_job_anydata_value
15. Which attribute is currently not implemented in the scheduler event queue?
a. run_count
b. failure_count
c. retry_count
d. spare1-spare8
16. In starting the chain at least one rule must have a condition that always evaluates to TRUE.
a. True
b. False
17. Which procedure is used for altering an event based job?
a. set_attribute
b. create_event_schedule
c. create_job
d. create_event_program
18. You can check a job state by issuing which method for the job that was scheduled to run once and complete successfully?
a. Succeeded
b. Retry Scheduled
c. Scheduled
d. Chain_stalled
19. An aborted database shutdown proceeds with which of the following conditions?
a. New connections are allowed, nor are new transactions not allowed to be started, after the statement is issued.
b. Current client SQL statements not being processed by Oracle Database are immediately terminated.
c. Uncommitted transactions are rolled back
d. Oracle Database does wait for users currently connected to the database to Connect. The database implicitly connects all connected users.
e. None of the above
20. Where can we use the Scheduler which provides the complex enterprise scheduling functionality?
a. Schedule job execution based on time or events
b. Schedule job processing in a way that models your business requirements
c. Manage and monitor jobs
d. Execute and manage jobs in a clustered environment
e. All of the above
21. Which of these additional attributes must be set to create an event-based job?
a. queue_spec
b. event_condition
c. Both A & B
d. None of the above
22. Which view shows all chains?
a. *_scheduler_chains
b. *_scheduler_chain_rules
c. *_scheduler_chain_steps
d. None of the above
23. Select the correct object privilege that can only be granted to programs, chains and job classes.
a. EXECUTE
b. ALTER
c. ALL
d. Both A and B
24. Viewing the Quiesce State of an Instance You can query the ACTIVE_STATE column of the V$INSTANCE view to see the current state of an instance, the column values has one of these values?
a. NORMAL
b. QUIESCING
c. QUIESCED
d. All mentioned above
25. Jobs are database objects, and can therefore accumulate and take up too much space. To avoid this, job objects are automatically dropped by default after completion. This behavior is controlled by which job attribute?
a. auto_view
b. auto_drop
c. auto_cancel
d. drop
26. If you create a job without specifying a job class, the job will be assigned to which job class?
a. DEFAULT_JOB_CLASS
b. JOB_CLASS
c. CREATE_JOB_CLASS
d. DROP_JOB_CLASS