Oracle_test

A modern and abstract tech-themed illustration representing Oracle Database management and administration with a futuristic style.

Oracle Database Proficiency Quiz

Test your knowledge and expertise in Oracle Database management with this comprehensive quiz. Designed for Database Administrators, the quiz covers key concepts from resource evaluation to automatic storage management.

10 multiple choice questions
Grade your understanding of Oracle Database features
Suitable for professionals seeking certification or self-assessment

10 Questions2 MinutesCreated by AdministerDatabase42

Q-1. In Database Administrator evaluate how Oracle Database and its applications can best use the available computer resources; this evaluation should reveal which of the following information?

A. How many disk drives are available to the Oracle Products?

B. How many, if any, dedicated tape drives are available to Oracle products

C. How much memory is available to the instances of Oracle Database you will run

D. All mentioned above

Q-4. For maximum distribution of rows in a hash cluster, the database rounds the HASHKEYS value up to the nearest _________ .

A. Prime Number

B. ODD Number

C. Null

D. None of the above

Q-5. In your Automatic Storage Management (ASM) instance, one of the nonempty disk groups, DGROUP1, is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective. DROP DISKGROUP dgroup1 EXCLUDING CONTENTS; What would be the result of this command?

A. This command would result in an error because the disk group is not empty

B. The command would drop the disk group, ignoring the EXCLUDING CONTENTS option

C. The command would result in the disk group being marked as INVALID because it cannot be dropped

D. The command would result in the contents being moved to the parent disk group and dropping of the disk group

Q-6. Which view in an ASM instance contains one row for every ASM file in every disk group mounted by the ASM instance in a DB instance that contains no rows?

A. V$ASM_FILE

B. V$ASM_DISK

C. V$ASM_DISK_STAT

D. V$ASM_DISKGROUP_STAT

Q-7. Which DBMS_STORAGE_MAP package procedure enables you to build the mapping information for the database object identified by object name, owner, and type?

A. MAP_ELEMENT

B. MAP_FILE

C. MAP_ALL

D. MAP_OBJECT

Q-8.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

Q-9. 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

Q-10. Which procedure is used for altering an event based job?

A. set_attribute

B. create_event_schedule

C. create_job

D. create_event_program

Oracle_test

Oracle Database Proficiency Quiz

More Quizzes