Multiple-Choice Questions About Powerbuilder Part 5

Question: 401

Insert a groupbox(gb_1) in the tab’s(tab_1) tabpage(tabpage_1),and insert a datawindow in the groupbox(gb_1),which is datawindow’s(dw_1) path?

Answer

Dw_1

tabpage_1.dw_1

tab_1.tabpage_1.gb_1.dw_1

tab_1.tabpage_1.dw_1

Question: 402

How to get DataWindow column count ?

Answer

Integer(This.Object.Column)

Integer(This.Object.DataWindow.Column)

Integer(This.Object.DataWindow.Column.Count)

Integer(This.Object.Column.Count)

Question: 403

What properties are changing the size of the DataWindow preview?

Answer

dw_1.Object.DataWindow.small

dw_1.Object.DataWindow.big

dw_1.Object.DataWindow.zoom

dw_1.Object.DataWindow.size

Question: 404

Out of this loop to continue the next loop of Is this?

Answer

BREAK

EXIT

RETRUN

CONTINUE

Question: 405

Data sharing in the data window, the following is only the impact of a single data window?

Answer

SetFilter

SetRow

Retrieve

Update 

Question: 406

Dw_1, dw_2 any one of the DW changes will be reflected to the other method is?

Answer

dw_2.DataObject = dw_1.DataObject

dw_1.RowsCopy(1,dw_1.Rowcount(),Primary!,dw_2,1,Primary!)

dw_1.sharedata(dw_2)

dw_1.Object.Data = dw_2.Object.Data

Question: 407

How to get all the information that has been selected?

Answer

Object.DataWindow.Data

Object.DataWindow.Data

Object.DataWindow.Selected.Data

Object.Selected.Data

Question: 408

Execute the following SQL, which the result of execution is ?

Answer

NULL

3

1

2

Question: 409

PB. About LineRight PowerScript event, Which answer of below is correct?

Answer

Occurs before the user clicks in the right arrow of the horizontal scroll bar

Occurs when the user clicks in the right arrow of the horizontal scroll bar.

Occurs when the user clicks in the down arrow of the vertical scroll bar.

Occurs when the user dragging and move the horizontal track bar.

Question: 410

PB. Which answer of below is Functions for ListViewItem object?

Answer

GetParent

HasFocus

Label

Selected

Question: 411

PB. Shared variable, Which  the definition  of below is not correct?

Answer

Shared variables retain their value when an object is opened again.

Shared variables retain their value when an object is closed.

Shared variable belongs to an object definition.

Shared variables discard when the object is closed.

Question: 412

PB. About Long datatypes, Which the definition of below is correct?

Answer

Long Type:  32-bit signed integers, from -2147483648 to +2147483647.

Long Type:  16-bit signed integers, from -2147483648 to +2147483648.

Long Type:  16-bit signed integers, from -2147483648 to +2147483647.

Long Type:  32-bit signed integers, from -2147483648 to +2147483648.

Question: 413

PB. This script, what answer of below is correct? Match(sle_ID.Text, “^[A-Za-z]”)

Answer

This statement returns true if the text in sle_ID begins with one or more numbers.

This statement returns false if the text in sle_ID not begin “A”.

This statement returns false if the text in sle_ID begins with one or more uppercase or lowercase letters.

This statement returns true if the text in sle_ID begins with one or more uppercase or lowercase letters.

Question: 414

PB. MessageText event (DataWindows), Which  the return value  of below is correct?

Answer

-1

1

2

0

Question: 415

PB. About Case DataWindow expression function , Which  the return value  of below is correct?        

Answer

Returns 0 if an error occurs

Returns -1 if an error occurs

Returns the result you specify.

Returns 1 if it succeeds

Question: 416

PB. Which answer of below is Properties for ListView control?

Answer

Resize

Sort

DeleteItems

Text

Question: 418

PB. Close PowerScript event For the application object , Which  the return value  of below is correct?  

Answer

Returns 1 if it succeeds

Returns 0 if an error occurs

Have not return value

Question: 419

PB. Close PowerScript event For windows , Which  the return value  of below is correct?      

Answer

Have not return value

Returns 1 if it succeeds

Returns 0 if an error occurs

