Multiple-Choice Questions About Powerbuilder Part 8

Question: 701

ll_find = MessageBox(“hello”,”hello” , question!,yesnocancel!,3)        
After executing the above PowerScript and clicking the cancel button, what is the value of ll_find?

Answer

3

2

0

1

Question: 702

String A,B
If IsNull(A) Then
B = ‘1’
ElseIf A = ” Then
B = ‘2’
ElseIf A = ‘ ‘ Then
B = ‘3’
Else
B = ‘4’
End If

Value B = ?

Answer

4

3

1

2

Question: 703

int li_random li_random = rand(10) Why is li_random impossible?

Answer

10

9

0

5

Question: 704

When executing DataWindow’s Retrieve, I don’t want the data to be reset and then retrieved. Which of the following Event Return 2 can be used to achieve the goal?

Answer

RetrieveStart

RetrieveRow

Retrieve

RetrieveEnd

Question: 705

 wf_add(integer ai_val) returns string{ return String(ai_val + 2)  }  
 wf_add(string as_val) returns string{  return String(Integer(as_val) * 2) }
 
 What value will be returned if wf_add(‘5’) is executed?

Answer

‘7’

’10’

‘0’

Runtime Error

Question: 706

ASC(‘A’)+Len(‘pou chen’)-Integer(24.543)=?

Answer

98

49

47

48

Question: 707

Event ue_sum(ref Integer li_n1, Integer li_n2) return (None) { li_n1 +=  li_n2 } 
Function wf_show()
return Integer{
Int li_n1 = 3, li_n2 = 9
this.Event Post ue_sum(li_n1, li_n2)
MessageBox(‘’, li_n1)   
Return 1 }  

What will the MessageBox display after wf_show() is executed?

Answer

3

6

9

12

Question: 708

In Powerbuilder, there are 4 different ranges of variables, the scope of action is only within the event and the function Any of the following types of variables that do not work in other events and functions ?

Answer

local 

global 

shared

instance

Question: 709

Which of the following types of windows must have a menu bar ?

Answer

Multi document window

Multi document window

main window

popup window

Question: 710

When you create a data window, you can choose the data source that is not directly connected to the database.（）

Answer

External data source

Storeprocedure data source  

quick select data source

Query data source

Question: 711

When datawindow performs the retrieve () function, which is the right sequential ?order of the following events ？

Answer

retrieverow()->retrievestart()->retrievend()

retrievestart()->retrievend()->retrieverow()

retrievestart()->retrieverow()->retrievend()

retrieverow()->retrievend()->retrievestart()

Question: 712

IF SQLCA.SQLCode = -1  meaing what?

Answer

Fetched more than one row data

Error; the statement failed

Success

Fetched row not found

Question: 713

Which of the following option is editable in ?DropDownListBox and DropDownListDW?

Answer

Sorted

Required

Allow Editing

Empty String is NULL

Question: 714

Which of the following option is setting whether generate SQL statements for the Update() function?

Answer

Updateable Columns

Where Clause for Update/Delete

Allow Updates

Table to Update

Question: 715

Which of the following statement is used to terminate the event handler, the control returns to the user?

Answer

continue

exit

return

halt

Question: 716

The following events which do not belong to the menu?

Answer

help

selected

clicked

itemchanged

Question: 717

Boolean lb_1 = True
Boolean lb_2 = True
Boolean lb_3 = False
Int i
MessageBox(”,String(lb_3))
If (lb_1 Or lb_2 And lb_3) = True Then
i = 100
ElseIf (lb_1 Or lb_2 And lb_3) = False Then
i = 200
End If;

What Is the Value Of i?

Answer

1

100

0

Question: 718

There’s 5 rows in dw_1.

Int li_n, li_cnt
For li_n = 1 To dw_1.RowCount() Step 2
dw_1.DeleteRow(li_n)
Next
li_cnt = dw_1.RowCount()

After executing Upper script, what’s the value of li_cnt?

Answer

3

2

0

1

Question: 719

Sometimes you need to perform additional external program (for example: execution * .bat or open a notepad, etc.), when to execute an external program, which system provides the functions to use?

Answer

Active()

Run()

EXECUTE()

Goto()

Question: 720

SQLCode return value (Value) on behalf of meaning  , correct Why?

