Home >
Programmer2Programmer.NET Forum>
University Questions and Answers >> Power Builder (PB) interview Question...
NOTE : Log In required to post Replies for this discussion.
|
Power Builder (PB) interview Question
|
|
AtanuMaity
|
Posted: Saturday 21, June 2014 04:07:43 AM
|
|
|
Q: PowerBuilder generates DELETE SQL statement for all rows tha
t are in the Delete buffer. Is it correct?
Ans: No. PowerBuilder doesn't generate any SQL statement for ro
ws with New! and NewModified! row statuses in the Delete buffer
.
Q: What are the various buffers available in a DataWindow?
Ans: Primary, Original, Delete, Filter
Q: Which buffer contains the retrieved data?
Ans: Primary buffer.
Q: After changing the retrieved data, which buffer contains the
original data that was retrieved from the data source?
Ans: Original buffer.
Q: Why PowerBuilder keeps a copy of original data in the Origin
al buffer, when the latest data is available in the Primary buf
fer?
Ans: PowerBuilder uses the data from the original buffer to gen
erate WHERE clause. Data from the Primary buffer is used in the
INSERT/ DELETE/ UPDATE statements.
Q: What SQL statement PowerBuilder generates for those rows tha
t are in the Filtered buffer.
Ans: In terms of generating SQL statements, Filter buffer belon
gs to the same category of Primary buffer, meaning, PowerBuilde
r will generate INSERT statement for NewModified! row status an
d UPDATE statement for DataModified! row status.
Q: What SQL statement PowerBuilder generates for those rows tha
t have New!, NewModified! row status.
Ans: PowerBuilder doesn't generate any SQL statement for those
rows that have New! row status. NewModified! row status will re
sult in INSERT statement generation.
Q: What are the different statuses a row can have in the Primar
y buffer?
Ans: New!, NewModified!, DataModified! and NotModified!
Q: What are different statuses that a column can have in a Data
Window?
Ans: A column can have NotModified! or DataModified! statuses.
It can not have NewModified! and New! statuses since every colu
mn's data in the row that has NewModified! row status is used i
n the INSERT statement, hence there is no need to keep track of
column status in a row with New! or NewModified! row status.
|
|
Back to Top
^ |
|
| NetExpert | Posted: Saturday 02, August 2014 03:34:49 PM | | Thanks Sir,
Plz upload sybase database interview questions
| | Back to Top ^ | | |
|
|
Home > Programmer2Programmer.NET Forum >University Questions and Answers >> Power Builder (PB) interview Question...
|