MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 12 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. |
Data files of which tablespaces can be recovered by performing an open recovery? |
| A. | TEMP |
| B. | INDEX |
| C. | SYSAUX |
| D. | ALL MENTIONED ABOVE |
| Answer» E. | |
| 2. |
Which utility ensure that the CONSTRAINTS and TRIGGERS parameters are set to Y the default? |
| A. | EXP |
| B. | IMP |
| C. | Both A & B |
| D. | None of the above |
| Answer» B. IMP | |
| 3. |
Which of the following is the default permanent tablespace? |
| A. | TEMP |
| B. | UNDOTBS1 |
| C. | USERS |
| D. | None of the above |
| Answer» D. None of the above | |
| 4. |
Identify the common Dynamic Performance views which are accessible in NOMOUNT stage? |
| A. | V$PARAMETER, V$OPTION, V$SGA |
| B. | V$THREAT, V$LOGFILE, V$DATAFILE |
| C. | Both A & B |
| D. | V$CONTROLFILE, V$DATABASE |
| Answer» B. V$THREAT, V$LOGFILE, V$DATAFILE | |
| 5. |
Which view is useful for monitoring the effects of transaction execution on undo space in the current instance in viewing information about undo? |
| A. | V$UNDOSTAT |
| B. | V$ROLLSTAT |
| C. | V$TRANSACTION |
| D. | DBA_UNDO_EXTENTS |
| Answer» B. V$ROLLSTAT | |
| 6. |
Which parameter when not specified then all the database objects are created in the same user schema as in the source database, and those users must already exist in the target database? |
| A. | TRANSPORT_DATAFILES |
| B. | DUMPFILE |
| C. | DIRECTORY |
| D. | REMAP_SCHEMA |
| Answer» E. | |
| 7. |
Which view shows the Name and number of all tablespaces from the control file in Viewing Tablespace Information? |
| A. | DBA_TABLESPACE_GROUPS |
| B. | V$TABLESPACE |
| C. | V$DATAFILE |
| D. | DBA_EXTENDS,USER_EXTENDS |
| Answer» C. V$DATAFILE | |
| 8. |
A transportable tablespace set consists of datafiles for the set of tablespaces being transported and an export file containing structural information (metadata) for the set of tablespaces we use ______ |
| A. | Data Pump |
| B. | EXP |
| C. | IMP |
| D. | Both A & B |
| Answer» E. | |
| 9. |
What migrates a locally managed tablespace to dictionary-managed in Diagnosing and Repairing Locally Managed Tablespace Problems? |
| A. | TABLESPACE_MIGRATE_TO_LOCAL |
| B. | TABLESPACE_REBUILD_QUOTAS |
| C. | TABLESPACE_MIGRATE_FROM_LOCAL |
| D. | TABLESPACE_VERIFY |
| Answer» B. TABLESPACE_REBUILD_QUOTAS | |
| 10. |
Which SQL statement from the following is used to create a new tablespace? |
| A. | CREATE TABLESPACE |
| B. | CREATE TEMPORARY TABLESPACE |
| C. | CREATE UNDO TABLESPACE |
| D. | Both A & B |
| Answer» E. | |
| 11. |
Which tasks call the procedure, either on all bitmap blocks, or on a single block if only one is corrupt in a set of bitmap blocks that has media corruption? |
| A. | TABLESPACE_REBUILD_QUOTAS |
| B. | TABLESPACE_REBUILD_BITMAPS |
| C. | TABLESPACE_VERIFY |
| D. | None of the above |
| Answer» C. TABLESPACE_VERIFY | |
| 12. |
In Viewing Tablespace Information, which view gives Information for all extents in all locally managed temporary tablespaces? |
| A. | V$TEMP_EXTENT_POOL |
| B. | V$TEMP_EXTENT_MAP |
| C. | V$TEMPSEG_USAGE |
| D. | V$TEMP_SPACE_HEADER |
| Answer» C. V$TEMPSEG_USAGE | |