Database [3i Infotech Placement]: Sample Questions 108 - 109 of 294

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

Question 108

Database

Question

MCQ▾

What is the maximum size of the page?

Choices

Choice (4)

a.

Characters wide & 260 characters length

b.

Characters wide & 265 characters length

c.

Characters wide & 80 characters length

d.

Question does not provide sufficient data or is vague

Answer

b.

Explanation

  • The value of page size is the number of output lines to produce on each page.
  • Used in the initialization section of program.
  • The value of page size is automatically saved for the default outline.
  • Characters wide & 265 characters length is the maximum size of the page.
  • Page size option specifies the size of a page- the number of line produced on page.
  • Page size is used in the initialization section of report program.
  • When page size is changed- oracle change OLAP
  • Memory paging system depends on OS and ranges from 512 to 4096.

Syntax

SET PAGESIZE lines_on_page

Question 109

Database

Question

MCQ▾

What is the difference between a MESSAGEBOX and an ALERT?

Choices

Choice (4)

a.

An message box requires an response from the user while a alert just flashes a message an only requires an acknowledgment from the user

b.

A alert can be used only by the system and cannot be used in user application while an message box can be used in user application also.

c.

An alert requires an response from the user while a message box just flashes a message and only requires an acknowledgment from the user

d.

A message box can be used only by the system and cannot be used in user application while an alert can be used in user application also.

Answer

c.

Explanation

Table of the MESSAGEBOX and an ALERT
MESSAGEBOXALERT
Flashes a message and only requires an acknowledgment from the userRequires an response from the user
Give a message and only requires acknowledgement from the userRequire an response from the user
Is a messageIs a warning
Is in VB scriptIs in javascript
Display two buttons- “ok” and “cancel”Displays only one button- “ok” button

Developed by: