Multiple-Choice Questions About Powerbuilder Part 2

Question: 101

How do you manipulate .INI file through PowerBuilder functions ?

Answer

Fileread()

ProfileInt()

SetProfileString()

ProfileString( )

Question: 102

Which command/function will blank out a DataWindow?

Answer

ClearValues()

Reset()

ResetTransObject ( )

DeleteRow()

Question: 103

Use Idle() function in Pb Scripts will be?

Answer

PowerBuilder doesn’t have Idle() function

Fires the Application object Idle event after the specified number of seconds.

Fires the Application object Idle event after the specified number of minutes.

Checks whether the application is idle and returns True/False value

Question: 104

You have a DataWindow which returns 10,000 rows. After retrieving 100 rows, you have decided not to  retrieve the rest of the rows. Please select the correct description

Answer

When datawindow is retrieving data , can not interrupt it

You need to put DBCancel() in RetrieveRow event.

you can just return 1 from the RetrieveRow event

Press the Ctrl + C key

Question: 105

Relate to PBDOM Object , which object hierarchy is true ?

Answer

Pbdom_Comment inherited from Pbdom_CharacterData

Pbdom_Text inherited from Pbdom_Document

Pbdom_Text inherited from Pbdom_Attribute

Pbdom_Comment inherited from Pbdom_DocType

Question: 106

Which of the following description is true?

Answer

To display Microhelp, the window type must be defined as an MDI Frame

PowerBuilder Window can’t be inherited

A popup window have a menu attached to it

Datawindow can’t be inherited

Question: 107

How to modify select scripts of Datawindow data source in the power scripts ?

Answer

<Dw control name>.SetChanges(ls_sql)

<Dw control name>.SetSQLSelect(ls_sql)

<Dw control name>.DataObject=ls_sql

<Dw control name>.Object.DataWindow.Table.select=ls_sql

Question: 108

When you update the DataWindow, what would be the each row status in the DataWindow when the  update is successful?

Answer

NewModified!

RetrieveRow!

NotModified!

DataModified!

Question: 109

What are the different statuses a row in a DataWindow can have?

Answer

NotModified!

DataModified!

New!

NewModified!

Question: 110

What are the different statuses a column in a DataWindow row can have?

Answer

Clicked!

NewModified!

DataModified!

NotModified!

Question: 111

When two DataWindow are being shared,Please select the correct description

Answer

you can turn on the query mode only for the primary DataWindow

Crosstab DataWindow can be share data

The presentation is not shared

the sort criteria is shared.

Question: 112

Please select the correct description about  PBDOM object hierarchy

Answer

Pbdom_CharacterData==>Pbdom_Comment

Pbdom_Document==>Pbdom_Text

Pbdom_Attribute==>Pbdom_Text

Pbdom_DocType==>Pbdom_Comment

Question: 113

You have deleted few rows, say 10 rows from a DataWindow, and update the DataWindow. How many  rows would be available in the Deleted buffer after successful update?

Answer

None of the above

0

10

5

Question: 114

Run below PB script, will Show up which MessageBox?
Try  String ls_test = ‘thu nghiem’
Char vc[],vb[12]
vc = ls_test  vb = ls_test
If vb[11] = ” Then
MessageBox(‘1′,’Test1’)
ElseIf IsNull(vb[11])
Then
MessageBox(‘2′,’Test2’)
End If
If vc[9] = ‘m’ Then
MessageBox(‘3′,’Test3’)
ElseIf IsNull(vc[11])
Then   MessageBox(‘4′,’Test4’)
End If
Catch ( runtimeerror er )
MessageBox(“error”,”test end”)
End Try

Answer

show message test1 first, and show message test end

show message test4 first, and show message test end

show message test1 first, and show message test3

show message test2 first, and show message test4

Question: 115

What events aren’t available at a DataStore object?

Answer

SQLPreview

EditChanged

ScrollHorizontal

DragLeave

Question: 116

you have a DataWindow with two fields, emp_name, emp_address. Now, the focus is on the  emp_name field. When the user press tab,please select the correct desctiptions

Answer

GetColumnName() returns ’emp_name’ in the ItemFocusChanged event.

GetColumnName() returns ’emp_address’ in the ItemChanged event

GetColumnName() returns ’emp_name’ in the ItemChanged event

GetColumnName() returns ’emp_address’ in the ItemFocusChanged event.

Question: 117

Give following PB scripts. What Value Of li_remain variable when you Run it ? ong i,a,li_remain
String ls_mk = ‘Y’
dw_1.Reset()
For i = 1 To 11
a = dw_1.InsertRow(0)
If Mod(i,2) = 0 Then
ls_mk = ‘Y’
Else
ls_mk = ‘N’
End If
dw_1.SetItem(a,1,’thu’+String(i))
dw_1.SetItem(a,2,’test’)
dw_1.SetItem(a,3,ls_mk)
Next
ls_mk = ‘N’
dw_1.SetFilter( (“dept_mk = ‘”+ ls_mk +” ‘”))
dw_1.Filter( ) li_remain = dw_1.FilteredCount( )

Answer

5

6

0

11

Question: 118

UInt a = 62515, b = 4000, c
Long e
c = a + b
e = c

What’s the resulting value e?

Answer

979

-6515

66515

1979

Question: 119

How many DataWindow can share the data from a DataWindow?

Answer

No limitation

1

3

2

Question: 120

How do you change the SQL Statement of a DataWindow at run-time?

Answer

you can call SetSQLSelect()

In the SQLPreview event, you can change it using SetSQLPreview()

You can’t change the SQL statement of Datawindow at run time

You can use the Modify() to change the SQL statement of a DataWindow control

Question: 121

PB,Which the answer Is correct?
Dec{0} a
Dec{1} c,b
c = 10 b = 3 a = 0
Int i
For i = 1 To 3
a+= c/b
b+= 1
Next
MessageBox(‘Result’,String(a))

Answer

9

8

6

7

Question: 122

When Update statement in DataWindow which status will be occurred?

Answer

NewModified!

RetrieveRow!

NotModified!

DataModified!

Question: 123

How to refer to a DataWindow column by the column number in the ‘Describe()’ and  ‘Modify()’ functions. which do you need to prefix the column number with ?

Answer

pound

double colon

Colon

ampersand

Question: 124

Where is the GOTO statement will takes the control to ?

Answer

The specified label in the same event/function script

The specified function declared at the same object level

GOTO is not implemented in PowerScript

The specified Event

Question: 125

What are the item status provided with PB ?

Answer

NewModified!

New!

NotModified!

Clicked!

Question: 126

What are the global variables in PB ?

Answer

Error

Message

Database

SQLCA

Question: 127

What events are there in application object ?

Answer

Deactivate

Connection End

Open

System Error

Question: 128

What are the painters provided in the Power builder?

Answer

Pipeline

Datawindow Control

Window

Database

Question: 129

What are functions can overloading?

Answer

opentab()

Open()

Close()

Messagebox()

Question: 130

Referring to ‘This’ from one of the Menu Item refers to:

Answer

THIS is not a valid pronoun in the menu.

The menu

Menu bar item

The Menu item in which event the pronoun THIS is coded

Question: 131

A window has three controls, one RadioButton, one CommandButton and one custom UserObject.  That UserObject has four controls in it. UpperBound( This.Control[] ) in the Window’s Open event  returns:

Answer

Three – 3

Seven – 7

Nine – 9

Eight – 8

Four – 4

Question: 132

CloseQuery event is best described as:

Answer

None of the above.

Fires before the window’s ‘Close’ event.

Fires automatically when the database query is completed.

Trigger or Post this event to cancel the database query.

Question: 133

Which of the following is wrong.

Answer

Application Objects can be shared between different applications, when the applications  are developed in the ‘PowerBuilder Enterprise edition’.

You can declare only Public functions at the application object.

You can limit the number of times an application can instantiate.

You can inherit application object only once per application.

Question: 134

What events you can declare at the menu object?

Answer

There are no restrictions.

PowerBuilder custom events.

Menu related events.

All events that are mapped to event id.

Question: 135

Explain  FUNCTION, PROCEDURE and PACKAGE,What the following descriptions are true?

Answer

Package is the collection of functions, procedures, variables which can be logically grouped together.

Procedure and Function always have return value.

Function must return a value. Can be called inside a query.

Procedure may or may not return value.

Question: 136

To access the global variable when a local variable with the same name is available, which symbol you  need to prefix the variable with?

Answer

pound

double colon

Colon

ampersand

Question: 137

How refresh a datawindow data automatically at a certain intervals?

Answer

Execute Timer ( interval {, windowname } ) first, then execute datawindow.retrieve() in window  timer event.

Set the DataWindow Timer property

DataWindow.Refresh(Interval)

Return the refresh interval from the DatWindow RefreshTimer event

Question: 138

What is Functions for RadioButton control?

Answer

DragEnter

Show

Drag

SetFocus

Question: 139

how to do specify the start-up window name in appliaction object?

Answer

by calling the Open() function in the Application Object create event

by calling the Open() function in the Application Object Open even

by calling the Open() function in the Application Object Constructor event

in the application object’s properties dialogbox at the design-time

Question: 140

In function RGB(red, green, blue), Which of the following combination is black?

Answer

192,192,192

128,128,128

0,0,0

255,255,255

Question: 141

Which of the following describes is true?

Answer

You can’t send a DataWindow as a parameter to the PB server application. You need to use structures  instead.

PB Server application can use only OLE Presentation style datawindows.

DataWindows with RichTextEdit presentation style can’t be used on the PB Server application.

Only ‘Read-only’ datawindows can be used on the PB Server application.

Question: 142

Which of the following events does the DataStore have?

Answer

Itemchanged

Resize

UpdateEnd

DoubleClicked

Question: 143

Which function or statement could be used to dynamically add a user defined Tab control to a window?

Answer

CreateObject()

Create

OpenTab()

OpenUserObject()

Question: 144

Which of the following can be invoked from the System Tree but not the Object Browser?

Answer

Inherit

Regenerate

Edit

Copy

Question: 145

The FreeDBLibrary property is associated with which object?

Answer

Window

Application

DataWindow control

Transaction

Question: 146

CloseWithReturn can be used with what type of window?

Answer

child!

main!

popup!

response!

Question: 147

For a ListView control, which of the following are VALID functions? (Choose 2)

Answer

SortAll

Sort

GetItemAtPointer

GetObjectAtPointer

Question: 148

Which of the following steps is NOT involved in populating a ListView control?

Answer

Define ListViewItem properties such as label

Insert ListViewItems into the ListView control

Instantiate a ListViewItem object

Set static ListViewItem properties

Question: 149

Which features are common to both TreeView and ListView controls assuming only PowerBuilder properties and methods are used? (Choose 2)

Answer

end-users can select multiple items concurrently

static view items can be defined at design time

items can be sorted based on user-defined criteria

different images can be used to indicate the state of individual items

Question: 150

The ___________ system class is used to create custom tab pages

Answer

NonVisualObject

UserObject

GraphicObject

Tab

DrawObject

Question: 151

 ____________ event is triggered only on first expansion of a TreeViewItem

Answer

ItemChanging

ItemPopulate

ItemExpanded

ItemExpanding

ItemSelected

Question: 152

FindItem() function is used in ____________

Answer

Rich text

DataWindow

TreeView

Tab

GraphicObject

Question: 153

Cursors can be declared using which scope(s)?

Answer

Local, Instance, Global, Shared

Instance, Global

Local, Instance, Global

Instance, Shared, Global

Question: 154

Which of these User Object types can be used to create an object of type oleobject?

Answer

Custom Class

External Visual

Standard Class

Standard Visual

Custom Visual

Question: 155

Stored Procedures can be declared as external functions to which type of object?

Answer

Transaction

DataStore

Application Object

Connection

Question: 156

In what order does PowerBuilder search for variable references?

