31. Your Onsite DBA has called you up and told you that one of the tables PS_ABC_TAO has grown very big in size. Based on the standard naming convention, you have determined that the record is a temporary record since it ends with _TAOYou look into the database and decide that that the data is not required any more. You ask the DBA to delete the data in the table.Next day you get a call from an irritated user who says that a daily process that took only 1 minute to run is taking about 2 hours today. You look into his process and find that it uses PS_ABC_TAO as a temporary table.What would you suggest the DBA to do ?

Update statistics on the table

32. (Some scenario) Question relating DBA Purging Temporary Table?

Update Statistics

33. How many Message nodes are possible for a database.?

Unlimited

34. How will you get a single ouptut by combining two or more queries?

UNION

35. What BEA product is used for DB transaction in PS?

Tuxedo

36. Which one of the following Data Types is NOT supported by the PeopleCode programming environment?

TIMESTAMP

37. What hyperlinks available in PeopleBooks? Some options with different hyperlinks not available in peoplebooks, select the correct one?

Study all hyperlinks in the first page of people books.

38. The example below demonstrates the use of SQR flags in the configuration manager directories folder: -F C:PSHrmsSqrWhat do the above SQR flags signify to the SQR Report Writer upon execution?

Specifies the output path

39. When a business requirement in Fit/Gap Analysis does not meet by PeopleSoft then?

Some options:1. Customize PS application (Yes)2. Buy third party software (Yes)3. Call PS Development Center for Enhancement (Yes)

40. What are the status available in PeopleSoft Domain Status Menu?

Server, Client and Queue Status