3i Infotech Placement: Sample Questions 138 - 139 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 138



Which of the following does not affect the size of the SGA


Choice (4)


Database buffer


Redolog buffer


Shared pool


Stored procedure




Structure of System Global Area
  • The SGA (System Global Area) is an area of memory allocated when an Oracle Instance starts.
  • Its size and function controlled by initialization parameters.
  • Contains data buffer areas; redo log buffers and the shared pool.
  • Used by oracle processes to hold shared database instance information.
  • Oracle uses initialization parameters to control the amount of allocated SGA memory.

SGA Components Are as Follow

  • Dictionary cache
    • It is holds data dictionary table information and information regarding accounts, segments, data files, tables and privileges
  • Redo log buffer
    • Includes information about committed transactions that have not yet been written to online redo log files
    • It is holds a copy of data blocks read from data files
  • Shared pool
    • Holds a cache of parsed and commonly used Structured Query Language (SQL) statements
  • Java pool
    • Parses Java statements.
The SGA Components

Question 139


Describe in Detail


Find the output for the following C program

  1. main ()
  2. {
  3.     char ⚹p1 =“Name” ;
  4.     char ⚹p2;
  5.     p2 =(char ⚹) malloc(20);
  6.     while ( ⚹p2 ++ =⚹ p1 ++ );
  7.     printf ( “%s”, p2);
  8. }


  • In the program
Table Showing the Program
char ⚹ p1 = “Name” ;
  • define the character pointer p1 = “Name”
char ⚹ p2;
  • define the character pointer p2
p2 = (char ⚹) malloc (20) ;
  • using the malloc () function
  • void ⚹ malloc (size_t size) allocates the requested memory and returns a pointer to it.
while (⚹ p2 ++ =⚹ p1 ++) ;
  • apply the while condition
printf ( “% s” , p2) ;
  • printf prints the pointer p2 value
  • pointer p2 has no string so it is empty string

Developed by: