3i Infotech Papers: Sample Questions 312 - 313 of 1245

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

Question number: 312

» Database » Oracle

MCQ▾

Question

SHOW_ALERT function returns

Choices

Choice (4) Response

a.

Character

b.

Number

c.

Boolean

d.

All of the above

Answer

b.

Explanation

  • SHOW_ALTER displays the given alert, and return a numeric value the operator select one of three alert buttons.

    Syntax:

    SHOW_ALERT (alert_id Alert);

    SHOW_ALERT (altrt_name VARCHAR2);

  • SHOW_ALTER displays model window message in oracle forms

  • FIND_ALTER searches the list of valid alter in form builder.

  • When the given alert is located, the subprogram returns an alert ID.

  • Warning message can be shown using SHOW_ALTER for example, asking for delete confirmation- set the set_alter_button_property before showing alter using SHOW_ALTER.

    Ex. .

  • If we press the first button, it will return:

ALTER_BUTTON1

Question number: 313

» Database » MySQL

Essay Question▾

Describe in Detail

What is database?

Explanation

Structure of database.

Structure of Database.

Structure of database.

  • Database is a systematic collection of data.

  • Databases support storage and manipulation of data.

  • Databases make data management easy.

  • For, example an online telephone directory would definitely use database to store data pertaining to people, phone numbers, other contact details, etc.

  • Your electricity service provider is obviously using a database to manage billing, client related issues, to handle fault data, etc.

  • Now, consider the Facebook. It needs to store, manipulate and present data related to members, their friends, member activities, messages, advertisements and lot more.

  • We can provide countless number of examples for usage of databases.