3i Infotech Placement: Sample Questions 362 - 364 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 362

Question

MCQ▾

How can you CALL Reports from Forms 4.0?

Choices

Choice (4)

a.

Run_Product built_in

b.

Run_Report built_in

c.

Call_Report built_in

d.

Call_Product built_in

Answer

b.

Explanation

  • Calling Oracle Reports using RUN_REPORT is best handled by a generic PL/SQL procedure in forms.
  • It populates all the parameters to execute the report.
  • Call the RUN_REPORT built-in to send a request to oracle reports.

Question 363

Edit

Describe in Detail

Essay▾

What is the output of the following program?

  1. # include <stdio.h>
  2. intone_d[] ={ 1, 2, 3};
  3. main ()
  4. {
  5.     int ⚹ptr;
  6.     ptr =one_d;
  7.     ptr += 3;
  8.     printf ( “%d” ⚹ptr);
  9. }

Explanation

In the program

Table Shows the Program
int one_d [] = {1,2, 3} ;Define global integer array one_d = {1,2, 3}
int ⚹ ptr;Define the integer pointer ptr.
ptr = one_d;Ptr pointer is pointing “out of range” of array one_d
printf ( “% d” ⚹ ptr) ;So, printf prints garbage value

So, answer will be garbage value

Question 364

Edit

Statement

True-False▾

Explicitly we can assign transaction to a rollback segment

Answer

TRUE

Explanation

  • Yes, we can assign transaction to a rollback segment.
  • Rollback segment is a database object containing before-images of data written to the database.

Rollback Segment

  • Used to undo changes when a transaction is rolled back.
  • Transaction does not see uncommitted changes made to the database.
  • Recover the database to a consistent state in failures.

Two types of rollback segments:

  • Private rollback segments
  • Public rollback segments
Two Types of Rollback Segments

Developed by: