Multiple-Choice Questions About Powerbuilder Part 10

Question: 101

List the access type that allows the only descendents to read.

Answer

ProtectedRead

Question: 102

Linked Object can be invoked for in-place editing.

Answer

TRUE

False

Question: 103

List the access type that allows only the object that declares it to read and write.

Answer

Private

Question: 104

In the ‘Cold Link’ the DDE Server sends the changed data automatically to the DDE Client.

Answer

TRUE

False

Question: 105

Instance variables are ___ ______ between instances.

Answer

Not Shared

Question: 106

Which one of the following is true?

Answer

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.

PB Server application can use only OLE Presentation style datawindows.

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

Question: 107

Shared variables are ______ between instances.

Answer

Shared

Question: 108

SetSQLSelect() validates the SELECT statement that is being set: ( Assume the DataWindow is updatable)

Answer

TRUE

False

Question: 109

Access levels can be defined only to ________ variables.

Answer

Instance

Question: 110

answer correct

Answer

No, Changing the SELECT statement using SetSQLSelect() do not affect the update information. That means, PowerBuilder will update ‘product_master’ table.

Yes, Changing the SELECT statement using SetSQLSelect() also affects the update information. That means, PowerBuilder will update ‘product_master_history’ table.

Question: 111

Shared variables are always ______.

Answer

Private

Question: 113

Global variables are always _____.

Answer

Public

Question: 114

Which of the following statement is correct?

Answer

Only horizontal Datawindow split is possible.

Only vertical Datawindow split is possible.

Both vertical, and horizontal split are possible, but only one at any time.

Both vertical and horizontal split are possible at the same time.

A Datawindow can not be split.

Question: 115

Send() actually ________ the event and TriggerEvent ________ the script for the event.

Answer

Triggers,Executes

Question: 116

A Datawindow has 100 rows. The cursor is on row number 10. Now, you scroll to row number 25 using the vertical scrollbar. Where the cursor will be?

Answer

Row number 25.

Row number 10.

Question: 117

PostEvent() _______ the message to the message queue.

Answer

Appends

Question: 118

In the Datawindow’s context, current row and the selected row is same.

Answer

TRUE

False

Question: 119

PostEvent() _______ the message to the message queue.

Answer

Appends

Question: 120

What you need to do in the SQLPreview event, to skip all updates for item_no 10 and continue update requests for other records.

Answer

if li_item_no = 10 Then SKIP UPDATE

if li_item_no = 10 Then SKIP THIS AND CONTINUE

Return 2 if item_no = 10

Return 0 if itemNo = 10

Return -99 if item_no = 10

Question: 121

TriggerEvent() inserts the message at the _____ of the message queue.

Answer

Beginning

Question: 122

What will happen if you write This.InsertRow(0) in the DataWindow’s constructor event?

Answer

Inserts a row in the DataWindow.

Results in run-time error since you are trying to insert a row even before the Datawindow construction is complete.

Question: 123

What is the row status when a row is inserted using InsertRow() function.

Answer

New!

Question: 124

What will happen when you supply more arguements in the DataWindowControlName.Retrieve() function than the DataWindow is expecting?

Answer

Results in ‘Error:617, Severity:16, Message:Unexpected arguments are supplied’ error.

Ignores extra arguments.

Keeps extra arguements in memory and will use next time when Retrieve() is called with less arguments than the expected.

Results in compile time error.

Question: 125

What is the row status after a row is inserted using InsertRow() and some of the columns are modified.

Answer

NewModified!

Question: 127

What is the row status when a row is added using ImportString

Answer

NewModified!

Question: 128

PowerBuilder checks for the correctness of the SQL Statement before sending to the connected database:

Answer

When specified using SetSQLSelect() function.

When specified using SetSQLPreview() function.

When specified using Modify() function.

When specified using dot notation syntax.

Question: 129

What is the row status when a row is added using ImportFile() function.

Answer

NewModified!

Question: 130

You have defined a Datawindow with no retrieval arguments. You marked two columns for the ‘Prompt for Criteria’. What will happen when you call dw_1.Update( Arg1, Arg2 )?

Answer

PowerBuilder prompts the user for the retrieval arguments for each column that is marked for ‘Prompt for Criteria’.

PowerBuilder doesn’t prompt, since you have specified the arguments in the Retrieve() function.

Results in run-time error since the Datawindow is not expecting any retrieval arguements.

Question: 131

What is the Datawindow row status after a row is retrieved from the database and changed.

Answer

DataModified!

Question: 132

What will happen when you specify less arguments than expected by the Datawindow?

Answer

Results in compile-time error.

PowerBuilder prompts for un-supplied arguments.

Prompts for all arguments.

Uses default values for unspecified arguments. zero for numeric parameter, space for string parameter and ’01-01-1900′ for date parameter.

Question: 133

What is the Datawindow row status after a row is retrieved from the database?

Answer

NotModified!

Question: 134

The action of changing the SQL statement using ______________ gives faster performance than using ______________.

Answer

SetSQLSelect, Modify

SetSQLSelect, dot notation syntax

SetSQLSelect, SetSQLPreview

Modify(), SetSQLSelect

Dot notation syntax, SetSQLSelect

Question: 135

What statement PowerBuilder sends to the database for a row with NewModifed! status?

Answer

INSERT

Question: 136

Checkbox default prefix:

Answer

cb_

chkbx_

chbx_

cbx_

Question: 137

What statement PowerBuilder sends to the database for a row with DataModifed! status?

Answer

UPDATE

Question: 138

PowerBuilder gives window controls prefix:

Answer

TRUE

FALSE

Question: 139

What statement PowerBuilder sends to the database for a row with New! status?

Answer

None

Question: 140

The third state of a checkbox is:

Answer

X

Circle

Square

Filled Circle

Filled Square

Question: 141

Whhich function returns the status of a given row in a given DataWindow?

Answer

GetItemStatus()

Question: 142

On a Tab control, Tabs can only appear on the right side of the control?

Answer

TRUE

FALSE

Question: 143

Whhich function returns the status of COLUMN in a given row in a given DataWindow?

Answer

GetItemStatus()

Question: 144

Which DataWindow method saves the chnages in the Database?

Answer

ApplyChanges()

Commit()

Store()

Save()

Update()

Question: 145

______________ DataWindow method returns the row and column that is required a value and contains a NULL value.

Answer

FindRequired()

Question: 146

Only one CommandButton in a Window can have ‘Cancel’ attribute set to True.

Answer

TRUE

FALSE

Question: 147

List the function name that copies a graph in a Datawindow to the clipboard.

Answer

ClipBoard()

Question: 148

In creating an EXE, each PBL can have its own PBR file.

Answer

TRUE

FALSE

Question: 149

List the function name you use to search in a Datawindow.

Answer

Find()

Question: 150

To deploy a PowerBuilder application, the only thing you need is the application’s executable file.

Answer

TRUE

FALSE

Question: 151

List the function name you use to search the next occurance of a specified string in a Datawindow.

Answer

Find()

Question: 152

When the destructor event is triggered for the CheckBox:

Answer

After the Window CloseQuery event.

After the Window Close event.

Before the Window CloseQuery event.

After all RadioButtons and GroupBox are destroyed.

Question: 153

List the function name you use to search the next occurance of a specified string in a RTF presentation style Datawindow.

Answer

FindNext()

Question: 154

Where the sorting is done in the following situation?
Select * from product_master order by product_no

Answer

Client

Server

Both in the Client and the Server

Question: 155

List the function name that you use to find the next modified row.

Answer

GetNextModified()

Question: 156

Where the computation takes place in the following query:
Select product_no, product_balance, product_re_order_level, DIFF1 = ( product_balance – product_re_order_level) from product_master?

Answer

Client

Server

Shared between Client and Server

In the middle layer

Question: 157

List the function name that returns the validation rule of a Datawindow column.

Answer

GetValidate()

Question: 158

In the GROUP presentation style, grouping is done by:

Answer

Client

Server

Middle Layer

Shared between the Client and the Server

Question: 159

Which function returns the value of an item in a value list or code table associated with a column in a DataWindow.

Answer

GetValue()

Question: 160

Select the VALID Internal PowerBuilder object:

Answer

SQLMessage

SQLTA ( SQL Transport Area )

DynamicBufferingArea

DynamicDescriptionArea

PBError

Question: 161

MicroHelp is to MDIframe as PowerTips is to:

Answer

Menu

Question: 162

When you check in/out an object from the Library painter, PowerBuilder stores your user name in:

Answer

Library.INI

PB.INI or in Registry

AppllicationName.INI

Stores in the object that is being checked out and removes the user name as soon as the object is checked-in.

Stores in the memory.

Question: 163

Which function will open a popup menu at a specified location?

Answer

PopMenu()

Question: 164

A PC based PowerBuilder client application communicating with a remote RDBMS server via ODBC is an example of Three-Tiered Architecture. (There are three layers, application, ODBC, remote RDBMS)

Answer

TRUE

FALSE

Question: 165

Integer(‘10.3’) returns

Answer

10

Question: 166

Computed Fields can reference other computed fields

Answer

TRUE

FALSE

Question: 167

Mod(103,10) returns:

Answer

3

Question: 168

DataWindow.GetCurrentRow() returns:

Answer

The current row number that has focus.

The row number that is currently selected.

None of the above.

Question: 169

Given the string ‘ PowerBuilder ‘, What function will return ‘PowerBuilder’?

Answer

Trim

Question: 170

The count( ) function can be used to:

Answer

In the Datawindow expression to count the number rows in a group or report.

On the Datawindow control to count the number of rows.

Question: 171

What function will return ‘PowerBuilder’ as ‘POWERBUILDER’?

Answer

Upper

Question: 172

Once a DataWindow retrieve is started, it CANNOT be stopped?

Answer

TRUE

FALSE

Question: 173

What function is placed in a loop to allow the user to interrupt it?

Answer

Yield

Question: 174

When creating a new DataWindow, up to two different data sources may be selected at once by holding down the CTRL key.

Answer

True.

True, but restrictions apply.

False.

Question: 175

Which class is a DataWindowChild inherited from?

Answer

Structure

Question: 176

The valid values for a boolean Data Type are?

Answer

True, False

Yes, No

1, 0

Question: 177

Which class is the message class inherited from?

Answer

NonVisualObject

Question: 178

SetRow(987) will set the current row in a DataWindow to 987 and Scroll to row 987.

Answer

TRUE

FALSE

Question: 179

What function would you use to obtain the name of a class for a given object?

Answer

ClassName()

Question: 180

FilteredCount() returns:

Answer

The number of rows that do not pass the filter criteria.

The number of rows that pass the filter criteria.

There is no such function in PowerBuilder. Use Long( DataWindow.Describe(‘DataWindow.Rows.Filter.Count’) )

Question: 181

An object that is loaded into memory is known as an ________ of that object.

Answer

Instance

Question: 182

Which Data Type will store a floating point number with 15 digits of precision?

Answer

Decimal

Float

Real

Double

Long

Question: 183

What is the function name which will begin the transfer of data in a Pipeline?

Answer

Start()

Question: 184

Which Data type will store a number up to 18 digits?

Answer

Decimal

Long

Integer

TinyInt

Real

Question: 185

Which function will display the system Save File Dialog box?

Answer

GetFileSaveName()

Question: 186

Which Data Type will store a signed floating point number with a 6 digits of precision?

Answer

Double

Real

Float

Integer

Unsigned Integer

Question: 187

What command will remove an instance of an object from memory?

Answer

DESTROY

Question: 188

This.InsertRow(0) in placed in the CONSTRUCTOR event of a DataWindow control. Where will the blank row appear after successful Retrieve() function call?

Answer

As the first row in the DataWindow

As the last row in the DataWindow

Can’t retrieve data into a DataWindow when the Datawindow already has some data in it.

None of the above.

Question: 189

What function will remove an instance of a window from memory?

Answer

Close

Question: 190

dw_1.Scroll(300) will scroll to the 300th row in DataWindow dw_1.

Answer

TRUE

FALSE

Question: 191

Which type of window can’t be moved from the parent window?

Answer

Child

Question: 192

Which one of the following prints the Datawindow?

Answer

DataWindowControlName.Print( PrinterName )

DataWindowControlName.Retrieve() > PrinterName

DataWindowControlName.Print( StartRowNoToPrint, EndRowNoToPrint )

DataWindowControlName.Print( BooleanValue )

Question: 193

Which type of window can be moved out of parent window?

Answer

Main

Child

Popup

Response

Question: 194

You have deleted 10 rows from a nonupdatable Datawindow dw_1. What would be return value of dw_1.DeletedCount()?

Answer

10

0

NULL

Can’t call DeletedCount() for nonupdatable DataWindow.

Question: 195

The default text in the title bar of a new window is?

Answer

Untitled

Question: 196

Filter() function on a nonupdatable Datawindow dw_1 filtered out 12 rows out of 100 rows. The dw_1.FilteredCount() function returns:

Answer

12

88

100

0

NULL

Question: 197

Which statement instantiates an object in the memory?

Answer

CREATE

Question: 198

Is it possible to explode a section of a Pie Graph in a DataWindow?

Answer

Yes

No

Question: 199

Which function instantiates a window in the memory and also displays on the screen?

Answer

 Open(), OpenWithParm(), OpenSheet(), OpenSheetWithParm()

Question: 200

Array’s first subscript should be:

Answer

0

1

Any positive number

Question: 201

Can you declare a unbound array in PowerBuilder?

Answer

Yes

No

Question: 202

Do PowerScript support multi-dimentional array?

Answer

Yes

No

Question: 203

A Datawindow has two OLE Database BLOB objects. How many times you need to call Update() function to update the whole Datawindow?

Answer

Once

Twice

Three times. Once for the DataWindow and one time for each OLE Database BLOB.

