Managing Control Files MCQs
Managing Control Files MCQs
Try to answer these Managing Control Files MCQs and check your understanding of the Managing Control Files subject.
Scroll down and let's begin!
1: 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?
A. The timestamp of the database creation
B. None
C. The database name
D. Names and locations of associated datafiles and redo log files
2: You can change the database name and DBID (internal database identifier) using the DBNEWID utility?
A. True
B. False
3: 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
A. Creating Additional Copies, Renaming, and Relocating Control Files
B. Creating New Control Files
C. None
D. Creating Initial Control Files
4:
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?
A.
False
B.
True
5:
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.
A.
Dropping Control Files
B.
Creating Initial Control Files
C.
Creating New Control Files
D.
Creating Additional Copies, Renaming, and Relocating Control Files
6: You Choose Appropriate Tables for the Cluster for which the following conditions are true?
A. The tables are primarily queried--that is, tables that are not predominantly inserted into or updated
B. Records from the tables are frequently queried together or joined
C. 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
D. Records from the tables are not frequently queried together or joined
7: Disk I/O is reduced and access time improves for joins of clustered tables?
A. True
B. False
8:
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)
A.
None
B.
Recovering from Permanent Media Failure Using a Control File Copy
C.
Recovering from Control File Corruption Using a Control File Copy And Recovering from Permanent Media Failure Using a Control File Copy
D.
Recovering from Control File Corruption Using a Control File Copy
List of Managing Control Files...
Available in:
Managing Control Files MCQs
