a2zinterviews

37.	What happens when a user requests for some information from RDBMS?
	The following steps are performed when a user requests for some information. RDBMS checks if a copy of the parsed SQL statement exists in the library cache. If parsed copy exists, the steps 2 to 6 are skipped. RDBMS validates the syntax of the statement. RDBMS ensures that all the columns and tables referenced in the statement exist. RDBMS acquires parse locks on objects referenced in the statement so that their definitions do not change while statement is parsed. RDBMS ensures that the user has sufficient privileges. Statement is parsed and execution plan is created. Statement is executed. Vales are fetched.
	Discuss Your Name Your Email-ID Your Answer

38.	Suppose some blocks are damaged in a datafile. Can you recover these blocks if you are using RMAN?
	Yes, the damaged blocks can be recovered.
	Discuss Your Name Your Email-ID Your Answer

39.	Can you take partial backups if the database is running in the NOARCHIEVELOG mode?
	In this case, partial backup is possible; however, they are not useful.
	Discuss Your Name Your Email-ID Your Answer

40.	How do you recover from the loss of datafile if the database is running in the NOARCHIVELOG mode?
	The datafile can be recovered from the cold backup. However, it cannot be recovered to the point of failure.
	Discuss Your Name Your Email-ID Your Answer