Powerbuilder 10.0 professional exam - 510-309 Exam Practice Test

Question 1

Which of these are correct about the SyntaxFromSQL( ) method? (Choose 3)

A. Is a method of the Transaction class

B. You must bind the DataWindow control to the transaction object before invoking this method

C. Must have a style string as one of its arguments

D. Can have its return code stored as a DataWindow object in a PBL using the LibraryImport( ) method

E. Is a method of the DataWindow class

Correct Answer: A,C,D

Question 2

Which function contains optional arguments that utilize the WordParm and LongParm properties of the message object to pass information?

A. GetEnvironment()

B. ChooseColor()

C. TriggerEvent()

D. Open()

Correct Answer: C

Question 3

Custom Transaction Objects are required: (Choose 2)

A. when you want to use dynamic DQL format 3 & 4

B. to define destination data for pipelines

C. when you want to define stored procedures as methods

D. when you want to extend SQLCA

Correct Answer: C,D

Question 4

Which of the following methods is NOT for a DataStore?

A. RowFocusChanged

B. GetFullState()

C. SQLPreview

D. GetClickedColumn()

Correct Answer: A

Question 5

The __________ function forces immediate destruction of all unreferenced objects on the heap.

A. DeleteSeries()

B. DestroyModel ()

C. RemoveContent()

D. SetNull()

E. GarbageCollect()

Correct Answer: E

Question 6

The XSLTGen.PublishPath refers to ______

A. browser-specific JavaScript that performs the XSLT transformation on the client browser.

B. the physical path of the Web site folder to which HTMLGenerator100 publishes the generated XSLT document.

C. HTML/JS for transmission to a browser client by the web tier server

D. a reference to the currently associated XML template

Correct Answer: B

Question 7

In a try catch block, which of the following are TRUE? (Choose 2)

A. In PowerBuilder the Exception datatype is the base class for all exceptions.

B. The Finally Block executes only when an exception has been caught.

C. Catch clauses must be coded in order of ascending hierarchy.

D. The Finally Block always executes.

Correct Answer: D

Question 8

Which of the following techniques requires that an additional call to Retrieve method be executed for reducing the number of rows?

A. dw.SetSQLSelect(dw.GetSQLSelect() + WHERE (salary < 10000)?

B. dw.SetFilter(Setnull(ls_filter))
dw.Filter()

C. dw.SetFilter(palary < 100000
dw.Filter()

D. dw.RowsDiscard(dw.Find("salary >= 10000",1, dw.RowCount()), dw.RowCount(), Primary!)

Correct Answer: A

Question 9

What database statement(s) will be issued as a result of the Update in the following script (assume that the local variable rc is > 0 at all times):
long rc
rc = dw.Retrieve()
rc = dw.Find(-d=109 1, rc)
dw.SetItem(rc, alary dw.GetItemNumber(rc, alary * 1.07)
dw.SetItemStatus(rc, 0, New!)
dw.Update(false, false)

A. Update only

B. Delete followed by an Insert

C. Update followed by a Select

D. No SQL is issued

E. Delete only

F. Insert only

Correct Answer: F

Question 10

The FreeDBLibrary property is associated with which object?

A. DataWindow control

B. Window

C. Application

D. Transaction

Correct Answer: C

Sybase Powerbuilder 10.0 professional - 510-309 Exam Practice Test

Latest Update

Useful Links

Contact Us