What should you do to correct this problem?

Exhibit:

The DBA added a STATE column defined as VARCHAR2(2) to the CUSTOMERS table. This column will contain two-letter state abbrevations; because the CUSTOMERS table is quite large, storing complete state names would waste space in the database. The DBA asks you to add a corresponding State item to the Customers block of the Orders form.
You open the Layout Editor of the Orders form and create a list item on the canvas in the Customers block. In the Property Palette for the list item, you change the Name property to State and the Database Item property to Yes. You then open the Elements in List property and add some state abbreviations and names to the list, as shown in the exhibit.
When you run the form to test it, after selecting a value from the list and clicking Commit, you receive an FRM error. Its corresponding database error is the following:
ORA-01401: inserted value to large for column
What should you do to correct this problem?

Exhibit:

The DBA added a STATE column defined as VARCHAR2(2) to the CUSTOMERS table. This column will contain two-letter state abbrevations; because the CUSTOMERS table is quite large, storing complete state names would waste space in the database. The DBA asks you to add a corresponding State item to the Customers block of the Orders form.
You open the Layout Editor of the Orders form and create a list item on the canvas in the Customers block. In the Property Palette for the list item, you change the Name property to State and the Database Item property to Yes. You then open the Elements in List property and add some state abbreviations and names to the list, as shown in the exhibit.
When you run the form to test it, after selecting a value from the list and clicking Commit, you receive an FRM error. Its corresponding database error is the following:
ORA-01401: inserted value to large for column

What should you do to correct this problem?

A.
Have the DBA increase the column width in the database.

B.
Change the List Style property for the State item to Tlist.

C.
Change the List Style property for the State item to Combo Box.

D.
Set Initial Value for the State item to one of the elements in the list.

E.
Set Mapping of Other Values for the State item to a two-letter state abbreviation.

F.
Change the elements in the list of the State item so that the list elements are the state names and the list element values are the state abbreviations.



Leave a Reply 1

Your email address will not be published. Required fields are marked *