Oracle Database Breakdowns

887 Words4 Pages
Q.24: Explain various types of Oracle database backups? Ans: The most vital backup is the physical backup. These backups are performed cold or hot, optionally. For taking a cold backup, the DBA has to shut down the Oracle database. Then, operating system copy commands are used to copy the data files of database. Destination of backup is specified by the DBA. In order to take hot backup, RMAN is known as the best performer. Ram can also take cold backup. Q.25: What is the most important requirement in order to use RMAN to make consistent hot backups? Ans: RMAN stands for “Recovery Manager”. It is a recovery manager and backup that is supplied by the Oracle Corporation for Oracle databases. RMAN offers its services to take database backup, recovery,…show more content…
Ans: PMON stands for “Process Monitor”. It is a background process created by Oracle at the start of a database instance. PMON process releases resources when a user process face failure. PMON perform housekeeping jobs after every three seconds. Q.29: What is the use of temporary tablespaces? Ans: Temporary tablespaces work for specific processes like SQL hash joins and table data sorting. In SQL, if data size is large and comprise upon millions of returned rows, then the temporary memory of computer (RAM) becomes insufficient. As a result, the sort job takes place on disk by using temporary tablespaces. Q.30: Briefly explain the importance of temporary tablespace? Ans: In Oracle, a database always has one temporary tablespace which is formed at the time of database creation. A DBA creates, manages, and drops tablespaces with commands like:  CREATE TEMPORARY TABLESPACE  ALTER TEMPORARY TABLESPACE  DROP TEMPORARY TABLESPACE Q.31: Which data dictionary views are used for…show more content…
It breaks down SQL statements into various rows. Q.35: How will you define control file in ORACLE database? Ans: A control file is present in every Oracle database. Essentially, a control file acts as a container as it is a small sized binary file that keep record of the physical configuration of the ORACLE database. Q.33: What information are recorded in a control file of ORACLE database? Ans: A control file records the name of database, online redo log files, locations and names of datafiles associated with it, the sequence number of current log, the timestamp on which the database was created, and the information of checkpoint. Q.34: What is the importance of control file for Oracle database server? Ans: The control file is important for Oracle database server; it must be available whenever the database is opened for writing. If control file is not available, the Oracle database can’t be mounted and recovery would create issues. Q.35: What is the best method to keep the backup of control
Open Document