PS Query definition is stored in whihc server?
-
DB Server
-
Application server
-
Web server
-
DB Server & Application Server
PS Query definitions are stored in the PeopleSoft Application Server, not the database server. This allows for centralized query management and security. The query metadata resides in PeopleTools tables on the application server, even though the query execution hits the database.
To answer this question, you need to understand the role of each server in a PeopleSoft environment.
Option A) DB Server - This option is incorrect because the DB Server is responsible for storing and managing the database, including the data itself, but not the definitions of PS Queries.
Option B) Application server - This option is correct because the PS Query definition is stored in the Application server. The Application server is responsible for processing the business logic of the PeopleSoft application, including handling the definitions of PS Queries.
Option C) Web server - This option is incorrect because the Web server is responsible for serving the PeopleSoft application to users via a web interface, but it does not store the PS Query definitions.
Option D) DB Server & Application Server - This option is incorrect because while the DB Server stores the data, it does not store the PS Query definitions. The Application server, on the other hand, is responsible for storing and managing the PS Query definitions.
The correct answer is B) Application server. This option is correct because the PS Query definition is stored in the Application server.