Answer

Return -1 indicates that the database connection failed (Error)

Passback 100 represents the database connection does not respond or can not be found (Fetched row not found)

Return 0 represents the database connection is successful (Success)

2 represents a return database connection ID or password error (Error UserName or Password).

Question: 721

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

Answer

20

0

10

5

Question: 722

What all functions you can not call in itemchange event because it will go in indefinite loop ?

Answer

GetSelectedRow()

GetItemString()

SetRow()

SetColumn()

Question: 723

Give a Datawindow(DW_1) have three column ( fact_no,Dept_no, Pnl_no).To prevent user change any data in datawindow , what script will be use ?

Answer

None of all answers

Dw_1.object.datawindow.readonly=”yes”

Dw_1.SetTabOrder(fact_no,0)

Dw_1.Object.dept_no.Tabsequence=0

Question: 724

Which function is used to change a validation rule in DataWindow at runtime?

Answer

SetFormat ()

SetFullState()

Setvalue()

SetValidate()

Question: 725

Which option is used to clear all the data from datawindow?

Answer

dw_1.Reverse()

dw_1.Retrieve()

dw_1.Return()

dw_1.Reset()

Question: 726

About powerbuilder function sleep(1) , which option is correct?

Answer

pause the application for 1 hour

pause the application for  1 minute

pause the application for 1 second

pause the application for 1 day

Question: 727

Which statement mean s window(w_1) is closed?

Answer

isclose(w_1) = true

Isopen(w_1) = false

IsValid(w_1) = FALSE

IsValid(w_1) = TRUE

Question: 728

Which of the following functions will repeatedly trigger the timer of the specified window within the specified time interval?

Answer

Timer()

Idle()

Yield()

Cpu()

Question: 729

How to get the SQL statement of the current datawindow dw_1?

Answer

dw_1.SetSQLSelect()

dw_1.Describe(“DataWindow.Table.Select”)

dw_1.syntaxFromSQL()

dw_1.Object.DataWindow.Table.Select

Question: 730

Which of following Events will be executed at open Window Object？

Answer

Deactivate Event

Resize Event

Activate Event

Open Event

Timer Event

Question: 731

Run this powerscript code,the messagebox will be show what message? 

string lsData, lsCode

lsCode = ‘A’

setnull(lsData)

select decode( to_number(:lsCode), ‘A’, ‘ans1’,65, ‘ans2’) into :lsData from dual; messagebox(”,lsData) 

Answer

not show any message

null

ans1

ans2

Question: 732

which Options are category of datawindow ?

Answer

Graph

Table

Freeform

Tabular

Question: 733

About datawindow category , which options not only can be Report form but also can be maintained?

Answer

Tabular

Freeform

Label

Graph

Question: 734

About powerbuilder function ” GetFileSaveName ( a, b, c {, d {, filter { , initdir { , aFlag } } } } )” ,  which option represents the title of the dialog box?

Answer

d

c

a

b

Question: 735

String ls_array[] ls_array[1] = ‘hello’
Try
If ls_array[2] = ‘hello’ Then
MessageBox(“a”,”a”) //messagebox(1)     
End If
Catch(runtimeerror e)
MessageBox(“b”,”b”) //messagebox(2)
End Try

Which statements Of MessageBox would be executed?

Answer

All

None

messagebox(1)

messagebox(2)

Question: 736

If string ls_size_a =’L20-‘ and string  ls_size_b = Mid( ls_size_a,2, Len( ls_size_a) ) , about  string  ls_size_b , which option is true?

Answer

ls_size_b = 0-

ls_size_b = L20

ls_size_b = 20

ls_size_b = 20-

Question: 737

Which of following Control or Object can not be supported by ShareData Method？

Answer

DataWindow control

ListBox control

DataStore object

DataWindowChild object

Question: 738

Which one of the following options changes the display format of an EditMask control?

Answer

GENGRAL

MASK

OTHER

TOOBAR

Question: 739

Which of the following types of Windows can be processed by the first to carry out other actions?

Answer

popup!

response!

Child!

main!

Question: 740

Which of the following is a PowerBuilder provides a convenient way, you can be in the same database, different databases and even heterogeneous databases quickly copy data.

Answer

XML Template

Crosstab Report

Data Pipeline

