Database-Oracle [3i Infotech Placement]: Sample Questions 35 - 37 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 35

Oracle

Question

MCQ▾

Can an Alert message be changed at runtime?

Choices

Choice (4)

a.

Yes

b.

No

c.

Question does not provide sufficient data or is vague

d.

None of the above

Answer

a.

Explanation

Using Predefine and Customizing Predefine Alerts
  • Yes, Alert message can be changed at runtime.
  • We can use SET_ALERT_PROPERTY built-in to set the title of the alert.
  • Title, message and button label properties can be changed by using SET_ALERT_PROPERTY and SET_ALERT_BUTTON_PROPERTY.
  • Alert style and default alert button can also be changed but not at runtime- it is set at design time.

Question 36

Oracle

Question

MCQ▾

EMPNO ENAME SAL

A822 RAMASWAMY 3500

A812 NARAYAN 5000

A973 UMESH

A500 BALAJI 5750

Using the above data

Select count (sal) from Emp will retrieve

Choices

Choice (4)

a.

3

b.

0

c.

1

d.

None of the above

Answer

a.

Explanation

These are only three salaries in the database and hence it will count the number of salaries. NULL is ignored like in most of the combination statements.

Question 37

Oracle

Question

MCQ▾

A FORM is made up of which of the following objects … .

Choices

Choice (4)

a.

Only blocks.

b.

block, fields only,

c.

blocks, fields, pages only,

d.

blocks, fields, pages, triggers and form level procedures,

Answer

d.

Explanation

  • Form is made up of blocks, fields, pages, triggers and form level procedures.
  • To access a database object user interface can be created- generates form՚s HTML and validate user՚s input.
  • Form is easy for visitors to use.
  • Form object is designed to get a specific type of information.
  • For example, for a list of categories- to select more than one category, check box form object can be used however to only select one category, use the radio button form object instead.

Developed by: