InterviewSolution

Explore topic-wise InterviewSolutions in .

This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.

51.	ARIES supports ___________ operations, which are physical in that the affected page is physically identified, but can be logical within the page.(a) Physiological redo(b) Physiological undo(c) Logical redo(d) Logical undoI have been asked this question in homework.My doubt stems from ARIES topic in portion Recovery System of Database Management
Answer» RIGHT answer is (a) Physiological redo Explanation: The DELETION of a record from a PAGE may result in MANY other records in the page being shifted, if a slotted page structure is USED.

52.	ARIES uses a ___________ to identify log records, and stores it in database pages.(a) Log sequence number(b) Log number(c) Lock number(d) SequenceThis question was addressed to me during an online exam.The question is from ARIES topic in section Recovery System of Database Management
Answer» The CORRECT answer is (B) Log number The BEST I can EXPLAIN: LSN is USED to identify which operations have been applied to a database page.

53.	Writing the buffered log to __________ is sometimes referred to as a log force.(a) Memory(b) Backup(c) Redo memory(d) DiskThe question was posed to me during an online interview.My query is from Buffer Management topic in chapter Recovery System of Database Management
Answer» Correct option is (d) Disk The explanation is: If there are INSUFFICIENT LOG records to fill the BLOCK, all log records in main memory are combined into a partially FULL block and are output to stable storage.

54.	The log is a sequence of _________ recording all the update activities in the database.(a) Log records(b) Records(c) Entries(d) RedoI had been asked this question in an internship interview.I would like to ask this question from Recovery in chapter Recovery System of Database Management
Answer» CORRECT CHOICE is (a) LOG records For explanation: The most widely used STRUCTURE for recording database modifications is the log.

55.	________ dump, writes out SQL DDL statements and SQL insert statements to a file, which can then be reexecuted to re-create the database.(a) Archival(b) Fuzzy(c) SQL(d) All of the mentionedI have been asked this question by my college director while I was bunking the class.This intriguing question originated from Failure with Nonvolatile Storage in chapter Recovery System of Database Management
Answer» RIGHT answer is (c) SQL To EXPLAIN: Such DUMPS are useful when migrating data to a different instance of the database, or to a different version of the database software, SINCE the physical locations and layout MAY be different in the other database instance or database software version.

56.	What was the name of the first commercially available microprocessor chip?(a) Intel 308(b) Intel 33(c) Intel 4004(d) Motorola 639I had been asked this question during an online interview.Query is from Failure with Nonvolatile Storage in division Recovery System of Database Management
Answer» Correct option is (c) INTEL 4004 For explanation: The Intel 4004 is a 4-bit central PROCESSING unit (CPU) released by Intel CORPORATION in 1971

57.	Redo operations are performed exclusively using(a) Logical logging(b) Physical logging(c) Physical log records(d) Both Physical logging and Physical log recordsThis question was posed to me in an interview for internship.My question is based upon Lock Release and Undo Operations topic in portion Recovery System of Database Management
Answer» Right choice is (d) Both Physical LOGGING and Physical LOG records Easiest EXPLANATION - Logging of old-value and new-value information is CALLED physical logging.

58.	__________ starts from a position determined during analysis, and performs a redo, repeating history, to bring the database to a state it was in before the crash.(a) Analysis pass(b) Redo pass(c) Undo pass(d) None of the mentionedThe question was asked in an interview.The question is from ARIES in portion Recovery System of Database Management
Answer» The CORRECT answer is (b) Redo pass Best explanation: The redo pass repeats history by replaying every ACTION that is not ALREADY reflected in the page on DISK.

59.	Which of the following is used for manufacturing chips?(a) Control bus(b) Control unit(c) Parity unit(d) SemiconductorI had been asked this question in examination.I need to ask this question from Failure with Nonvolatile Storage in section Recovery System of Database Management
Answer» RIGHT CHOICE is (d) SEMICONDUCTOR The explanation is: A semiconductor is a material which has electrical conductivity between that of a CONDUCTOR such as copper and that of an insulator such as glass.

60.	The current copy of the database is identified by a pointer, called ____________ which is stored on disk.(a) Db-pointer(b) Update log(c) Update log records(d) All of the mentionedI had been asked this question in unit test.I would like to ask this question from Recovery in chapter Recovery System of Database Management
Answer» The CORRECT answer is (a) Db-pointer To explain: Any page which is not updated by a TRANSACTION is not copied, but INSTEAD the new page table just STORES a pointer to the ORIGINAL page.

61.	The time to process the remote backup can be reduced by(a) Flags(b) Breakpoints(c) Redo points(d) CheckpointsI got this question during an interview for a job.My question is from Remote Backup Systems topic in portion Recovery System of Database Management
Answer» Correct CHOICE is (d) Checkpoints Explanation: If the log at the remote backup grows large, recovery will take a LONG time. The remote backup site can periodically PROCESS the redo log records that it has received and can perform a checkpoint, so that earlier parts of the log can be DELETED.

62.	______________ is used to minimize unnecessary redos during recovery.(a) Dirty page table(b) Page table(c) Dirty redo(d) All of the mentionedThis question was addressed to me in examination.This interesting question is from ARIES topic in chapter Recovery System of Database Management
Answer» The correct OPTION is (a) Dirty page table The best EXPLANATION: Dirty PAGES are those that have been updated in memory, and the disk VERSION is not up-to-date.