MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 39 Mcqs, each offering curated multiple-choice questions to sharpen your Oracle (MCQ) questions and answers knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
In defining Application Services for Oracle Database 10g which Services describe applications, application functions, and data ranges as either functional services or data-dependent services? |
| A. | Configuring Services |
| B. | Deploying Services |
| C. | Using Services |
| D. | All mentioned above |
| Answer» B. Deploying Services | |
| 2. |
In viewing information about the SGA which view Displays information about the amount of SGA memory available for future dynamic SGA resize operations? |
| A. | V$SGA_DYNAMIC_COMPONENTS |
| B. | V$SGA_DYNAMIC_FREE_MEMORY |
| C. | V$SGASTAT |
| D. | V$SGAINFO |
| Answer» C. V$SGASTAT | |
| 3. |
Which is the correct parameter used for CREATE_PROGRAM? |
| A. | program_type |
| B. | schedule_name |
| C. | start_date |
| D. | program_name |
| Answer» B. schedule_name | |
| 4. |
What is used to execute STARTUP and SHUTDOWN commands while starting up a database? |
| A. | SQL*Plus |
| B. | Recovery Manager |
| C. | Enterprise Manager |
| D. | None of the above |
| Answer» C. Enterprise Manager | |
| 5. |
Which attribute enables you to control the amount of logging in the Scheduler performs for setting the scheduler attribute? |
| A. | Default_timezone |
| B. | Log_history |
| C. | Max_job_slave_processes |
| D. | Event_expiry_time |
| Answer» C. Max_job_slave_processes | |
| 6. |
In the platform-specific default location, Oracle Database locates your initialization parameter file by examining filenames in which of the following order? |
| A. | spfile$ORACLE_SID.ora, init$ORACLE_SID.ora, spfile.ora |
| B. | spfile.ora, spfile$ORACLE_SID.ora, init$ORACLE_SID.ora |
| C. | spfile$ORACLE_SID.ora, spfile.ora, init$ORACLE_SID.ora |
| D. | Intit$ORACLE_SID.ora, spfile.ora, spfile$ORACLE_SID.ora |
| Answer» D. Intit$ORACLE_SID.ora, spfile.ora, spfile$ORACLE_SID.ora | |
| 7. |
What kind of an eventis raised when the Scheduler reacts to the event by starting a job and you can even create a schedule that references an event instead of containing date, time, and recurrence information? |
| A. | Event raised by the scheduler |
| B. | Event raised by an application |
| C. | Both A & B |
| D. | None of the above |
| Answer» C. Both A & B | |
| 8. |
Based on the existing program which way is used to CREATE_JOB?BEGINDBMS_SCHEDULER.CREATE_JOB (job_name => 'my_new_job3',program_name => 'my_saved_program1',schedule_name => 'my_saved_schedule1');END; |
| A. | Named Program |
| B. | Named Schedule |
| C. | Named Program and Schedule |
| D. | All mentioned above |
| Answer» D. All mentioned above | |
| 9. |
When a job is picked for processing, select the correct order in which job executes.1. Starts a database session as the owner of the job, starts a transaction, and then starts executing the job.2. Gathers all the metadata needed to run the job. As an example, arguments of the program and privilege information.3. Once the job is complete, the slave commits and ends the transaction.4. Closes the session |
| A. | 1, 2, 3, 4 |
| B. | 2, 1, 3, 4 |
| C. | 2, 3, 1, 4 |
| D. | 1, 3, 2, 4 |
| Answer» C. 2, 3, 1, 4 | |
| 10. |
Which is the location of the Oracle Database that can store and manage files related to backup and recovery? |
| A. | Flash Recovery Area |
| B. | Managing the System Global Area (SGA) |
| C. | Both A & B |
| D. | None of the above |
| Answer» B. Managing the System Global Area (SGA) | |
| 11. |
In controlling the job logging, which class is used for the scheduler to write detailed information to the job log for all runs of each job in this class? |
| A. | DBMS_SCHEDULER.LOGGING_RUNS |
| B. | DBMS_SCHEDULER.LOGGING_FULL |
| C. | DBMS_SCHEDULER.LOGGING_OFF |
| D. | None of the above |
| Answer» B. DBMS_SCHEDULER.LOGGING_FULL | |
| 12. |
Which privilege is required to alter a job class? |
| A. | MANAGE SCHEDULER |
| B. | SYSTEM PRIVILEGE |
| C. | ALTER ANY CLUSTER |
| D. | SELECT |
| Answer» B. SYSTEM PRIVILEGE | |
| 13. |
Which initialization parameter is a dynamic parameter that lets you specify or adjust the size of the large pool component of the SGA? |
| A. | STREAMS_POOL_SIZE |
| B. | JAVA_POOL_SIZE |
| C. | LARGE_POOL_SIZE |
| D. | SHARED_POOL_SIZE |
| Answer» D. SHARED_POOL_SIZE | |
| 14. |
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 |
| Answer» E. | |
| 15. |
Which view shows completed window runs in viewing the scheduler information? |
| A. | *_scheduler_windows |
| B. | *_scheduler_window_log |
| C. | *_scheduler_window_details |
| D. | *_scheduler_window_groups |
| Answer» D. *_scheduler_window_groups | |
| 16. |
Which view shows that all the jobs or both enabled and disabled? |
| A. | *_SCHEDULER_JOBS |
| B. | *_SCHEDULER_JOB_ROLES |
| C. | *_SCHEDULER_PROGRAMS |
| D. | *_SCHEDULER_JOB_RUN_DETAILS |
| Answer» B. *_SCHEDULER_JOB_ROLES | |
| 17. |
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 |
| Answer» B. JOB_CLASS | |
| 18. |
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 |
| Answer» C. auto_cancel | |
| 19. |
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 |
| Answer» B. ALTER | |
| 20. |
Which view shows all chains? |
| A. | *_scheduler_chains |
| B. | *_scheduler_chain_rules |
| C. | *_scheduler_chain_steps |
| D. | None of the above |
| Answer» B. *_scheduler_chain_rules | |
| 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 |
| Answer» D. None of the above | |
| 22. |
Which mode is used for Shutting down a Database using these following situations?1) To initiate an automated and unattended backup.2) When a power shutdown is going to occur soon.3) When the database or one of its applications is functioning irregularly and you cannot contact users to ask them to log off or they are unable to log off. |
| A. | Shutting Down with the NORMAL Clause |
| B. | Shutting Down with the IMMEDIATE Clause |
| C. | Shutting Down with the TRANSACTIONAL Clause |
| D. | Shutting Down with the ABORT Clause |
| Answer» C. Shutting Down with the TRANSACTIONAL Clause | |
| 23. |
Which of the following ways can we use to create an Oracle Database? |
| A. | The Database Configuration Assistant |
| B. | The CREATE DATABASE statement |
| C. | Upgrade an existing database |
| D. | All mentioned above |
| Answer» E. | |
| 24. |
After creating the chain object with CREATE_CHAIN, you define chain steps and chain rules separately. What is the correct argument which is set to NULL? |
| A. | Evaluation_interval |
| B. | Define_chain_step |
| C. | Define_chain_event |
| D. | Schedules |
| Answer» B. Define_chain_step | |
| 25. |
Which sub clause is specified for the UNDO TABLESPACE clause in Specifying Oracle-Managed Files at Database creation? |
| A. | No LOGFILE |
| B. | No SYSAUX DATAFILE |
| C. | No DATAFILE |
| D. | No TEMPFILE |
| Answer» D. No TEMPFILE | |
| 26. |
What should a database do to start an instance and it should read the instance configuration parameters (the initialization parameters)? |
| A. | SPFILE |
| B. | PFILE |
| C. | Both A & B |
| D. | None of the above |
| Answer» D. None of the above | |
| 27. |
Using oracle scheduler you have scheduled two jobs, JOB_A and JOB_B, to run at 9:00 p.m. every friday. You want both the jobs to use a single resource plan, weekend_plan. Which task must have already been performed to enable you to achieve this objective? |
| A. | A window must have been created with the WEEKEND_PLAN resource plan |
| B. | A program must have been created with the WEEKEND_PLAN resource plan |
| C. | A job class must have been created with the WEEKEND_PLAN resource plan |
| D. | A window group must have been created with the WEEKEND_PLAN resource plan |
| Answer» B. A program must have been created with the WEEKEND_PLAN resource plan | |
| 28. |
Which task does the SET_ATTRIBUTE procedure come under the Job tasks and their procedures? |
| A. | Create a job |
| B. | Alter a job |
| C. | Run a job |
| D. | Disable a job |
| Answer» C. Run a job | |
| 29. |
A job must be part of exactly one class. When you create a job, you can specify which class the job is part of. If you do not specify a class, the job will automatically become part of which class? |
| A. | default_job_class |
| B. | job_class |
| C. | job_over_max_dur |
| D. | Both A and B |
| Answer» B. job_class | |
| 30. |
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 |
| Answer» B. Retry Scheduled | |
| 31. |
Which procedure is used for altering an event based job? |
| A. | set_attribute |
| B. | create_event_schedule |
| C. | create_job |
| D. | create_event_program |
| Answer» B. create_event_schedule | |
| 32. |
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. |
| Answer» E. | |
| 33. |
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 |
| Answer» B. dbms_scheduler | |
| 34. |
Which attribute is currently not implemented in the scheduler event queue? |
| A. | run_count |
| B. | failure_count |
| C. | retry_count |
| D. | spare1-spare8 |
| Answer» E. | |
| 35. |
Abbreviate the term DBCA? |
| A. | Database Control Assistant |
| B. | Database Configuration Application |
| C. | Database Control Application |
| D. | Database Configuration Assistant |
| Answer» E. | |
| 36. |
If you want the user APP_DBA to administer the oracle database from a remote machine .APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA? |
| A. | Control file |
| B. | Password file |
| C. | Listener controller file |
| D. | Control file and password file |
| Answer» C. Listener controller file | |
| 37. |
Which 'view' contains database related information from the control file? |
| A. | V$DATABASE |
| B. | DATABASE_PROPERTIES |
| C. | GLOBAL_NAME |
| D. | None of the above |
| Answer» B. DATABASE_PROPERTIES | |
| 38. |
___________ privilege can only be granted for programs, chains, and job classes. It enables you to create a job that runs with the program, chain, or job class. It also enables you to view object attributes |
| A. | Alter |
| B. | All |
| C. | Execute |
| D. | None of the above |
| Answer» D. None of the above | |
| 39. |
You can run the job synchronously with RUN_JOB by setting which of the following argument. |
| A. | use_current_session=true |
| B. | use_current_session=flase |
| C. | Both A and B can be set |
| D. | failure_count=true |
| Answer» B. use_current_session=flase | |