최신 IBM Specialist C2090-552 무료샘플문제:

1. You have extracted some data from production to use for a test. After the insert,you used the Edit function to change some values in specific rows to test certain logic in your program. You will be testing for several weeks and want to keep these special test cases, even though you may be re-loading your test data many times. Is theresome way to retain these edited values so that they are not lost when the data is refreshed from the extract file?

A) Edit the original extract file to permanently change the values in these specific rows.
B) There is no way to preserve the edits, you will have to re-edit those special test cases each time the data is refreshed from the extractfile.
C) Use Compare to generate a file of changes that you can use to update the test database after each refresh.
D) After the data is edited, make an extract file of your test tables, and use this new extract file to refresh your data after each test.

2. 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 ?ey
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?

A) Compare Row Contents option was not selectedprior to running the Delete Request.
B) You do not have authority in the database to specify a key to use.
C) The wrong index was chosen for the Optim Primary Key for the table.
D) The table has a very large amount of data and the database engine has chosen a different access strategy than what you have specified.

3. You are using the Hash_Lookup function and errors occur that indicate records are not found in the Lookup Table. What is the cause of this problem?

A) The key field in the lookup table that contains the sequence numbers has gaps in those sequence numbers.
B) The lookup table is too small in relationship to the number of records in the source databasetable consequently more records need to be added to the lookup table.
C) A memory error has occurred and the Optim process must be restarted.
D) This error could not occur, Hash_Lookup will always return a row from the lookup table.

4. Which of the following is NOT an attribute of a Column Map?

A) If a match is not found for a Destination or Source 2 column, the status is NOT USED or
REQUIRED.
B) Columns with the same name and compatible data types are not automatically matched.
C) Column Map names are a two part name
D) You can create a new Column Map from the Definitions submenu.

5. In the UNIX pstserv.cfg file, if the DBALIASLOGON parameter is set to CLIENT, how does
Optim Server obtain the userid and password to log the user onto the database?

A) The userid and password for database logon will be taken from the userid and password of the Optim Server daemon.
B) The userid and password for database logon mustbe specified in the DB Alias parameter in the pstserv.cfg file.
C) The userid and password will come from the pstlocal.cfg file if the request originated from the UNIX commandline. It will come from the Windows registry if the request originated from Windows.
D) The user will be prompted to supply a userid and password for DBMS logon.

질문과 대답: