Database [3i Infotech Placement]: Sample Questions 171 - 172 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 171

Database

Question

MCQ▾

Identify the Odd one of the following statements?

Choices

Choice (4)

a.

Poplist

b.

Tlist

c.

List of values

d.

Combo box

Answer

c.

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 172

Database
Edit

Describe in Detail

Essay▾

What is Storage Manager?

Explanation

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.

Developed by: