Multiple-Choice Questions About Powerbuilder Part 6

Question: 501

Which PB command can exit the current loop?

Answer

exit

break

continue

stop

Question: 502

Which Powerbuilder variable type can receive oracle sysdate?

Answer

String

Time

Datetime

Date

Question: 503

Which is the answer of the program?  string ls_a[]  messagebox(”,upperbound(ls_a)) messagebox(”,lowerbound(ls_a))

Answer

Both messageboxes display blank.

0 0

0 1

1 1

Question: 504

Int a = 0,b = 10
Do While(a < 5)
b = b – 1
a++
Loop
MessageBox(“result”,String(a) + “,” + String(b))

What Is the result?

Answer

6,6

6,5

5,6

5,5

Question: 505

String ls_a = ”
If  IsNull(ls_a) Then
MessageBox(‘1′,’NULL’)
Else
Len(Trim(ls_a)) = 0
Then
MessageBox(‘2′,’ZERO’)
Else
MessageBox(‘3′,’SOME’)
End If

What Is the result?

Answer

compilation fails

SOME

NULL

ZERO

Question: 506

Integer A,B,C A=(7/2)*2 B=Mod((2^4),5) C=A+B*10 What is the value of C?

Answer

16

17

38

80

Question: 507

String ls_msg=’Hello world’
Long  ll_pos
ll_pos = pos(ls_msg,’world’)
ls_msg = Trim(Mid(ls_msg,ll_pos))
Messagebox(‘Result’,ls_msg)

What is the result?

Answer

compilation fails

world

Hello world

Hello

Question: 508

Which one is the default return code of ItemError event?

Answer

return 3

return 2

return 0

return 1

Question: 509

long a = len(LeftTrim(” BABE RUTH “))
long b = len(RightTrim(” BABE RUTH “))
long c = len(Trim(” BABE RUTH “))

Which answer is right ?

Answer

c < b = a

c > b > a

a = b =c

a > b > c

Question: 510

Which of the following function execute ,will sent SQL script to influence  DB’s data currently ?

Answer

dw_1.update()

dw_1.insertrow()

dw_1.reset()

dw_1.delete()

Question: 511

Long ll_i,ll_cnt
For ll_i = 1 To 10  Step  3
ll_cnt ++
Next

After executing the below PB script , what’s the value of ll_cnt?

Answer

2

3

4

5

Question: 512

We declare a instance variables as below ______ int li_val = 1 If we write li_val = 2 in PB, then save it with error, ______ should be which one?

Answer

protected

private

constant

public

Question: 513

Which one is correct up-down hierarchy in PB?

Answer

Workspace > PBL > Target > PB Object

Workspace > Target > PBL > PB Object

Target > PBL > PB Object > Workspace

Target > Workspace > PBL > PB Object

Question: 514

String ls_msg = ‘Hello~tIron~nMan’
MessageBox(”, ls_msg)

What the MessageBox shows?

Answer

Hello   Iron   Man

Hello    Iron   Man

Hello   Iron Man

Hello   Iron Man

Question: 515

ls_emp_name = dw_1.GetItemString(3, ‘emp_name’, Primary!, True)  we could rewrite below PB script to which one?

Answer

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

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

ls_emp_name = dw_1.Object.emp_name[3]

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

Question: 516

After Run below power builder program what result will display?

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

Answer

1 –> 2 –> 3

1 –> 1 –> 1

1

1 –> 2

Question: 517

In below statements which are correct about power builder function FileRead ?

Answer

FileRead returns the number of bytes read.

FileRead do not support stream mode.

FileRead do not support text mode.

FileRead only can read a maximum of 32,765 bytes at a time.

Question: 518

There is a profile,it’s content like below:  [Pb] Maximized=1 [security] Class=7  What is the values of variable ls_max_str and ls_max_int about below script? 

string ls_max_str
integer li_max_int 
ls_max_str = Profilestring(“PROFILE.INI”, “PB”, “maximized”,”3″)
li_max_int = ProfileInt(“PROFILE.INI”, “PB”, “maximized”,3)

Answer

ls_max_str=”1″ li_max_int=-1

ls_max_str=”3″ li_max_int=1

ls_max_str=””” li_max_int=1

ls_max_str=”1″ li_max_int=1

Question: 519

About Below Powerbuilder function，What result is right?  Mid(“BABE RUTH”, 40, 5)

Answer

” RUTH”

“BABE “

“BABE RUTH”

empty string “””

Question: 520

What transaction will be used in below powerbuilder script’s select clause?(Assume connect information is correct!) 

Transaction SQLTMP,SQLCON 
SQLTMP.DBMS = “O10 Oracle10g (10.1.0)”
SQLTMP.LogPass = “TIGER”
SQLTMP.ServerName = “ORACLE_CONN”
SQLTMP.LogId = “SCOTT”
SQLTMP.AutoCommit = False
SQLTMP.DBParm = “PBCatalogOwner=’SCOTT'” 

SELECT EMP_NO FROM EMP USING SQLTMP ;

Answer

No transaction will be userd.

SQLCON

SQLCA

SQLTMP

Question: 521

What Is ls_a And ls_b’s value in below powerbuilder script?

String ls_test,ls_a,ls_b
If IsNull(ls_test) Then
ls_a = ‘Y’
Else
ls_a = ‘N’
End If
SetNull(ls_test)
If IsNull(ls_test) Then
ls_b = ‘Y’
Else
ls_b = ‘N’
End If

Answer

ls_a = ‘Y’ ls_b = ‘Y’

ls_a = ‘Y’ ls_b = ‘N’

ls_a = ‘N’ ls_b = ‘N’

ls_a = ‘N’ ls_b = ‘Y’

Question: 522

In powerbuilder’s datawindow,which datasource is not from database?

Answer

Stored Procedure

External

Quick Select

SQL Select

Question: 523

About powerbuilder sharedata method which are right?

Answer

You cannot use ShareData with a Crosstab DataWindow as the primary or secondary DataWindow.

Secondary datawindow can add computed field by itself and primary datawindow do not need to add the same computed field.

Primary datawindow and Secondary datawindow’s column must be the same.

Primary datawindow and Secondary datawindow’s SQL WHERE clause must be the same.

Question: 524

int a,b a = 0 b = 10  In PowerScript,Which formulas are equal to (a – = b + 4)?

Answer

a = (b+4)-a

a = a – (b+4)

a = 1/(b+4)

a =- (b+4)

Question: 525

Which  PB’s variable declaration are wrong ?

Answer

S123_%~NBA

S123_%NBA

123_NBA

%123_NBA

UpdateStart

Question: 526

PB. Which the definition of below is not correct for Hide method (DataWindows)?

Answer

Makes an object or control invisible. Users can interact with them.

Makes an object or control visible. Users cannot interact with an invisible object.

Makes an object or control invisible. Users cannot interact with an invisible object.

Makes an object or control visible. Users can interact with an visible object.

Question: 527

PB.This script. Which answer of below is correct?  SQLCA.DBParm = “CommitOnDisconnect=’No'”

Answer

Disconnect from the database

Roll back uncommitted database updates

Be error when compile

Automatically committing them when you disconnect from the database

Question: 528

PB. This script, Which answer of below is correct?  SQLCA.SQLCODE = -1

Answer

Valid, non-null value

Conversion error

Invalid, not null value

Null value

Question: 529

PB.Ex: The datawindow have column as_depts. Which answer of below be error when combile?

Answer

this.SetItem(0, ‘as_depts’, ”)                               this.SetColumn(‘as_depts’)

this.SetItem(this.CurrentRow(), ‘as_depts’, ”)            this.SetColumn(‘as_depts’)

this.SetItem(1, ‘as_depts’, ”)                                this.SetColumn(‘as_depts’)

this.SetItem(this.GetRow(), ‘as_depts’, ”)            this.SetColumn(‘as_depts’)

Question: 530

PB. Which the definition of below is not correct for GetChild method (DataWindows)?

Answer

When you insert a row or retrieve data in the main DataWindow, PowerBuilder automatically retrieves data for the child DataWindow.

A child DataWindow is a DropDownDataWindow in a DataWindow object.

Provides a reference to a child DataWindow or to a report in a tabular DataWindow.

Use GetChild when you need to explicitly retrieve data for a child DataWindow or report.

Question: 531

PB. Which the following properties is not use for OpenTabWithParm?

Answer

message.StringParm

message.PowerObjectParm

message.DoubleParm

message.NumberParm

Question: 532

PB. Which answer of below is not correct for GetText method (DataWindows) when return value?

Answer

Returns the empty string (“””) if no accepted into the column.

The value might or might not have been accepted into the row and column

Returns the empty string (“””) if no column is currently selected in  dwcontrol.

If dwcontrol is NULL, in PowerBuilder and JavaScript the method returns NULL.

Question: 533

PB. Which the definition of below is correct for global function?

Answer

A user-defined function that is not associated with any object in the application and is always accessible anywhere in the window

A user-defined function that is associated with any object in the application and is always accessible anywhere in the application

A user-defined function that is not associated with any object in the application and is always accessible anywhere in the application

Global functions correspond to the PowerBuilder built-in functions that are must associated with an object, such as the mathematical and string-handling functions.

Question: 534

PB. Which answer of below is correct for ImportFile PowerScript function when return value?

Answer

-1

Null

0

1

Question: 535

This script. Which answer of below is correct?   select INSTR (‘a/x/y/z’, ‘/’, -1) + SUBSTR (‘0002axyz’, 1, 5 – 1) from dual

Answer

11

0

6

8

Question: 536

What’s it the following PB script? 

Declare dc_sel dynamic cursor for SQLCA;
Prepare SQLCA from “select count(*) from dept where dept_no in (‘SA’,’SB’,’SC’)”;

Answer

For storage input and output parameter

For storage dynamic SQL statement

for connect database

Just a user defined name

Question: 537

Which of the following description is true?

Answer

when you disable MenuItem,User can not click on the associated tool bar icon

Stored procedures can’t be used as a data source to a Pipeline.

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

Once a FOR LOOP is started, it must run to completion

Question: 538

Which of the following description is true?

Answer

Variables declared in the Application Object are local to the event in which the variable is declared

Variables declared in the Application Object are global by default

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

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

Question: 539

Related SaveAs method of Datawindow,What file types support encoding parameter EncodingUTF8 and EncodingUTF16LE ?

Answer

CSV!

Excel5

TEXT!

HTMLTABLE!

Question: 540

Related to Event and Function ,what statements are true ?

Answer

Events can return a value or do not return value.

Event can be Overloaded

We can POST or TRIGGER an Event call.

Function can declare Public, Private and Protected Access Level

Question: 541

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

Answer

Child

Response

Main

Popup

Question: 542

What are the strongest points of using the DataWindow control?

Answer

Update database

Reporting

Displaying data

Manipulate data

Question: 543

What datatypes can store in  in the Message object ?

Answer

PowerObject

String

Numeric

Rowtype

Question: 544

How do you stop the user from editing data that is displayed in a field of a DataWindow?

Answer

None of the above

change column in a DataWindow object to read-only by changing the tab sequence number of the column to 0 by scripts

Change the tab value of the field to zero in the DataWindow painter

dw_control.Object.columnname.Protect=1 by scripts

Question: 545

Which  the default window type when create a new window ?

Answer

Popup

Child

MDI Frame

Main

Question: 546

PB. Which type is not properties for DataWindow control？

Answer

Visible

SetItem

Border

Enabled

Question: 547

Which of the following loop, the condition is evaluated before entering the loop, If condition evaluates to FALSE, the loop is terminated

Answer

GOTO

LOOP

FOR … LOOP

WHILE … LOOP

Question: 548

Which of the following property minimizes the window to an icon？

Answer

WindowName.State

WindowName.WindowState

WindowName.Status

WindowName.DisplayStatus

Question: 549

PB. This script, Which answer Of below Is correct?

String ls_parm, ls_factno
Integer li_i, li_pos ls_parm = “A1,A2,A3,A4”
If Trim(ls_parm) <> ” Then
li_i = 1
Do While Len(ls_parm) > 0
li_pos  = Pos(ls_parm,”,”)
ls_factno = Left(ls_parm,li_pos – 1)
ls_parm  = Right(ls_parm,Len(ls_parm) – li_pos)
li_i++
Loop
End If
MessageBox(”,li_i)

Answer

Be error when compile

4

Infinite loop

3

Question: 550

PB， Which answer of below is correct? any i = Abs(-4.2) messagebox(”, i)

Answer

4.2

-4

-4.2

4

Question: 551

PB. Which answer of below is can not get data from column Fact_no? 

Long ll_row
String ls_fact
ll_row = dw_single.GetRow()

Answer

ls_fact = dw_single.GetItemString(ll_row,”fact_no”)

ls_fact = Trim(dw_single.Object.fact_no [ll_row])

ls_fact = dw_single.GetItemString(dw_single.GetRow(),’fact_no’)

ls_fact = dw_single.Object[‘fact_no’]

Question: 552

PB. Which answer of below is correct?  

any i = Ceiling(-4.8)
messagebox(”, i)

Answer

4

5

-5

-4

Question: 553

PB. Which the following definition is not correct for The protection setting of a column?

Answer

When a column is protected, the user cannot edit it even if the column’s tab order is greater than 0.

When a column is protected, the user can edit it even if the column’s tab order is greater than 0.

A user cannot change a column value when Protect is 1

A user cannot change a column value if Edit.DisplayOnly is Yes when the column has the Edit  style

Question: 554

PB. Ex: Have Datawindow dw_single, column BOSS. Which script of below is not correct for Width DataWindow object property?

Answer

dw_single.Object.boss.Width = 250

string setting                                                                                              setting = dw_single.boss.Describe.Width

string setting                                                                                              setting = dw_single.Object.boss.Width

dw_single.Modify(“boss.Width=250”)

Question: 555

PB. Which alignment value of below is correct for Alignment DataWindow object property?

Answer

0,1,2

1,2,3,4

0,1,2,3

0,1,-1,Null

Question: 556

PB. Which answer of below is correct?    

any i = Cos(Pi(1))
messagebox(”, i)

Answer

-1

1

0.54

-0.54

Question: 557

PB. Which below description about LOOP statement is not correct?

Answer

do   /*statementblock*/ loop while /*condition*/ Description: Executes a block of statements at least once and continues while the specified condition is true. The loop ends when the condition becomes false.

do until /*condition*/  /*statementblock*/ loop Description:Executes a block of statements until the specified condition is false. If the condition is true on the first evaluation, the statement block does not execute.

do while /*condition*/  /*statementblock*/ loop Description: Executes a block of statements while the specified condition is true. The loop ends when the condition becomes false. If the condition is false on the first evaluation, the statement block does not execute.

do  /*statementblock*/ loop until /*condition*/ Description:Executes a block of statements at least once and continues until the specified condition is true.

Question: 558

PB. The following datawindow type, which is can not ShareData?

Answer

Composite

Tabular

Grid

Crosstab

Question: 559

Which answer Of below Is correct?

Int a,b,c,d
b = 2
Do Until a < 15
a = (a + 1) * b
Loop    
Do While a <= 15
c = (c + 1) * b
Loop    
d = a+c
MessageBox(‘tb’, d)

Answer

0

Run be error

Endless loop

2

Question: 560

PB. which answer of below define is correct for CloseQuery in window?)

Answer

Occur when close the window, before Close event

Occur when close the window, after Save event

Occur when close the window, before Save event

Occur when close the window, after Close event

Question: 561

In PB, what the following type is Events for Menu object?

Answer

ClassName

Text

Checked

Selected

Question: 562

PB. The following denfinition is correct for an MDIClient

Answer

An MDIClient object has inherit events.

An MDIClient object has no inherit events.

An MDIClient object has no associated events.

An MDIClient object has associated events.

Question: 563

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: 564

PB. Ex: dw_1 have 5 columns (a,b,c,d,e). which is the script have error when compile?

Answer

dw_1.SetColumn(‘a’)

dw_1.SetColumn(6)

dw_1.SetColumn(a)

dw_1.SetColumn(‘1’)

Question: 565

PB. What the following return value is not correct for InsertRow method.

Answer

-1

Returns the number of the row that was added

If any argument’s value is NULL, the method returns NULL

1

Question: 566

PB. What the following type is Events for Menu object?

Answer

ClassName

Text

Checked

Selected

Question: 567

PB. which is the script have error when compile?

Answer

String ls_depts
If IsNull(ls_depts) Or Len(Trim(ls_depts)) = 0 Then
ls_depts = ‘z’
End If

String ls_depts
If IsNull(ls_depts) Or Len(Trim(ls_depts)) = 0 Then
ls_depts : = ‘z’
End If

string ls_depts
IF Isnull(ls_depts) or len(trim(ls_depts)) = 0 THEN ls_depts = ‘0’

String ls_depts
If IsNull(ls_depts) Or Len(Trim(ls_depts)) = 0 Then
ls_depts = ‘0’
End If

Question: 568

PB. What the following type is Events for UserObject  object?

Answer

DragAuto

Drag

DragIcon

DragDrop

Question: 569

PB. What the following type is not Properties for Report controls in DataWindow objects

Answer

Attributes

Width

Report

Name

Question: 570

Itemchaged the return value , which the flollowing non ?

Answer

-1

2

0

1

Question: 571

In PowerScipt, a statement will be executed immediately after close the app ?

Answer

END

CALL

CLOSE

HALF

Question: 572

Datawindow type, what can adjust cloumn width ?

Answer

Group

N-Up

Grid

Freefrom

Question: 573

Which of the following can not be inherited ?

Answer

Userobject

Window

Datawindow

Menu

Question: 574

PB. What the following return value is not correct for SetChanges method in datawindow.

Answer

-3

-2

2

3

Question: 575

PB. What the following type is Events for Pipeline object?

Answer

Destructor

Start

DataObject

PostEvent

Question: 576

PB. What the following type is Functions for Line control?

Answer

Constructor

BeginY

GetParent

Visible

Question: 577

PB. What the following type is not properties of the Transaction Object control?

Answer

LogPass

Lock

LockUser

dbParm

Question: 578

PB. which is the script have error when compile?

Answer

DECLARE PRO_1     PROCEDURE FOR PRO_AXYZ(A,B,C)                          EXECUTE  PRO_1;

DECLARE PRO_1     PROCEDURE FOR PRO_AXYZ(A,B,C)                         USING SQLCA; EXECUTE  PRO_AXYZ;

DECLARE PRO_1     PROCEDURE FOR PRO_AXYZ(A,B,C)                         USING SQLCA; EXECUTE  PRO_1;

DECLARE PRO_1     PROCEDURE FOR PRO_AXYZ()                         USING SQLCA; EXECUTE  PRO_1;

Question: 579

PB. what answer of below define is not correct?

Answer

Use LOOP WHILE or LOOP UNTIL when you want to execute a block of statements at least once

LOOP WHILE and LOOP UNTIL test the condition when the block of statements has been executed

Use DO WHILE or DO UNTIL when you want to execute a block of statements only if a condition is true

DO WHILE and DO UNTIL test the condition before executing the block of statements.

Question: 580

In PB,Can you doing the following SQL statements?

Answer

Delete procedure.

Declarations of SQL cursors and stored procedures

Declarations and call View.

Edit table.

Question: 581

Which one of the following prints the Datawindow?

Answer

DataWindowControlName.Print( StartRowNoToPrint, EndRowNoToPrint )

DataWindowControlName.Retrieve() > PrinterName

DataWindowControlName.Print( BooleanValue )

DataWindowControlName.Print( PrinterName )

Question: 582

Have the following script, What would be return the value of ls_Dummy1?  String ls_Dummy1 SetNull( ls_Dummy1 )

Answer

space

”

NULL

“”

Question: 583

In Powerbuilder , data window object design, have 11 style options,  which of the following display Style design for single data entry? ”

Answer

freeform

label 

tabular 

grid

Question: 584

If you want in the window, click the left mouse to handle the event, which should be use event?

Answer

leftclicked

clicked

key

rightclicked

Question: 585

In Powerbuilder, there are four different range of variables, which variables use internal?

Answer

local

global

shared 

instance

Question: 586

In the operating state, which of the following types of windows do not have the capabilities to maximize and minimize

Answer

Pop-up window

Mutil document window

Parent Window

Responsive window

Question: 587

How many window type of PB?

Answer

8

6

2

4

Question: 588

In PB, the following script, which is the scripts will get return -4.0

Answer

int(-4.9)

int(-4.6)

int(-3.2)

int(-4.1)

Question: 589

PB. How many window type?

Answer

8

6

2

4

Question: 590

PB. In the Itemerror event, which the values return is not  accept the data and view one message error.

Answer

3

2

0

1

Question: 591

PB. The following denfinition is correct for Window Child type

Answer

depend on parent window

can not independent and depend on parent window

can independent or depend on parent window

can  independent and depend on parent window

Question: 592

PB. When do occurs ItemChanging event?

Answer

before change the data

when save the data

when changing the data

when changed the data

Question: 593

PB. What the following type is not properties for DataWindow control

Answer

Visible

SetItem

Border

Enabled

Question: 594

PB. What the following type is not Events for DataWindow control

Answer

UpdateStart

Update

Itemerror

Resize

Question: 595

PB. This script, what answer Of below Is correct For Sum?

Int i,j,k, Sum
For i = 1 To 10 Step 5
For j = 1 To 2
For k = 1 To 2
Next
Next
Sum = i+j+k
Next

Answer

2

22

11

12

Question: 596

PB. The following script, Which is view 2 values A and B, but them  will be separated by 1 line?

Answer

messagebox(‘tb’, a+”~r”+b)

messagebox(‘tb’, a+”~n”+b)

messagebox(‘tb’, a+”~r~r”+b)

messagebox(‘tb’, a+”~r~n”+b)

Question: 597

Pb. Share Datawindow, which of the following events, when doing on the secondary window will not affect the main window?

Answer

ImportClipboard

SetFilter

SetItem

InsertRow

Question: 598

PB. The following database, what is the PowerBuilder 10 can not support direct connection..

Answer

SQL Server

OLE DB

ADO.NET

JDBC

Question: 599

This script, what answer Of below Is correct?

Int a,b,c,d
b = 2
Do Until a < 15
a = (a + 1) * b
Loop
Do While a <= 15
c = (c + 1) * b
Loop
d = a+c
MessageBox(‘tb’, d)

Answer

0

run be error

Endless loop

2

Question: 600

PB. what answer of below define is correct for Inherit function?

Answer

The inherited or descendent object has all the instance variables, events, and functions of the ancestor. You have programmatic access and edit to the ancestor

The inherited or descendent object has all the instance variables, events, and functions of the ancestor. You do not have programmatic access and edit to the ancestor

The inherited or descendent object has all the instance variables, events of the ancestor. You have programmatic access and edit to the ancestor

The inherited or descendent object has all the instance variables, and functions of the ancestor. You have programmatic access and edit to the ancestor