3i Infotech Papers: Sample Questions 341 - 342 of 1245

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

Question number: 341

» Database » Oracle

MCQ▾

Question

If the maximum records retrieved property of a query is set to 10, then a summary value will be calculated

Choices

Choice (4) Response

a.

Only for 10 records

b.

For all the records in the referenced table

c.

For all the records retrieved

d.

None of the above

Answer

a.

Explanation

  • If the maximum records retrieved property of a query is set to 10, then a summary value will be calculated only for 10 records.

  • Summary report contains one column with value or values consisting of a summary of other data.

  • Column totalling sales, column that averages commissions, and column that shows maximum amounts are examples of summary columns.

  • Counts for regular or aggregate records beneath a given refinement are retrieved, using these properties:

    • As a property on each dimension value.

    • As a property on each dimension value- for aggregated records.

  • Value summary columns are calculated by summarizing data retrieved from another column.

Question number: 342

» Basic CS » Data Structures

Essay Question▾

Describe in Detail

In an AVL tree, at what condition balancing is done?

Explanation

  • In an AVL tree, if the balance height is greater than 1 or less than 1 balancing is done.

  • AVL tree is a self-balancing binary search tree.

  • The balance height of left and right sub trees cannot be more than one for all nodes.

AVL Rotations

Left rotation

Image of the Left rotation

Image of the Left Rotation

Image of the Left rotation

Right rotation

Image of the Right rotation

Image of the Right Rotation

Image of the Right rotation

Left-Right rotation

Left-Right rotation

Left-Right Rotation

Left-Right rotation

Right-Left rotation

Right-Left rotation

Right-Left Rotation

Right-Left rotation