Answer

local, global, instance, shared

local, shared, global, instance

local, shared, instance, global

local, instance, shared, global

local, instance, global, shared

Question: 157

Which of the following are TRUE with respect to AncestorReturnValue? (Choose 2)

Answer

Its data type is always the same as the data type for the ancestor’s return value.

The syntax ancestor_class_name::AncestorReturnValue may be used to access the value returned by a specific ancestor.

If the method has no return type, a reference to AncestorReturnValue returns NULL.

If the method has no return type, a reference to AncestorReturnValue will not compile.

AncestorReturnValue may be used in both Events and Functions.

Its data type is always data type ANY.

Question: 158

If a descendant object can only read an ancestor’s instance variable, what is the variable’s access?

Answer

protectedread

public

public privatewrite

privateread

private

Question: 159

Which of the following is a requirement when using ShareData?

Answer

DataWindow objects shared among DataStores have no visible controls.

The shared DataWindow objects have the same presentation styles.

Each DataWindow object has a SQL statement returning the same result set description.

The column data types and order within the shared DataWindow objects are identical.

The shared DataWindow objects reside in the same PBL.

Question: 160

This line of code specifies a case sensitive sort for a DataWindow

Answer

dw_1.setsort(“last_name I”)

dw_1.setsort(“last_name as”)

dw_1.setsort(“last_name a”)

dw_1.setsort(“last_name A”)

dw_1.setsort(“last_name D”)

Question: 161

Which of the following methods is available for a DataStore but not for a DataWindow control?

Answer

GetContextService

SetHTMLAction

GetFullState

Create

CreateFrom

Question: 162

Choose the script below that will ensure that if either update fails, all the change flags will be intact and the database will be unmodified.

Answer

If dw_master.Update( ) = 1 Then
If  dw_detail.Update(True, False ) = 1 Then
Commit Using SQLCA;
Else
Rollback Using SQLCA;
End If
Else
Rollback Using SQLCA;
End If

dw_master.Update( )
dw_detail.Update( )
COMMIT USING SQLCA;

If dw_master.Update( ) = 1 Then
If dw_detail.Update( ) = 1 Then
Commit Using SQLCA;
Else
Rollback Using SQLCA;
End If
Else
Rollback Using SQLCA;
End If

If dw_master.Update(True, False ) = 1 Then
If dw_detail.Update( ) = 1 Then
Commit Using SQLCA;
dw_master.ResetUpdate()
Else
Rollback Using SQLCA;
End If
Else
Rollback Using SQLCA;
End If

Question: 163

Which of these are Pipeline Object properties? (Choose 2) 

Answer

RowsRead

Repair

PipeEnd

Cancel

RowsInError

Question: 164

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

Answer

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

 Catch clauses must be coded in order of ascending hierarchy.

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

The Finally Block always executes.

Question: 165

For a class data type passed by Reference as a method argument, which of the following are TRUE?  (Choose 3) 

Answer

f the class has the AutoInstantiate property set, an internal reference is allocated on the stack.

The method body may change the reference to point to a different instance.

If the class has the AutoInstantiate property set, a new instance of the class is allocated on the stack and its values are copied from and to caller’s instance.

The method body may change the value of properties of the referenced instance, subject to access restrictions.

The method body may change the value of properties of the referenced instance, regardless of access restrictions.

Question: 166

Which of the following output characteristics can you effect using an XHTML DataWindow template? (Choose 4) 

Answer

override the font color specified in the DataWindow painter for a specific column

the name of the Cascading Style Sheet to be created when using the SaveAs method.

include additional textual output in the XHTML output that does not exist in the DataWindow object itself

remove elements from the XHTML output that would otherwise appear in the DataWindow preview

generate a message that appears in the browser status line whenever the mouse is moved over a column

specify ranges of acceptable values for column data that are imported into the DataWindow using the template

Question: 167

Which of the following functions could be used to convert the text in a multilineedit into an XML document? 

Answer

GetContent()

GetDocument()

BuildFromString()

SaveAs()

Question: 168

