3i Infotech Placement: Sample Questions 214 - 216 of 1245

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 214

Question

MCQ▾

Transactions per rollback segment is derived from …

Choices

Choice (4)

a.

Complex snapshots

b.

Db_Block_Buffers

c.

None of the above

d.

All of the above

Answer

a.

Explanation

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 215

Edit

Write in Short

Short Answer▾

What is immediate addressing mode?

Explanation

The addressing mode in which the data operand is a part of the instruction itself is the immediate addressing mode.

Example:

MOV CX, H, ADD AX, H, MOV AL, FFH

Question 216

Edit

Describe in Detail

Essay▾
  1. voidmain ()
  2. {
  3.     inti;
  4.     for (i =1; i<=4, i ++ )
  5.     switch (i)
  6.     {
  7.         case1:printf ( “%d”, i);
  8.         break;
  9.         case2:printf ( “%d”, i);
  10.         break;
  11.         case3:printf ( “%d” ,i);
  12.         break;
  13.         case4:printf ( “%d”, i);
  14.         break;
  15.     }
  16. }

Explanation

  • In 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

Developed by: