PeopleSoft Upgrader MCQ

This PeopleSoft Upgrader MCQ Quiz contains few questions as a online practice test.

1. The object has been compared, its LASTUPDOPRID value is not PPLSOFT, and its LASTUPDTIME value is greater than the date/time stamp of the comparison release database. In this case, the customer has modified the object since the comparison release.

a) Changed
b) UnChanged
c) *Changed
d) *UnChanged

2. What does the Store command do in data mover ?

a) The STORE command first deletes existing stored statement from PS_SQLSTMT_TBL
b) The STORE command inserts the new statemen in PS_SQLSTMT_TBL
c) The store command changes nvision sql statement in PS_SQLSTMT_TBL
d) Both a and b

3. What is PRIMARY KEY constraint ?

a) a column defined as PRIMARY KEY can’t contain Nulls.
b) a column defined as PRIMARY KEY can contain Nulls.
c) a ROW defined as PRIMARY KEY can’t contain Nulls.
d) a ROW defined as PRIMARY KEY can contain Nulls.

4. Which order is correct for script execution while manually creating peoplesoft Application database in Oracle

a) DBOWNER.sql ULTSPACE.sql CREATEDB10.sq XXXDDL.sql PSROLES.sql PSADMIN.sql CONNECT.sql
b) CREATEDB10.sql ULTSPACE.sql XXXDDL.sql DBOWNER.sql PSROLES.sql PSADMIN.sql CONNECT.sql
c) CREATEDB10.sql XXXDDL.sql ULTSPACE.sql DBOWNER.sql PSROLES.sql PSADMIN.sql CONNECT.sql
d) CREATEDB10.sql ULTSPACE.sql XXXDDL.sql DBOWNER.sql PSADMIN.sql PSROLES.sql CONNECT.sql