Database-Oracle [3i Infotech Placement]: Sample Questions 126 - 127 of 132

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 126

Oracle
Edit

Statement

True-False▾

NOARCHIEVELOG parameter is used to enable the database in Archive mode

Answer

FALSE

Explanation

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 127

Oracle

Question

MCQ▾

Which of the following is TRUE

1. Host variables are declared anywhere in the program

2. Host variables are declared in the DECLARE section

Choices

Choice (4)

a.

Only 2 is TRUE

b.

Only 1 is TRUE

c.

1 & 2 are TRUE

d.

1 & 2 are FALSE

Answer

a.

Explanation

  • Host variable are data items defined a COBOL program.
  • Host variable is used to pass values to and receive values from a database.
  • Host variables can be defined in the File Section, Working-Storage Section, Local-Storage Section of the COBOL program.
  • Host variable declarations are embedded SQL statements “BEGIN DECLARE SECTION” and “END DECLARE SECTION”

Host Variable Are Used in Two Way

Input host variables

  • Input host variables specify data that will be transfer from the COBOL program to the database.

Output host variables

  • Output host variables hold data that is returned to the COBOL program from the database.

When we use the host variable in a SQL statement before we must declare it.

Developed by: