IFSM247P - Introduction to PowerBuilder

Quiz 4

 

1)       Which of the following are parameters of a transaction object?

A)      DBMS

B)      Database Name

C)      Password

D)      SQL Statement

2)       In which of the following events usually contains the code for initializing a transaction object?

A)      Application Close

B)      Application Open

C)      Window Close

D)      Window Open

3)       Datawindow objects are created using the:

A)      Database Profile Painter

B)      Database Painter

C)      DataWindow Painter

D)      Window Painter

4)       Datawindow objects become controls using which painter?

A)      Database Profile Painter

B)      Database Painter

C)      DataWindow Painter

D)      Window Painter

 

5)       _____         Embedded SQL statements must end with a semi-colon (;)

 

6)       _____         The parameters necessary to create the transaction object can be copied from the database profile painter.

 

7)       _____         The default transaction object in PowerBuilder is SQLCA.

 

8)       _____         The transaction object includes the select statement a datawindow will use.

 

9)       _____         Within a delivered application, a datawindow will retrieve data without a transaction object.

 

10)   _____         The transaction object controls how data is presented in the application.

 

11)   _____         The transaction object will pass vendor specific database error codes and messages to the application.

 

12)   _____         A datawindow exist as an object before it can be a control.

 

13)   _____         A PowerBuilder application can have multiple transaction objects.

 

14)   _____         The data supplied to a datawindow can come from a select statement, a PowerBuilder query, or a stored procedure.

 

15)   _____         A datawindow is limited to displaying data from one table at a time.

 

16)   _____         Datawindows are limited to presenting data in row and column format.

 

17)   _____         Columns in a datawindow can be used to produce calculated fields.

 

18)   _____         The programmer must write vendor-specific SQL code to retrieve and save data using a datawindow.