Exam 1Z0-548 Topic 4 Question 3 Discussion
Actual exam question for Oracle's 1Z0-548 exam
Question #: 3
Topic #: 4
Question #: 3
Topic #: 4
In your client's company, the Telephone Allowance is paid as per the grade of an employee. This information is stored in a User Defined Table. The Row is set as the Grade name and the Column Value is set as the applicable amount of the Telephone Allowance. Your client wants to validate that the value entered in the column Value is between 0 to 300 USD.
How would you configure this validation?
How would you configure this validation?
Suggested Answer: A Vote an answer
You set up user tables in the Table Structure window.
To set up the structure of a table:
1.Set your effective date to the date from which you want the table's row labels to take effect.
2.Enter the table name.
3.For the table's match type, select Match or Range. Select Match if each row is for one item, such as one job or one code. Select Range if each row is for a range of numeric values, such as an age range or a pay range.
(A)
4.If the match type is Match, select Date, Number or Text as the Key Units of Measure, depending on whether entries in the rows are dates (DD-MON-YYYY), numbers, or alphanumeric text.
If the table's match type is Range, the Key Units of Measure automatically becomes Number.
5.Enter the row label as the Row Title.
For example, if the table rows refer to rate codes, an appropriate row title would be Rate Code. If the rows refer to age ranges, you might use the title Age Range.
6.Save your work, and choose the Columns button to go to the Columns window.
References:
To set up the structure of a table:
1.Set your effective date to the date from which you want the table's row labels to take effect.
2.Enter the table name.
3.For the table's match type, select Match or Range. Select Match if each row is for one item, such as one job or one code. Select Range if each row is for a range of numeric values, such as an age range or a pay range.
(A)
4.If the match type is Match, select Date, Number or Text as the Key Units of Measure, depending on whether entries in the rows are dates (DD-MON-YYYY), numbers, or alphanumeric text.
If the table's match type is Range, the Key Units of Measure automatically becomes Number.
5.Enter the row label as the Row Title.
For example, if the table rows refer to rate codes, an appropriate row title would be Rate Code. If the rows refer to age ranges, you might use the title Age Range.
6.Save your work, and choose the Columns button to go to the Columns window.
References:
by Betty at Nov 20, 2023, 04:49 PM
0
0
0
10
Comments
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Report Comment
Commenting
You can sign-up / login (it's free).