Interview Questions

Q:

Explain Row level and statement level trigger.

Answer

Row Level Trigger :
Row Level Trigger is fired each time row is affected by Insert, Update or Delete command. If statement doesn’t affect any row, no trigger action happens.

Statement Level Trigger :
This kind of trigger fires when a SQL statement affects the rows of the table. The trigger activates and performs its activity irrespective of number of rows affected due to SQL statement.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 4013
Q:

Why does the Outstanding exp & Prepared Expenses treated as Personal Account?

Answer

Because these exps are paid/payable to persons. person includes Sole Proprietor, Partnership Firms, HUF, Co; etc.Personal accounts always appear in B/S until it is transfered to expenditure by debiting to P&L A/C.

Report Error

View answer Workspace Report Error Discuss

Subject: Accounts Payable

1 4011
Q:

What is the difference between mysql_connect and mysql_pconnect?

Answer

There is a decent page in the php manual on the subject, in short mysql_pconnect() makes a persevering association with the database which implies a SQL join that don't close when the execution of your script closes. mysql_connect()provides just for the database new association while utilizing mysql_pconnect , the capacity would first attempt to locate a (relentless) connection that is as of now open with the same host, username and password. On the off chance that one is found, an identifier for it will be returned as opposed to opening another connection... the connection with the SQL server won't be terminated when the execution of the script ends. Rather, the link will stay open for future use.

Report Error

View answer Workspace Report Error Discuss

Subject: PHP
Job Role: Database Administration

0 3994
Q:

What is meant by heap?

A) Used for fast reterival of elements B) Used for organising the elements
C) Both a & b D) None of the mentioned
 
Answer & Explanation Answer: C) Both a & b

Explanation:

A heap is a way to organize the elements of a range that allows for fast retrieval of the element.

Report Error

View Answer Report Error Discuss

Filed Under: C++

2 3992
Q:

What is Binary Portability Testing?

Answer

Testing an executable application for portability across system platforms and environments, usually for conformation to an ABI specification.

Report Error

View answer Workspace Report Error Discuss

Subject: QA Testing

0 3981
Q:

If sub class data member is hiding super class data member then how to access super class data member inside sub class methods?

Answer

use super keyword.


super keyword points immediate super class.


Class Sample {


int a =23;


 }


Class Sub extends Sample { 


 String a = "bablu";


 void show() {


 System.out.println(a); //bablu


 System. out. println(this.a); //bablu


 System. out.println(super.a); //23


}


}


Class Demo {


Public static void main(string[] args) {


sub s = new Sub();


s.show();


}


}


 

Report Error

View answer Workspace Report Error Discuss

Subject: Java

1 3976
Q:

Which CICS service transaction is used to gain accessibility to CICS control tables? Mention the one that has the highest priority?

Answer

CEDA 

Report Error

View answer Workspace Report Error Discuss

0 3966
Q:

Managing advertising, sales promotion and public relations :

what is public relations in marketing?

Answer

Public relations includes promotional activities that work to create a strong public image of the company. Public relations activities include helping the public to understand the company and its products. Public relations if done right can reach a large audience without the expensive cost of traditional advertising and marketing.

Report Error

View answer Workspace Report Error Discuss

0 3966