0  Continue processing

Question: 420

PB. ClearValues method (DataWindows), Which  the definition of below is correct?

Answer

Deletes all the items from a value list or code table associated with a DataWindow column and the data stored in the column.

Can not deletes the code table associated with a DataWindow column

Does not affect the data stored in the column.

will clear the data stored in the column.

Question: 421

PB. Which  answer  of below is hanges the background color of the DataWindow dw_cust to blue?        

Answer

dw_cust.Modify(“DataWindow.Color = 255”)

dw_cust.Modify(“DataWindow.Color = 16777215”)

dw_cust.Modify(“DataWindow.Color = 16711680”)

Question: 422

PB. Local variable, Which the definition of below is correct?

Answer

A local variable that is accessible only in the object which you define it.

A local variable that is accessible only in the script in which you define it.

A local variable that is accessible only in the application which you define it.

A local variable that is accessible only in the window which you define it.

Question: 424

PB. Clicked PowerScript event, Which  the return value  of below is correct?            

Answer

Returns -1 if an error occurs

Returns 1 if it succeeds

Have not return value

Question: 425

Which answer of below is Functions for GroupBox control?

Answer

TabOrder

Move

Constructor

Destructor

Question: 426

PB.Ex: dw_single have column comp_no and this scrip. Which answer of below is correct?  dw_single.Object.comp_no.Border = ‘1’ MessageBox(“Border”, &        String(dw_single.Object.comp_no.Border))

Answer

Null

1

Be error when compile

0

Question: 427

PB. In the window, when will the Activate PowerScript event occurs?

Answer

After refresh the window

After a new window Opened event

Occurs just before the window becomes active.

Before the window Open event.

Question: 428

PB. ImportFile method (DataWindows), when no rows or startrow value supplied is greater than the number of rows in the import file, Which  return value of below is correct?

Answer

-1

null

0

1

Question: 429

PB. Which answer Of below Is correct?

Integer i,j
For i = 1 To 3  
For j = 1 To 2        
MessageBox(”,i)    
Exit  
Next
Continue
Next

Answer

1

1->2->3

1->2

1->1->1

Question: 430

PB. Which answer of below is correct for ls_str?) String ls_str SELECT SUBSTR(‘abcdcba’, INSTR(‘abcdcba’,’c’)) INTO :ls_str FROM DUAL ; messagebox(‘tb’, ls_str)

Answer

c

cba

cdcba

Code be error

Question: 431

Which is not Function for RadioButton control?

Answer

Drag

SetFocus

Show

DragEnter

Question: 432

PB. This is display formats number , Which answer of below is correct?

Sample format:  0.00% , The values 5, -5, and .5

Answer

500%, -500% and 50%

50.00%, -50.00% and 5.00%

500.00%, -500.00% and 50.00%

5.00%, -5.00% and 0.50%

Question: 433

Which answer of below is Functions for Graph object?

Answer

Spacing

Series

RButtonDown

Show

Question: 434

In PowerBuilder,write several statements in one line,which sign  can add between the statesment?

Answer

&

;

:

,

Question: 435

In datawindow,which a non-defined buffer：

Answer

Primary Buffer

Delete Buffer

Filter Buffer

Insert Buffer

Question: 436

PB use Datawindow SaveAs function to export PDF,which software we should use?

Answer

Microsoft Office

OpenOffice

Adobe Reader

Ghostscript

Question: 437

IF AcceprText () function fails, which return value is correct ?

Answer

2

0

-1

1

Question: 438

Int a,b,i
SetNull(a)
b = 2
For i = 1 To 13
a ++
b = b + a
Next

Which Value Of variable b Is correct after excute below script?

Answer

NULL

2

0

15

Question: 439

int k
IF MessageBox(“xxx”,”xxx”,Question!,YesNo!, 2) = 4 THEN    
k = 1
ELSE    
k = 2
END IF 

If presses ‘Yes’ button，what is the variable k result?

Answer

2

1

0

Script error

Question: 440

Which function is  checkbox  controls in PowerBuilder  ?

Answer

Control actions

Display data

Indicate selection

Decoration

Question: 441

After executing the below PB script, What is the li_total value? 

Integer num,li_total = 4
for num = 1 to 3  
li_total = li_total^ 2
Next

Answer

0

65536

16384

32768

Question: 442

In Oracle，Which  one of sql syntax can get following result? testing ‘string’ for single-quotes

Answer

Select ‘testing ”string” for single-quotes’ from dual;

Select ‘testing \’|string\’ for single-quotes’ from dual;

Select ‘testing |’string|’ for single-quotes’ from dual;

Select ‘testing &|’string&’ for single-quotes’ from dual;

Question: 443

About PB Datawindow update () function, Which of the following correct?

Answer

Return 1 if an error occurs.

Returns 0 if it succeeds.

Event Execution order:UpdateStart -> Updateend–>SQLPreview

Event Execution order:UpdateStart–>SQLPreview -> Updateend

Question: 444

Which of the following method can be used in PowerScript for comment  multi-line  ?

Answer

*comments*

/*comments*/

//comments

–comments

Question: 445

In PowerBuilder, Which of the following is not a reserved words?

Answer

rollback

refe

readonly

return

Question: 446

About PowerBuilder operators，the execution order  from high to low, Which of the following is correct?  (1) ^ (2) NOT  (3) AND (4) >=

Answer

(4) –> (1) –> (2) –> (3)

(1) –> (4) –> (2) –> (3)

(3) –> (2) –> (1) –> (4)

(1) –> (3) –> (2) –> (4)

Question: 447

In PowerBuilder，which of the following is not a function to provide for checking variables?

Answer

IsString()

IsNull()

IsDate()

IsNumber()

Question: 448

In PowerBuilder，which of the following is not a Window event provided?

Answer

closequery

help

clicked

ue_open

Question: 449

In PowerBuilder，Datawindow connects with DataBase，what is SQLCode return Possible values ?

Answer

100

-1

0

1

Question: 450

Which of the following answer is correct ,about export PowerBuilder objects of file extension?

Answer

(Application):*.srp

(DataWindow):*.srdw

(Function):*.src

(Window):*.srw

Question: 451

When we close the window，which one of event will be executed first in the window?

Answer

Show Event

Activate Event

CloseQuery Event

Close Event

Question: 452

What is the correct describe about the Update method in the script shown below?

(A) The update resets the status flags but does not perform AcceptText before updating the database.
(B) The update performs AcceptText but does not reset the status flags before updating the database.
(C) The update performs AcceptText and also resets the status flags before updating the database.
(D) The update neither performs AcceptText nor resets the status flags before updating the database. 

code example: 

CONNECT USING SQLCA;
dw_employee.SetTransObject(SQLCA) … // Some processing dw_1.Update()

Answer

D

B

A

C

Question: 453

To “reject the data value and do not allow focus to change” when a field value does not pass the validation. How to set the return code to affect the outcome of the Itemchange event?

Answer

Return 2

Return -1

Return 0

Return 1

Question: 454

To “reject the data value but allow the focus to change” when a field value does not pass the validation. How to set the return code to affect the outcome of the Itemchange event?

Answer

Return 2

Return -1

Return 0

Return 1

Question: 455

Regardless the arguments, how to open a sheet within an MDI (multiple document interface) frame window?

Answer

OpenSheets()

OpenSheet()

Open()

OpenWindow()

Question: 456

Suppose there are three rows in Primary buffer of dw_1 which dep_id in (10,  20,  30). Which will be the display of data of dw_1.filter() in the example below ? 

String ls_string
ls_string = “dep_id = 10 ”
dw_1.setfilter(ls_string)
dw_1.filter()

Answer

dep_id in (20,30)

dep_id = 30

dep_id = 10

dep_id = 20

Question: 457

Which is the method of comments you can use in Powerbuilder ?

Answer

\\

—

**

//

Question: 458

If the specified control in the DataWindow is visible, which is the set value of the visible DataWindow object property ?

Answer

2

-1

0

1

Question: 459

Which will change database data in the following options?

Answer

None of the above

AcceptText()

DeleteRow()

SetItem()

Question: 460

In ItemError event (DataWindows), to reject the data value with no message box, how to set the return code?

Answer

2

1

0

-1

Question: 461

