3i Infotech Papers: Sample Questions 696 - 697 of 1245

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

Question number: 696

» Database » Oracle

True-False▾

Question

Is the Following Statement True or False?

A database trigger does not apply to data loaded before the definition of the trigger

Answer

FALSE

Explanation

Define types of triggers

Define Types of Triggers

Define types of triggers

  • Database triggers are executed in response to events that occur in the database.

  • Like a stored procedure it is predefined before event occurs.

  • Enable database administrators to create additional relationships between separate databases.

  • It can execute before or after an INSERT, UPDATE, or DELETE operation.

  • If a trigger event occurs, the trigger’s function is called at the appropriate time to handle the event.

  • Stored code executed immediately after a predefined event.

  • A database trigger does apply to data loaded before the definition of the trigger.

  • Mostly used for maintaining the integrity of the information on the database.

Question number: 697

» Languages » C & C Plus Plus

Essay Question▾

Describe in Detail

  1. main ()
  2. {
  3.     char * q;
  4.     int j;
  5.     for (j = 0j<3j + + )
  6.     scanf (%s (q + j), );
  7.     for (j = 0j<3j + + )
  8.     printf (%c, * (q + j) );
  9.     for (j = 0j<3j + + )
  10.     printf (%s (q + j), );
  11. }

Explanation

  • In a program we have only one pointer to type char and since we take input in the same pointer thus we keep writing over in the same location, each time shifting the pointer value by 1.

  • Suppose the inputs are MOUSE, TRACK and VIRTUAL.

  • Then for the first input suppose the pointer starts at location 100 then the input one is stored as

    M O U S E