Well-formed XML meets which of the following criteria? (Choose 3) 

Answer

All elements are properly nested

Every element has an open and closing tag

Has 0 ( zero ) or more elements

A  Parent(Root) element exists that contains all the other elements

All elements must be of the pre-defined datatype.

Question: 169

A PowerBuilder/EAServer service component has which of the following methods? (Choose 2) 

Answer

Init()

Stop()

Run()

Destroy

Question: 170

When a method is invoked for the first time on a stateless EAServer PowerBuilder component that is not instance pooled, which event sequence is correct? 

Answer

Constructor, Destructor

Constructor, Activate, Deactivate

Constructor, Activate, Deactivate, Destructor

Constructor, Activate, Destructor, Deactivate

Activate, Deactivate

Question: 171

Which DataWindow methods trigger the SQLPreview event? (Choose 3) 

Answer

ScrollToRow()

SelectRow()

Retrieve()

ReselectRow()

Update()

Question: 172

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)

Answer

Insert only

No SQL is issued

Update followed by a Select

Delete followed by an Insert

Update only

Delete only

Question: 173

Select the best description of the following sample of code:

Long ll_template, ll_count
ll_template = Long(dw_xml.Object.datawindow.export.xml.templatecount)
ddlb_template.Reset()
For ll_count = 1 To ll_template
ddlb_template.AddItem(dw_xml.Object.datawindow.export.xml.template[ll_count].Name)
Next

Answer

This code will locate the current xml template being used by a DataWindow Control and assign it into a drop down list box.

This code will cycle through the template array of a DataWindow Control assigning all xml templates to another DataWindow control.

This code will populate a drop down list box with the xml template names found in a DataWindow control.

This code will change the xml template assigned to a DataWindow control to the last template found in the array.

Question: 174

You have added a button to a DataWindow with the pre-defined action to Update the database.  Where could you place code to detect that the update has failed? 

Answer

Application’s SystemError event

DataWindow’s Error event

DataWindow’s ButtonClicking event

DataWindow’s ButtonClicked event

Question: 175

The following are VALID manipulations you can perform on a Descendant Menu. (Choose 3) 

Answer

Change the order of ancestor menu items

Extend or override inherited scripts

Build scripts for menu items that do not have scripts in the ancestor menu

Delete an ancestor menu item

Declare functions, structures and variables for the menu

Question: 176

Which of the following statements, when coded in a menuitem, will compile? (Choose 3) 

Answer

ParentWindow.Classname()

ParentWindow.Title = orders for ABC Company

ParentWindow.of_print()

ParentWindow.Hide()

Question: 177

The Debugger will let you perform which of the following tasks? (Choose 2) 

Answer

Conditionally set a breakpoint

Determine the runtime of an event in milliseconds

Change the value of a variable

Edit code

Question: 178

Which of the following is NOT part of a JSP Custom Tag? 

Answer

Tag Library Descriptor (TLD) file

The Tag property

JavaBean to handle custom tag at runtime

TagLib directive in the JSP file

Question: 179

Which reference is NOT a valid return type for a method of a component deployed as a Web Service? 

Answer

Any

Double

LongLong

String

Question: 180

What PB Wizards allow you to do UDDI browsing? (Choose 2) 

Answer

EAServer Proxy Wizard

EAServer Component Wizard

Web Service Proxy Wizard

EJB Client Proxy Wizard

JSP Web Service Proxy Wizard

Question: 181

Which of the following properties of the Accessibility API allows you to define the type of control used in an application? 

Answer

AccessibleDescription

AccessibleName

Accessible

AccessibleRole

Question: 182

CreateInstance() is a method of which PowerBuilder class(es)? (Choose 2) 

Answer

SoapConnection

Connection

Transaction

Window

Question: 183

This specific exception class type can be thrown by a web service method call and should be caught in the client application. 

Answer

PBXRuntimeError

SOAPException

CORBAUnknown

CORBASystemException

CORBAUserException

Question: 184

What is the function of the SOAPConnection object? 

Answer