Share Data

Question: 741

If there is no data found when we execute SQL query statement in powerbuilder,what is the return value of sqlcode?

Answer

100

-1

0

1

Question: 742

Please indicate which of the following objects can not be inherited in PB？

Answer

User Object

Non Window Function

Window

Menu

Question: 743

When you open a window in an application, the sequence of events, open, activate, and show, is that?

Answer

show->activate->open

activate->open–>show

show->open->activate 

open->activate->show

Question: 744

Filter () function to filter, which of the following can be used to set the filter conditions?  

Answer

ddescribe()

Where  clause  

setsort()

setfilter()

Question: 745

In PB,which is the script have error when compile?

Answer

w_preview.dw_1.Retrieve(NULL)

w_preview.dw_1.Retrieve(“NULL”)

w_preview.dw_1.Retrieve(‘            ‘)

w_preview.dw_1.Retrieve(‘NULL’)

Question: 746

In a DataWindow control, if the user clicks on a row other than the current row, which event should be used to determine both the current row and the new row?

Answer

ItemFocusChanged

RowFocusChanging

RowChanged

ItemChanged

Question: 747

Which is workspace’s filename extension?

Answer

pbw

pbd

pbl

pbt

Question: 748

Which of the following column format will display 0 if the column value is 0?

Answer

###0

!!!!!

####

aaaa

Question: 749

Which one of the following DataWindow styles column control does not have Protect properties under General tab in the DataWindow painter? 

Answer

Grid

FreeForm

Crosstab

Tabular

Question: 750

If user wants to let the button(cb_1)  hidden, which statement is true?

Answer

cb_1.enabled = false

cb_1.enabled = true

cb_1.visible = true

cb_1.visible = false

Question: 751

How to clear an array in the PB code?

Answer

String ls_arr1[],ls_arr2[] ls_arr1[1] = ‘1’ ls_arr1 = ls_arr2

String ls_arr1[] ls_arr1[1] = ‘1’ SetNull(ls_arr1)

String ls_arr1[] String ls_null SetNull(ls_null)  ls_arr1[1] = ‘1’ ls_arr[1] = ls_null

Question: 752

There are three report pages. The column data displayed at the bottom of every page , which  datawindow Band we can use ?

Answer

Summary

Footer

Detail

Group trail

Question: 753

In the Event in the Datawindow, may I ask the following ____ to fill in what If judgement to compile normally? If as_fact_no = this.GetItemString(this.GetRow(), ‘fact_no’) And ____    as_user_id =  this.GetItemString(this.GetRow(), ‘user_id’)  Then     …. End If

Answer

&

&&

blank

$

Question: 754

String ls_emp_name

ls_emp_name = dw_1.GetItemString(5, ’emp_name’, Filter!, FALSE)  

This Statement can be rewritten into the following paragraph?

Answer

ls_emp_name = dw_1.Object.emp_name.Filter.Current[5]

ls_emp_name = dw_1.Object.emp_name.Filter.Original[5]

ls_emp_name = dw_1.Object.emp_name[5]

ls_emp_name = dw_1.Object.emp_name.Original[5]

Question: 755

Long a,ll_array[3,3] = {1,2,3,4,5,6,7,8}
a = ll_array[2,3] + ll_array[1,2]

value a=?

Answer

10

13

8

12

Filter

Question: 756

After executing the following PB script and clicking cancel button , what is the ll_find ？  
ll_find = MessageBox(“hello”,”hello” , question!,yesnocancel!,3)

Answer

3

1

0

2

Question: 757

The following ShareData () function described ,which of the following is wrong?

Answer

can be used for the master and details share

change any DataWindow, all windows will then synchronize changes

The DataWindow Buffer to share other data window

the same of data can be show to users in different styles

Question: 758

Using PowerBuilder to develop a hospital outpatient management system,  which target (Target) is Thospital, work space (Workspace) is  Whospital,  the login window (window) is w_login, application objects (Application) is Ahospital,  logical sequence should be which one ?

Answer

Thospital -> Whospital-> w_login -> Ahospital?

Whospital -> Thospital -> Ahospital -> w_login

w_login-> Whospital -> Thospital -> Ahospital?

Ahospital -> w_login -> Thospital-> Whospital

Question: 759

