3i Infotech Papers: Sample Questions 214 - 215 of 1245

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

Question number: 214

» Database » Oracle

MCQ▾

Question

Transactions per rollback segment is derived from …

Choices

Choice (4) Response

a.

Db_Block_Buffers

b.

Complex snapshots

c.

Question does not provide sufficient data or is vague

d.

None of the above

Answer

b.

Explanation

The rollback segment.

The Rollback Segment.

The rollback segment.

  • Complex snapshots contain at least any one of the GROUP BY clause, CONNECT BY clause, JOIN, sub-query or snapshot of operation.

  • Transactions per rollback segment are derived from complex snapshots.

  • The transaction load on the system is the number of rollback segments.

  • Rollback filers are associated with large transaction.

  • The sizing of rollback segments depends on many factors like the size of the average transaction, the size of the large transaction, and the available space.

Question number: 215

» Languages » C & C Plus Plus

Essay Question▾

Describe in Detail

  1. void main ()
  2. {
  3.     int i;
  4.     for (i = 1i<=4i + + )
  5.     switch (i)
  6.     {
  7.         case 1printf ( “%d”, i);
  8.         break;
  9.         case 2printf ( “%d”, i);
  10.         break;
  11.         case 3printf ( “%d” ,i);
  12.         break;
  13.         case 4printf ( “%d”, i);
  14.         break;
  15.     }
  16. }

Explanation

  • In the program

Table showing the program

Table showing the program

int i;

  • Define the integer variable i

for (i = 1; i < =4, i ++)

  • Check the for loop

switch (i)

{

case 1: printf (“%d”, i);

break;

  • In the for loop i = 1 than check case 1 and printf prints the value of i = 1

case 2: printf (“%d”, i);

break;

  • In the for loop i = 2 than check case 2 and printf prints the value of i = 2

case 3: printf (“%d”, i);

break;

  • In the for loop i = 3 than check case 3 and printf prints the value of i = 3

case 4: printf (“%d”, i);

break;

  • In the for loop i = 1 than check case 4 and printf prints the value of i = 4