3i Infotech Papers: Sample Questions 809 - 810 of 1245

Examrace Placement Series prepares you for the toughest placement exams to top companies.

Question number: 809

» Database » Oracle

True-False▾

Question

Is the Following Statement True or False?

NOARCHIEVELOG parameter is used to enable the database in Archive mode

Answer

FALSE

Explanation

Define in NOARCHIVELOG mode

Define in NOARCHIVELOG Mode

Define in NOARCHIVELOG mode

  • No, NOARCHIVELOG parameter is not used to enable the database in archive mode.

  • It disables the archive of the redo log.

  • It indicates that filled groups are not required to be archived.

    Impact of NOARCHIVELOG

  • NOARCHIVELOG mode protects a database from instance failure but not from media failure.

  • Media failure in NOARHIVELOG mode allows restoring the database to the point of most recent database backup.

  • Does not perform online tablespace backup, nor uses online tablespace backups taken while the database was in ARCHIVELOG mode.

  • A database in NOARCHIVELOG mode thus requires regular backup

Question number: 810

» Basic CS » Data Structures

Short Answer Question▾

Write in Short

What is the data structure used to perform recursion?

Explanation

  • Stack data structure is usually used to perform recursion.

  • Recursion is a function which calls itself with an argument.

  • A termination condition, the control returns to the calling function.

  • Stack is container of object where objects are inserted and removed according to LIFO.

  • Stacks allows two operations- push the item into the stack and pop the item out of the stack.

  • Recursion makes use of system stack to store the return address, arguments and return values of the function calls.

  • Some recursions can use the explicit program defined constructs.