Although you typically put one statement on each line, you occasionally need to continue a statement to more than one line. What is the statement continuation character?

Answer

@

&

+

||

Question: 462

What is the extension name of PowerBuilder workspace file?

Answer

.pbd

.pbl

.lib

.pbw

Question: 463

In PowerBuilder, there is a variable a. What is correct below to test whether a is null or not?

Answer

a = NULL

a IsNULL

IsNull(a)

IfNull(a)

Question: 464

What is the default Transaction object in PowerBuilder?

Answer

SQLTRANS

itrans

SQLERRM

SQLCA

Question: 465

What is the way a user cannot change a column value ?

Answer

Protect is 1

TabSequence is 0

Edit.DisplayOnly is checked when the column has the Edit edit style

All of the above

Question: 466

Which description about the code table in Powerbuilder is right?

Answer

The data values are those the user sees and stored in the database.

The display values are those the user sees.

The display values are those that are stored in the database.

All of the above

Question: 467

When data is retrieved, the status flag of all rows and colunms will be ?

Answer

DataModified!

NewModified!

New!

NotModified!

Question: 468

In Powerbuilder declare instance variables, there are 4 types of variables. What is the correct order of the scope they can affect?

Answer

(D)Global > Shared > Local > Instance

(C)Global > Instance > Shared > Local

(A)Global > Instance > Local > Shared

(B)Global > Shared > Instance > Local

Question: 469

Which of following Functions can not supported by DataStore?

Answer

Sort

ScrollToRow

GetItemString

RowsCopy

Question: 470

If Table A ( 3 row) and Table B ( 4 row),  executing select * from a, b;     How many rows after querying.?

Answer

12

7

3

4

Question: 471

Use UPDATEBLOB to modify BLOB Data in PB, how to correctly judge is successful or not ?

Answer

SQLCODE > 0

SQLCODE = 0

SQLNRows = 0

SQLNRows > 0

Question: 472

In Pb,when the window is opened. The following events:open、activate、show, which execution order is correct ?

Answer

show–>open–>activate

show–>activate–>open

open–>activate–>show

activate–>open–>show

Question: 473

pbm_dwnmbuttondbclk event,what circumstances would trigger?

Answer

Double click the mid mouse button

The mid mouse button is pressed

The left mouse button is pressed

The left mouse button is released

Question: 474

Which is synonymous with the current object?

Answer

Super

This

Parent

ParentWindow

Question: 475

Long A,B,C,D
B = 2
D = 13
For A = 1 To B
A ++
D ++
For C = 1 To D
C = C + 2
B ++
If B > 10 Then Exit
Next
Next

In PowerScript,which answer are A,B,C,D Value?

Answer

A = 17 ,B = 16 ,C = 16 ,D = 22

A = 21 ,B = 20 ,C =   3 ,D = 23

A = 19 ,B = 18 ,C =   3 ,D = 22

A = 21 ,B = 20 ,C = 16 ,D = 24

Question: 476

Which of the following description about ShareData Method are correct ?

Answer

ShareData can’t be used for the “Crosstab DataWindow”.

The main window and secondary window columns’s sort  could be not the same.

The main window and secondary window must have the same number of columns.

“SetFilter” method can be used for the secondary window.

Question: 477

PowerBuilder’s window could be formed by what?

Answer

event

control object

properties

funtion

Question: 478

In Below power builder program which line number’s code is error? 

1  integer i
2  string ls_mat_no
3  datastore lds_datastore
4 
5  lds_datastore = create datastore
6  lds_datastore.dataobject = ‘d_matm’
7  lds_datastore.settransobject(SQLCA) 
8  lds_datastore.retrieve()
9  for i = 1 to lds_datastore.rowcount()
10       ls_mat_no = lds_datastore.getitemstring(i,’mat_no’)
11       select mat_nm from matm where mat_no = :ls_mat_no ;
12       lds_datastore.setfocus()
13      lds_datastore.setitem(i,’unit’,’KG’)
14 next

Answer

13

12

9

11

Question: 479

In Datawindow’s various presentation style,which of the following presentaion styles can display report only?

Answer

OLE2.0

Graph

Label

Composite

Crosstab

Question: 480

In PowerBuilder, which Function can get data from primary buffer ? 