Use group box not only for its decorative effect, but also can achieve Grouping effect , what is the controls?

Answer

Picture Hyperlinks

Command button

radio button

checkbox

Question: 760

Which of the following windows displays in the uppermost layer?

Answer

Response

Child

Mdi

Popup

Question: 761

In powerbuilder , a = Pos(“BABE RUTH”, “RU”) , which option is correct?

Answer

a = BABE TH

a= RU

a =5

a = 6

Question: 762

about powerbuilder function Mod(x,y),which option is true?

Answer

Mod(10,5)=2

Mod(25, 4.5) = 2.5

Mod(20, 6) = 4

Mod(25.5, 4) = 6

Question: 763

About dynamically modify the color of the font in the static text box in the script , which option is correct ?

Answer

st_1.textcolor=rgb(12345)

st_1.textcolor=12345

st_1.textcolor= (255,255,0) 

st_1.text=rgb(255,255.0)

Question: 764

If we want to let checkbox(cb_1) be checked , which program is correct?

Answer

cb_1.checked = true

cb_1.ischeck()

cb_1.ischeck = true

cb_1.check()

Question: 765

about returning the number of the current row in dw_Employee,which option is true

Answer

dw_employee.rowcount()

dw_employee.GetRow()

dw_employee.GetRow

dw_employee.rowcount()

Question: 766

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

Answer

GetEnvironment()

ChooseColor()

Open()

TriggerEvent()

Question: 767

Want to delete a table that you no longer use, select the following SQL Language processing.

Answer

delete table

clear table

close table

drop table

Question: 768

The role of the button delete data window control dw_1 display the contents of the current row, then clicked event code should be which.

Answer

Dw_1.deleterow()

Dw_1.deleterow(0)

Dw_1.deleterow(getrow())

Dw_1.deleterow(thisrow())

Question: 769

The following function, which can change the Row?

Answer

GetClickdRow()

ScrollToRow()

SelectRow

SetColumn()

SetRow()

GetRow()

Question: 770

What kind of DataWindowPainter of the DataSource to use a relational database?

Answer

External

Query

SelectRow

Quick Select

Stored Procedure

Question: 771

On the processing of the print job, choose the correct.

Answer

Printlose (jobid) to cancel a particular print job.

PrintClose (jobid) the termination of a particular print job.

PrintDataWindow (dw_control, jobID) the DataWindow buffer content reached the current printer.

PrintSetup () can be used to open the Print Setup dialog box.

Question: 772

The following discussion about the the PB function or event parameters passed Right

Answer

Value passed parameters, whose values can be modified in the function or Event

ReadOnly pass the parameter and its value in the function or event can not be Modified

Reference to pass parameters, whose values can be modified in the function or Event

Reference to pass the parameter and its value in the function or event can not be modified

Question: 773

The following discussion of the PB function is

Answer

in PB by insert Row() functions (methods) to current data window dw_1 into a new blank line

Delete Row () function (method) to delete the specified line in the current data window

by save change () functions (methods) to save the data window updates

Adoption of Get Row () function to get the line number of the cursor in the current data window.

Question: 774

The following discussion of the database opened right

Answer

index is the logical ordering of the data in the table in the database, create the index of the column can be a column, it can be a combination of multiple columns.

foreign key role is to check the data, to avoid data inconsistencies.

primary key is a column or combination of columns that uniquely identifies a record of two rows in the table can not be the same primary key value.

The storage process is written by the process control and SQL statements, compile and optimize stored in the database server, use can not be adjusted.

Question: 775

The following discussion of the PB function is

Answer

Using UNION to combine the results of two queries set two basic rules: all queries in the number of columns and the order of the columns must be the same; different data types.

index (Index) is a separate, physical structure of the database. It is a correspondence table according to one column or several columns in the table, the column value between rows in a certain order to create the

queries with ORDER BY sort ASC and DESC

Use keywords EXISTS (or NOT EXISTS) the introduction of a sub-query is equivalent to the existence test once. Subquery produce the query result set.

Question: 776

When does the ItemChanged event be triggered in Window control?

Answer

When a column in the data window been modified and loses focus before trigger

When a column in the data window is not modified and loses focus before trigger

When a column in the data window loses focus after trigger

When a column in the data window loses focus before trigger