PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

Which two actions will help you to further increase performance of the archive? (Choose two.)

You discovered a slow performance issue during an archive process with delete deferred. By using the Statistical Report and the Relationship Index Analysis, you were able to determine that there was a missing index on one of the tables. The index has been added to the database, and the Statistical Report reflects that the index is being used for a key lookup. Performance has improved somewhat.
Which two actions will help you to further increase performance of the archive? (Choose two.)

Why might Optim be doing a scan even though you have specified to us e a key to access the table?

When performing a Delete Request, you notice that Optim is doing a table scan even though you have specified a ey Lookup?in the AccessWhen performing a Delete Request, you notice that Optim is doing a table scan even though you have specified a key Lookup in the Access Method of the Table Access Strategy panel for the Delete Request. Why might Optim be doing a scan even though you have specified to us e a key to access the table?

What reflects the value of CUSTNAME after the character expression has been applied?

A table contains two columns, CUSTNAME and STATE. You have created the following character expression to mask CUSTNAME:
SUBSTR(CUSTNAME,1,3) CONCAT ‘EE’ + SUBSTR(STATE,1) || SUBSTR(CUSTNAME,5,2)

Given the values shown below for CUSTNAME and STATE:
CUSTNAME=SANDERS STATE=GA

What reflects the value of CUSTNAME after the character expression has been applied?


Page 1,237 of 1,258« First...102030...1,2351,2361,2371,2381,239...1,250...Last »