Answer

GetItemTime()

GetItemInteger()

GetItemDate()

GetItemString()

GetItemLong()

Question: 481

Which are probably return values in ItemChanged Event?

Answer

3

2

0

1

Question: 482

Which Windows type can use CloseWithReturn ?

Answer

response!

popup!

Child!

main!

Question: 483

Which are correct answers about messagebox?

Answer

When both title and text’s value is null then a blank messagebox is displayed.

It could change to another application when messagebox is displayed.

if title’s value is null then messagebox don’t be displayed.

if text’s value is null then messagebox don’t  be displayed.

Question: 484

What answers about PowerBuilder’s function POS of below is correct?

Answer

Pos(“SKY TREE”, “R”) = 6

Pos(“NEW WORK”, “EW”,5) = 2

Pos(“BABE RUTH”, “RU”) = 6

Pos(“HELLO WORLD”, “or”) = 7

Question: 485

String ls_val1, ls_val2 = ‘2’ 
SELECT DECODE(:ls_val1, NULL, ‘1’, ‘2’, ‘3’, ‘4’) INTO :ls_val2 FROM DUAL;
MessageBox(”, ls_val2) 

After executing the below PB script, what’s the value which MessageBox show?

Answer

4

3

1

2

Question: 486

Int li_array[10], li_n

For li_n = 1 To 5
li_array[li_n] = li_n
Next
MessageBox(”, UpperBound(li_array))

What’s the value in the MessageBox?

Answer

10

5

0

1

Question: 487

Which bands exists in a DataWindow Object?

Answer

Detail

Header

Summary

Page

Question: 488

wf_add(String as_val)
return string{    return string(as_val+’42’) }

After PB executes wf_add(‘420’), what it will return?

Answer

Compliation fails

42042

42

462

Question: 489

In PowerBuilder, how does we know datawindow connect with database successfully ?

Answer

SQLCA.SQLCode = 100

SQLCA.SQLCode = 0

SQLCA.SQLCode = -1

SQLCA.SQLCode = 1

Question: 490

Which function PB DataStore can’t use?

Answer

filter

setfocus

GetItemString

RowsCopy

Question: 491

______ abc

string ls_val
int li_val 
abc = ls_val
abc = li_val 

Please fill in correct ______, make PB save without erros.

Answer

double

any

all

string

Question: 492

Long ll_find
ll_find = MessageBox(“Title”, “Test”, Question!, YesNoCancel!, 3)  

What’s the value of ll_find after clicking “Yes” button in the MessageBox.

Answer

3

2

0

1

Question: 493

Which words are power builder’s reserved words?

Answer

ASC

disconnect

dynamic

delete

choose

Question: 494

Which files type can use 「importfile」to import file to datawindow ?

Answer

EXCEL!

CSV!

Text!

XML!

Question: 495

Compare to SingleLine Edit ,what are the benefits that use external datawindow to input data ?

Answer

Maintain program more easy

Can use Code table

Program’s Performance will increase

Input data can use Validation Rule

Question: 496

Long i,a
dw_1.Reset()
For i = 1 To 3
dw_1.InsertRow(0)
Next
dw_1.DeleteRow(3)
a = dw_1.RowCount() + dw_1.DeletedCount()  + dw_1.ModifiedCount()

a = ?

Answer

5

4

2

3

Question: 497

If Oracle Database version 10g up does not modify any argument(Default) and execute group by clause：

Answer

It doesn’t sort anything!

It will accroding group by cloumns ascending the retrieve data but not exactly.

It will accroding group by cloumns exactly ascending the retrieve data.

It will accroding group by cloumns exactly descending the retrieve data.

Question: 498

Which PowerBuilder Category Table describe is wrong?

Answer

pbcatvld record Validation Rule.

pbcatfmt record column’s format.

pbcatedt record Edit Mask.

pbcattbl record Table’s property.

pbcatcol record column’s Extended Attribute.

Question: 499

Which PB buffer can not use DataWindow methods to modify data?

Answer

Filter!

Original!

Primary!

Delete!

Question: 500

long a  a = DaysAfter(2002-12-24, 2002-12-20)  a = ?

Answer

-4

4

0

-1