To instantiate a proxy object to invoke methods of a Web Service located at a specified or implied endpoint

o establish a connection with a web server to download the Web Services Description Language (WSDL) for a web service

To create a user object for programmatically building a Simple Object Access Protocol (SOAP) message

To open an HTTP channel to query a Web Services Universal Description, Discovery and Integration (UDDI) repository

Question: 185

Identify the objects for which PowerDesigner offers only minimal mapping? (Choose 3) 

Answer

Window

Transaction

Pipeline

UserObject

Query

Menu

Question: 186

To get business details about a web service, you must use a key that is typically obtained from which of the following UDDIProxy methods? 

Answer

findBusiness()

findService()

setInquiryURL()

getBusinessDetail()

Question: 187

The __________  database parameter specifies that PowerBuilder control a component based transaction using the EAServer TransactionServer service . 

Answer

DisableCommit

Async

UseContextObject

ConnectOption

ConnectString

Question: 188

Assuming an installation of EAServer is running continuously, which of the following events is fired exactly once for any and every PowerBuilder component instance on that server? 

Answer

canbepooled

activate

deactivate

constructor

destructor

Question: 189

Which of the following is TRUE regarding the ParentWindow property? (Choose 3) 

Answer

It if a reference property of the GraphicObject ancestor class, directly referring to the window on which a control is placed.

It is a reference property of the Menu class, referring to the window instance that instantiated the menu.

It if a reference property of the Window class, referring to the window that opened the current window.

 It is of class Window

It is of the dynamic class of the parent window as determined at runtime.

Question: 190

Which row in dw_1 will be the current row after executing the following script?  
     
dw_1.SelectRow(25,FALSE)       
dw_1.ScrollToRow(99)      
dw_1.SelectRow(33,TRUE) 

Answer

1

25

99

33

Question: 191

Which of the following will trigger the SQLPreview event in a DataWindow? (Choose 3) 

Answer

InsertRow

ReselectRow

DeleteRow

RowFocusChanged

Retrieve

Update

Question: 192

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

Answer

dw.RowsDiscard(dw.Find(“salary >= 10000”,1, dw.RowCount()), dw.RowCount(), Primary!)

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

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

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

Question: 193

Identify the VALID statements when discussing the use of retrieval arguments in a DataWindow. (Choose 2) 

Answer

String array retrieval arguments should use the Noperator in the DataWindow SQL where clause.

PowerBuilder will load the correct object into the control based on the passed arguments and the DataWindow objects associated with the control.

Extra arguments can be defined but need not be referenced in the DataWindow object.

Extra arguments passed on the retrieve will trigger the dberror event.

Question: 194

Which of the following DataWindow presentation styles will allow the user to create a Group? (Choose 3) 

Answer

Grid

Composite

Rich Text

Tabular

Crosstab

Question: 195

What does the following code sample reference: dw_data.object.data.primary.current 

Answer

All new and retrieved values

All values that are selected

All values retrieved from the database

All values from the current row

Question: 196

Which of these DataWindow events allow using return codes to dynamically modify their default behavior? (Choose 3) 

Answer

Itemchanged

EditChanged

ItemFocusChanged

Clicked

Error

RowFocusChanging

Question: 197

Which of the following methods is NOT for a DataStore? 

Answer

GetFullState()

RowFocusChanged

GetClickedColumn()

SQLPreview

Question: 198

This return code when placed in a DataWindow control ItemError event will automatically put back the original value and allow the focus to change 

Answer

3

2

0

1

Question: 199

fter the following script is executed, what is the integer value of the variable currentRow? 

int currentRow = 0; 
dw_1.SelectRow(99, FALSE) 
dw_1.ScrollToRow(20) 
dw_1.SelectRow(21, TRUE) 
dw_1.ReSelectRow(5) 
currentRow = dw_1.GetRow() 

Answer

99

20

5

21

Question: 200

Rows with the following statuses will not cause the DataWindow to generate delete SQL statements when the update function is called. (Choose 2) 

Answer

DataModified!

NotModified!

New!

NewModified!