3i Infotech Papers: Sample Questions 518 - 519 of 1245

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

Question number: 518

» Database » Oracle

MCQ▾

Question

Identify the Odd one of the following statements?

Choices

Choice (4) Response

a.

List of values

b.

Combo box

c.

Poplist

d.

Tlist

Answer

a.

Explanation

  • LOV is a static or dynamic set of values to display a specific type of page item, popup list of values, a select list, a check box, a radio group or multiple select lists.

  • LOV at the application-level, creates a shared component.

    Advantages

  • Can be added to any page within an application.

  • Definitions are stored in one location, making them easy to be located and update.

  • Easy to use

  • Increase accuracy and productivity.

Question number: 519

» Database » MySQL

Essay Question▾

Describe in Detail

What is Storage Manager?

Explanation

Explanation of Storage of manager.

Explanation of Storage of Manager.

Explanation of Storage of manager.

  • Storage manager is a program module that provides the interface between the low-level data stored in the database and the application programs and queries submitted to the system.

    It usually contains something like the following module:

    • The Buffer Manager

    • Low-level I/O subsystem

    • The transaction and recovery manager

    • Index manager

    • The base table manager

    • Top-level APIs

Components of the Storage Manager:

Authorization and Integrity Manager:

  • Tests the integrity constrains

  • Checks the authorization of users to access data.

Transaction Manager:

  • Ensures that no kind of change brought to the database until a transaction is completed totally.

File Manager:

  • Manages the allocation of space on disk storage and the data structures to represent information stored on disk.

Buffer Manager:

  • Cecides which data needs to be cached in main memory and then fetches it up in main memory.
  • Important as it defines the speed at which the database can be used.