Sunday 8 February 2015

Operating Systems | Memory Management Questions and Answers

Below are some important Memory Management interview questions which are asked in most MNC company interviews for beginners or professionals.

41. What is cold backup? What are the elements of it?
Cold backup is taking backup of all physical files after normal shutdown of database. We need to take.
- All Data files.
- All Control files.
- All on-line redo log files.
- The init.ora file (Optional)

42. What is a logical backup?
Logical backup involves reading a set of database records and writing them into a file. Export utility is used for taking backup and Import utility is used to recover from backup.

43. What is hot backup and how it can be taken?
Taking backup of archive log files when database is open. For this the ARCHIVELOG mode should be enabled. The following files need to be backed up. All data files. All Archive log, redo log files. All control files.

44. What is the use of FILE option in EXP command?
To give the export file name.

45. What is the use of GRANT option in EXP command?
A flag to indicate whether grants on databse objects will be exported or not. Value is 'Y' or 'N'.

46. What is the use of INDEXES option in EXP command?
A flag to indicate whether indexes on tables will be exported.

47. What is the use of ROWS option in EXP command?
Flag to indicate whether table rows should be exported. If 'N' only DDL statements for the database objects will be created.

48. What is the use of PARFILE option in EXP command?
Name of the parameter file to be passed for export.

49. What is the use of ANALYSE ( Ver 7) option in EXP command?
A flag to indicate whether statistical information about the exported objects should be written to export dump file.

50. What is the use of FULL option in EXP command?
A flag to indicate whether full databse export should be performed.
More Questions & Answers :-
Part1  Part2  Part3  Part4  Part5  Part6

No comments:

Post a Comment