3i Infotech Papers: Sample Questions 464 - 466 of 1245

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

Question number: 464

» Database » Oracle

MCQ▾

Question

What is difference between a DIALOG WINDOW and a DOCUMENT WINDOW regarding moving the window with respect to the application window?

Choices

Choice (4) Response

a.

Dialog and document windows behave the same way as far as moving the window is concerned.

b.

A dialog window can be moved outside the application window while a document window cannot be moved

c.

A document window can be moved outside the application window while a dialog window cannot be moved

d.

All of the above

Answer

b.

Explanation

Table of the Dialog and document windows

Table of the Dialog and document windows

Dialog window

Document window

Can be moved outside the application window

Cannot be moved

Used for modal dialogs.

Displays the main canvases

Question number: 465

» Database » MySQL

Short Answer Question▾

Write in Short

What is Fully Functional dependency?

Explanation

Example of Full Functional Dependency.

Example of Full Functional Dependency.

Example of Full Functional Dependency.

  • It is based on concept of full functional dependency.

  • A functional dependency X Y is full functional dependency if removal of any attribute A from X means that the dependency does not hold any more.

  • X functionally determines Y.

If for each pair of tuples and for all relations in :

If then we must also have

Question number: 466

» Database » MySQL

Short Answer Question▾

Write in Short

What are stored-procedures? And what are the advantages of using them.

Explanation

  • Database objects that perform a user-defined operation- like data-validation.

  • Extensive or complex processing requiring execution of several SQL statement is saved into store procedures, with all applications calling the procedures.

Advantages of stored-procedures:

  • Easier to maintain and solution of problem as they are modular.

  • Better tuning and performance

  • Easier from a GUI end than using complex queries.

  • Can be part of a separate layer, which allows separating the concerns.

  • Improved security

  • Support automatic execution.

  • Reduced development cost and increased reliability.