3i Infotech Papers: Sample Questions 608 - 609 of 1245

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

Question number: 608

» Database » Oracle

MCQ▾

Question

The status of the Rollback segment can be viewed through

Choices

Choice (4) Response

a.

DBA_FREE_SPACES

b.

DBA_SEGMENTS

c.

DBA_ROLES

d.

DBA_ROLLBACK_SEG

Answer

d.

Explanation

Rollback segments in the database

Rollback Segments in the Database

Rollback segments in the database.

  • DBA_ROLLBACK_SEGS can be used to query the data dictionary view- finding the name, segment ID number, and status of each rollback segment in the database

  • Rollback segment allocates one or more rollback segments by name to this instance.

  • If this parameter is set- instance acquires the entire rollback segment to be named in this parameter.

  • Cannot change the value of this parameter dynamically- change its value and then restart this instance.

  • Specifies private rollback segments.

Use parameter:

String

Syntax:

ROLLBACK_SEGMENT= (segment_name [, segment_name] …. )

Default value:

  • Instance uses public rollback segments by default, unless the UNDO_MANAGEMENT init parameter is set to AUTO.

Modifiable:

  • No

Range of value:

  • Any rollback segment name in DBA_ROLLBACK_SEGS

Question number: 609

» Languages » C & C Plus Plus

Essay Question▾

Describe in Detail

What is the output of the following program?

  1. main ()
  2. {
  3.     int i = 10;
  4.     void pascal f (intintint);
  5.     f (i + +, i + +, i + + );
  6.     printf ( “%d” i);
  7. }
  8. void pascal f (integeriintegerjintegerk)
  9. {
  10.     write (ijk);
  11. }

Explanation

Compiler error: unknown type integer

Compiler error: Undeclared functions write

In the program

Table shows the program

Table shows the program

int i = 10;

  • Define the integer variable i = 10

void pascal f (int, int, int);

  • Pascal keyword doesn’t mean that pascal code can be used.

  • It means that the function follows Pascal argument passing mechanism in calling the functions.

void pascal f (integer: i, integer: j, integer: k)

{

write (i, j, k);

}

  • Unknown type integer

  • Undeclared functions write