MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 10 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. |
The value of which is the minimum size of the increments added to the file when it extends? |
| A. | MAXSIZE |
| B. | NEXT |
| C. | BOTH A & B |
| D. | NONE OF THE ABOVE |
| Answer» C. BOTH A & B | |
| 2. |
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 |
| Answer» E. | |
| 3. |
Your database is running in the ARCHIVELOG mode. You placed a tablespace tbs_1, offline with the immediate option. Which statement is correct in this scenario? |
| A. | The operation would fail if tbs_1 were a read-only tablespace |
| B. | The operation would fail if tbs_1 were a read/write tablespace |
| C. | The operation would fail if tbs_1 were the default tablespace for the database |
| D. | If the above operation were successful, media recovery would be required to bring the Tablespace online |
| Answer» E. | |
| 4. |
You executed the STARTUP MOUNT command to start your database, for which database Operation do you need to start the database in the MOUNT state? |
| A. | Renaming the control files |
| B. | Dropping a user in your database |
| C. | Enabling or disabling redo log archiving |
| D. | Dropping a tablespace in your database |
| Answer» D. Dropping a tablespace in your database | |
| 5. |
The DROP DATABASE statement deletes all control files and all other database files listed in the control file, to use the DROP DATABASE statement successfully, which conditions must apply? |
| A. | The database must be mounted and closed |
| B. | The database must be mounted exclusively--not in shared mode |
| C. | The database must be mounted as RESTRICTED |
| D. | All mentioned above |
| Answer» E. | |
| 6. |
What are the implications if your test database is running in a NOARCHIVELOG mode? |
| A. | You can perform open database backups |
| B. | You can perform closed database backups |
| C. | You cannot perform schema-level logical backups |
| D. | You can perform the backup of only the SYSTEM tablespace when the database is open |
| Answer» C. You cannot perform schema-level logical backups | |
| 7. |
Which SQL Statement creates a new empty datafile in place of an old one-useful to re-create a datafile that was lost with no backup? |
| A. | ALTER DATABASE...CREATE DATAFILE |
| B. | CREATE DATABASE |
| C. | ALTER TABLESPACE...ADD TEMPFILE |
| D. | CREATE TEMPORARY TABLESPACE |
| Answer» B. CREATE DATABASE | |
| 8. |
In mapping structure what describes the link between an element and the next elements in the I/O mapping stack? |
| A. | File Mapping |
| B. | Subelements Mapping |
| C. | Elements Mapping |
| D. | File System Extents Mapping |
| Answer» C. Elements Mapping | |
| 9. |
What is used by Oracle during Table and Index creation and for sorting? |
| A. | Tables |
| B. | Indexes |
| C. | Temporary Segments |
| D. | Schemas |
| Answer» D. Schemas | |
| 10. |
Which statement we used for manually increasing or decreasing the size of a datafile? |
| A. | ALTER DATABASE |
| B. | ALTER TABLESPACE |
| C. | CREATE DATABASE |
| D. | CREATE TABLESPACE |
| Answer» B. ALTER TABLESPACE | |