A Datawindow with multiple OLE Database BLOBs is not updatable.

Question: 204

How many nested Datawindows a Datawindow can contain?

Answer

1

99

32547

No limitation.

Question: 205

A Datawindow is passed to a function by Read-Only. Can the function change the value of a Datawindow’s column?

Answer

Yes

No

Question: 206

To be able to access the changed value of a variable that is passed to a function, you should pass the variable by

Answer

Value

Reference

ReadOnly

Question: 207

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

Answer

colon

double colon

tilda

pound

ampersand

Question: 208

A shared integer variable si_dummy is defined in a window w_1. w_1 is instantiated once and the variable si_dummy is set to 100 and the window is deinstanciated. When w_1 is instantiated again, what would be the value of si_dummy?

Answer

NULL

0

100

Question: 209

Turning the checked attribute on for a MenuItem will display a check mark to left of the MenuItem.

Answer

TRUE

FALSE

Question: 210

If a CommandButton is visible in the ancestor window, it can’t be made invisible in the descendent window.

Answer

TRUE

FALSE

Question: 211

A control name in the descendent window can’t be changed.

Answer

TRUE

FALSE

Question: 212

What language is used to program in PowerBuilder?

Answer

C

C++

Java

Pascal

Fortran

Question: 213

What happens when you disable MenuItem?

Answer

User can not click on the associated tool bar icon.

User can click on the associated tool bar icon.

Question: 214

What happens when you hide a MenuItem?

Answer

Toolbar is hidden automatically.

Toolbar is visible and user can click on the toolbar icon.

Toolbar is visible and user can not click on the toolbar icon.

Question: 215

Stored procedures CANNOT be used as a data source to a Pipeline.

Answer

TRUE

FALSE

Question: 216

Is the following statement VALID?
if ( x > 0) then return 0

Answer

TRUE

FALSE

Question: 217

Once a FOR loop is started, it must run to completion?

Answer

TRUE

FALSE

Question: 218

When developing user objects, in keeping with the OOP paradigm, data should be private and methods should be public.

Answer

TRUE

FALSE

Question: 219

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

Answer

0,0,0

255,255,255

128,128,128

Question: 220

The SQL statement for a Pipeline data source can, Multiple table joins are NOT allowed?

Answer

Have a Stored Procedure as a DataSource.

Have a SELECT statement on a VIEW as a DataSource.

Have a multi-table join SELECT statement as a DataSource.

Have a SELECT statement with a SUB-SELECT statement as a DataSource.

Option C with a maximum of 4 tables in the join.

Question: 221

At the end of the second statement in the following script, What would be the value of ls_Dummy1?
String ls_Dummy1
SetNull( ls_Dummy1 )

Answer

NULL

“”

‘

space

Question: 222

A messageBox() defaults to the StopSign! image if nothing is specified?

Answer

TRUE

FALSE

Question:

PowerBuilder toolbars are dockable?

Answer

Yes

No

Question: 224

The default window type of a new window is:

Answer

MDI Frame

MDI Frame with Microhelp

Main

Child

Popup

Question: 225

To display Microhelp, the window type must be defined as an MDI Frame. Yes/No?

Answer

Yes

No

Question: 226

The SetMicroHelp function can only be used in a MDI application.

Answer

Yes

No

No, you can call this function for a non-MDI window also, but, nothing will happen.

Question: 227

PowerBuilder Window can’t be inherited

Answer

TRUE

FALSE

Question: 228

Datawindow can’t be inherited

Answer

TRUE

FALSE

Question: 229

Can a popup window have a menu attached to it?

Answer

Yes

No

Question: 230

The user can only move a window if it has a toolbar?

Answer

Yes

No

Question: 231

In a six level deep FOR loop, the EXIT statement in the sixth level brings the control to:

Answer

Fifth level

Outermost level

You should specify the loop number in the EXIT statement as: EXIT LOOP_NUMBER.

EXIT statement exits the application. You should use EXITLOOP statement.

EXIT statement exits the current event/function. You should use EXITLOOP statement.

Question: 232

The GOTO statement takes the control to:

Answer

The specified Event.

The specified function declared at the same object level.

The specified label in the same event/function script.

Option C. If label is not found, then it looks for a event with the same name and executes it. If doesn’t find, it looks for a function with the same name in the same object.

GOTO is not implemented in PowerScript.

Question: 233

The correct syntax for GOTO statement is:

Answer

GOTO :LABEL and define the label as :LABEL

GOTO :LABEL: and define the label as :LABEL:

GOTO LABEL: and define the label as LABEL:

GOTO LABEL and define the label as LABEL:

GOTO LABEL and define the label as [LABEL]