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

Provide Filenames for the Control Files

Manage the Size of Control Files

Which files do the following structural changes occur?1) Adding, dropp

1.	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

Discussion

No Comment Found

Related MCQs

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?
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
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?
The SQL*Plus STARTUP command parameters are interpreted by ASM. Which parameter Issues a SHUTDOWN ABORT to the ASM instance before restarting it?
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)
Which errors can be encountered by Troubleshooting after Creating Control Files after issuing the CREATE CONTROLFILE statement?
Which file allows a no default parameter file to be used to configure the Instance?
Which initialization Parameter Specifies the default disk group location to create the following files?1) Redo log files2) Control files
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?
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?

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

Discussion

No Comment Found

Related MCQs

Reply to Comment