MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 14 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 your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance? |
| A. | Oracle Migration Assistant |
| B. | Recovery Manager (RMAN) |
| C. | Oracle Data Pump Export and Import |
| D. | Conventional Oracle Export and Import |
| Answer» B. Recovery Manager (RMAN) | |
| 2. |
What are the following steps used to do?1) Make a list of all datafiles and redo log files of the database2) Back up all datafiles and redo log files of the database3) Start up a new instance, but do not mount or open the database |
| A. | Creating Initial Control Files |
| B. | Creating Additional Copies, Renaming, and Relocating Control Files |
| C. | Creating New Control Files |
| D. | Both A & B |
| Answer» D. Both A & B | |
| 3. |
You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. You have two disk groups, DG1 and DG2, with one device each. In the parameter file of the production database, the following parameters have been specifiedDB_CREATE_ONLINE_LOG_DEST_1 = '+dg1'DB_CREATE_ONLINE_LOG_DEST_2 = '+dg2'What would be the impact of this setting? |
| A. | When a new log group is added, it would have one member in each disk group |
| B. | When a new log group is added, it would have two members in each disk group |
| C. | When a new tablespace is added, it would have one data file in each disk group |
| D. | When a new log file is added, it would have one member spread across the disk groups |
| Answer» B. When a new log group is added, it would have two members in each disk group | |
| 4. |
The SQL*Plus STARTUP command parameters are interpreted by ASM. Which parameter Issues a SHUTDOWN ABORT to the ASM instance before restarting it? |
| A. | MOUNT |
| B. | NOMOUNT |
| C. | FORCE |
| D. | MOUNT, OPEN |
| Answer» D. MOUNT, OPEN | |
| 5. |
Which way can you recover a control File using a current copy from the following,Edit the CONTROL_FILES parameter in the initialization parameter file to replace the bad location with the new location?CONTROL_FILES = (/u01/oracle/prod/control01.ctl,/u02/oracle/prod/control02.ctl,/u04/oracle/prod/control03.ctl) |
| A. | Recovering from Permanent Media Failure Using a Control File Copy |
| B. | Recovering from Control File Corruption Using a Control File Copy |
| C. | Both A & B |
| D. | None of the above |
| Answer» B. Recovering from Control File Corruption Using a Control File Copy | |
| 6. |
Which errors can be encountered by Troubleshooting after Creating Control Files after issuing the CREATE CONTROLFILE statement? |
| A. | Checking for Missing or Extra Files |
| B. | Handling Errors During CREATE CONTROLFILE |
| C. | Both A & B |
| D. | None of the above |
| Answer» D. None of the above | |
| 7. |
Which file allows a no default parameter file to be used to configure the Instance? |
| A. | SPFILE |
| B. | PFILE |
| C. | Both A & B |
| D. | None of the above |
| Answer» C. Both A & B | |
| 8. |
Which initialization Parameter Specifies the default disk group location to create the following files?1) Redo log files2) Control files |
| A. | DB_CREATE_ONLINE_LOG_DEST_n |
| B. | DB_CREATE_FILE_DEST |
| C. | DB_RECOVERY_FILE_DEST |
| D. | CONTROL_FILES |
| Answer» B. DB_CREATE_FILE_DEST | |
| 9. |
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 |
| Answer» B. V$ASM_DISK | |
| 10. |
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 |
| Answer» B. The command would drop the disk group, ignoring the EXCLUDING CONTENTS option | |
| 11. |
Which files do the following structural changes occur?1) Adding, dropping or renaming datafiles2) Adding or dropping a tablespace, or altering the read / write state of the tablespace3) Adding or dropping redo log files or groups |
| A. | Manage the Size of Control Files |
| B. | Back up Control Files |
| C. | Provide Filenames for the Control Files |
| D. | All Mentioned above |
| Answer» C. Provide Filenames for the Control Files | |
| 12. |
What is the following step used for?1) Edit the CONTROL_FILES parameter in the database initialization parameter file to delete the old control file name. |
| A. | Creating Initial Control Files |
| B. | Creating Additional Copies, Renaming, and Relocating Control Files |
| C. | Creating New Control Files |
| D. | Dropping Control Files |
| Answer» E. | |
| 13. |
Which Shutdown Mode in the ASM instance immediately shuts down without the orderly dismount of disk groups? |
| A. | ABORT |
| B. | NORMAL |
| C. | IMMEDIATE |
| D. | TRANSACTIONAL |
| Answer» B. NORMAL | |
| 14. |
In Displaying Control File Information which view lists the names of control files? |
| A. | V$DATABASE |
| B. | V$PARAMETER |
| C. | V$CONTROLFILE |
| D. | V$CONTROLFILE_RECORD_SECTION |
| Answer» D. V$CONTROLFILE_RECORD_SECTION | |