MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 8 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. |
Which processes is an instance made of? |
| A. | Oracle background processes |
| B. | Memory processes |
| C. | Data processes |
| D. | All of the above |
| Answer» B. Memory processes | |
| 2. |
Where is the data dictionary kept? |
| A. | SYSTEM tablespace |
| B. | Stack Space |
| C. | Data file |
| D. | None of the above |
| Answer» B. Stack Space | |
| 3. |
A _______________ is used to logically group data together. |
| A. | Database |
| B. | Tablespace |
| C. | Datafiles |
| D. | Object |
| Answer» C. Datafiles | |
| 4. |
Which of the following is the most probable use of an extent? |
| A. | Stores user data within the database |
| B. | Stores rollback information used when data must be rolled back |
| C. | Minimize the amount of wasted (empty) storage |
| D. | Both a and c |
| Answer» D. Both a and c | |
| 5. |
How many layers does the Oracle database have? |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4 |
| Answer» C. 3 | |
| 6. |
Which of the following are types of segments? |
| A. | Permanent segment |
| B. | Object segment |
| C. | Data Segment |
| D. | All of the above |
| Answer» D. All of the above | |
| 7. |
Which of the following components comprise of an oracle architecture? |
| A. | Database related background processes |
| B. | Tablespaces |
| C. | Datafiles |
| D. | All of the above |
| Answer» E. | |
| 8. |
Which area of PGA stores binding variables and runtime buffers information? |
| A. | SQL area |
| B. | Private SQL area |
| C. | Stack space |
| D. | Session area |
| Answer» C. Stack space | |