> > Oracle MCQs > Managing Control Files MCQs

Managing Control Files MCQ

In which way you can recover a control File using a current copy by using 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)

None

Recovering from Permanent Media Failure Using a Control File Copy

Recovering from Control File Corruption Using a Control File Copy And Recovering from Permanent Media Failure Using a Control File Copy

Recovering from Control File Corruption Using a Control File Copy

Answer

Correct Answer:

Recovering from Permanent Media Failure Using a Control File Copy

Note: This Question is unanswered, help us to find answer for this one

Disk I/O is reduced and access time improves for joins of clustered tables?

True

False

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

You Choose Appropriate Tables for the Cluster for which the following conditions are true?

The tables are primarily queried--that is, tables that are not predominantly inserted into or updated

Records from the tables are frequently queried together or joined

The tables are primarily queried--that is, tables that are not predominantly inserted into or updated And Records from the tables are frequently queried together or joined

Records from the tables are not frequently queried together or joined

Answer

Correct Answer: The tables are primarily queried--that is, tables that are not predominantly inserted into or updated And Records from the tables are frequently queried together or joined

Note: This Question is unanswered, help us to find answer for this one

The following step is used in?

1) Edit the CONTROL_FILES parameter in the database initialization parameter file to delete the old control file name.

Dropping Control Files

Creating Initial Control Files

Creating New Control Files

Creating Additional Copies, Renaming, and Relocating Control Files

Answer

Correct Answer:

Dropping Control Files

Note: This Question is unanswered, help us to find answer for this one

Troubleshooting after Creating Control Files after issuing the CREATE CONTROLFILE statement, you may encounter which of these errors?

Checking for Missing or Extra Files And Handling Errors During CREATE CONTROLFILE
Handling Errors During CREATE CONTROLFILE
None
Checking for Missing or Extra Files

Oracle strongly recommends that your database has a minimum of four control files and that they are located on separate physical disks?

False

True

Answer

Correct Answer:

False

Note: This Question is unanswered, help us to find answer for this one

The following steps are used to? 1) Make a list of all datafiles and redo log files of the database 2) Back up all datafiles and redo log files of the database 3) Start up a new instance, but do not mount or open the database

Creating Additional Copies, Renaming, and Relocating Control Files

Creating New Control Files

None

Creating Initial Control Files

Answer

Correct Answer: Creating New Control Files

Note: This Question is unanswered, help us to find answer for this one

You can change the database name and DBID (internal database identifier) using the DBNEWID utility?

True

False

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

Every Oracle Database has a control file, which is a small binary file that records the physical structure of the database; the control file does not include?

The timestamp of the database creation

None

The database name

Names and locations of associated datafiles and redo log files

Answer

Correct Answer: None

Note: This Question is unanswered, help us to find answer for this one

Managing Control Files MCQ

Disk I/O is reduced and access time improves for joins of clustered tables?

You Choose Appropriate Tables for the Cluster for which the following conditions are true?

The following step is used in?1) Edit the CONTROL_FILES parameter in the database initialization parameter file to delete the old control file name.

The following steps are used to? 1) Make a list of all datafiles and redo log files of the database 2) Back up all datafiles and redo log files of the database 3) Start up a new instance, but do not mount or open the database

You can change the database name and DBID (internal database identifier) using the DBNEWID utility?

Every Oracle Database has a control file, which is a small binary file that records the physical structure of the database; the control file does not include?

The following step is used in?

1) Edit the CONTROL_FILES parameter in the database initialization parameter file to delete the old control file name.