Oracle Retail Testing | Questions and Answers

Oracle Retail Testing | Mock Test

1
_________ is the ReSA programs that use full disclosure
a. aexprdw
b. s
c. saexprms
d. Both A and C

Answer : Both A and C

2
A RTLOG log file contains 5 transactions. How many FHEAD and THEAD will be there in the file
a. FHEAD 5 and THEAD 1
b. FHEAD 1 and THEAD 5
c. FHEAD 5 and THEAD 5
d. None of the above
Answer : FHEAD 1 and THEAD 5

3
A status notifies the user sales data has not yet been loaded for the store/day
a. oading
b. Yet to load
c. Ready for Import
d. Both B and C
Answer : Ready for Import

4
Choose the correct sequence of the batches to upload RTLOG1.DTESYS2.SAGETREF3.SAIMPTLOG4.SASTDYCR5.SAIMPTLOGi
a. 21345
b. 51234
c. 12435
d. 41235
Answer : 41235

5
During importing if any errors found what the ReSA application will do
a. It will ignore the error records and process rest of the records
b. Data is not rejected and written into error log files
c. Data is written into database and marked as error
d. Data is not written into database but marked as error
Answer : Data is written into database and marked as error

6
Find the invalid ReSA system options1.Max No. Days Sales Audit Stored2.Max No. Days Post-Dated Trans Allowed3.Max No. weeks Post-Dated Trans Allowed4.Max No. Days returns Audit Stored
a. 1 and 2
b. 2 and 3
c. 3 and 4
d. 1 and 4
Answer : 3 and 4

7
RTLOG stands for1.Retail Trend Log2.Ready To Log3.Retail Transaction Log4.Retail Transaction Logic
a. 1
b. 2
c. 3
d. 4
Answer : 3

8
Which of the following is not a field calculated during MONTH_DATA processing?
a. Closing Stock
b. Shrinkage
c. Half-to-Date Goods Available for Sale
d. Half-to-Date Shrinkage Percent
Answer : Half-to-Date Shrinkage Percent

9
Which of the following is not an element stored in HALF_DATA?
a. Inter-Stock Take Shrink amount
b. Inter-Stock Take Purchase amount
c. Inter-Stock Take Sales amount
d. Shrinkage Percent
Answer : Inter-Stock Take Purchase amount

10
Which of the following statements is/are not correct about TRAN_DATA_HISTORY table?
a. TRAN_DATA_HISTORY holds historical transactional data and is populated from IF_TRAN_DATA
b. TRAN_DATA_HISTORY table is used by the online forms for viewing
c. Records in this table are kept in this table are kept for 18 months before being purged in the end of half processing
d. All of the above
Answer : Records in this table are kept in this table are kept for 18 months before being purged in the end of half processing