GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Peoplesoft  >  PS Admin
Go To First  |  Previous Question  |  Next Question 
 PS Admin  |  Question 32 of 87    Print  
What is added as new option in Build apart from Create Tables, Indexes, Views?
Create Trigger


  
Total Answers and Comments: 1 Last Update: November 27, 2006   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
November 27, 2006 08:52:22   #1  
Ratish        

RE: What is added as new option in Build apart from Cr...
Alter Table & Create Trigger
 
Is this answer useful? Yes | No

 Related Questions

Which of the following are true with respect to validate sign on with database option enabled in psadmin?
1. The application server first attempts to connect to database using the user id and password as part of the database connection string.2. User must be defined on either the operating system or the 

Create Trigger  
Latest Answer : Alter Table & Create Trigger ...

Development and Upgrade  

Created a Menu and a Page and given user access to that page, which of the tables gets affected on this (Scenario)?
PeopleTools Tables 

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 _TAO You 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.
Update statistics on the table 

user can type only prompt table values and the default values gets populated from the database. 

1. Development2. Upgrade 

PeopleSoft has its own naming convention for system and non-system (application) tables. In the list below, RECORDNAME refers to the name of any table or record.Referring to the above information, which one of the following identifies the naming convention PeopleSoft uses for system tables?
PSRECORDNAME  

In which one of the following views would you see the fields, criteria, and other details associated with the current query?
Query view  

Latest Answer :  After You created your Depatments.Navigate to TreeManger->Tree Manager.Select Appropriate Security Tree (In General in Peoplesoft this will be DEPT_SECURITY).Attach your newly cretaed Department in the tree in the required node. Then after run ...
Read Answers (1) | Asked by : anu


 Sponsored Links

 
Related Articles

Performing DML Operations on XML Schema Based XMLType Views

Performing DML Operations on XML Schema Based XMLType Views Analyzing the underlying query of the empSch v view discussed in the preceding section you may note that each attribute of the EMP T object used in the select list maps to a certain column of a single table namely emps What this means in pr
 

Using XMLType Views

Using XMLType Views Using XMLType Views XMLType views provide a convenient way to construct XML representations of relational data without physically migrating that data into XML Once written an XMLType view may be used in various queries making them simpler and so increasing their readability mosgo
 

What is the use of COUNT with DISTINCT option

COUNT is a group function returns result by summarizing multiple rows. All group by value function will have the usage of DISTINCT or ALL option and so is the COUNT which uses the DISTINCT option. DISTINCT option is used to enforce uniqueness and  if combined with COUNT is used to
 

The Interview Snafu

How to turn someone else’s mistake to your advantage Your dream job is about to become reality. A recruiter gave you the heads up about the perfect position at Humungous Conglomerate, Inc. You went through five interviews as well as a battery of psychological tests mandated by their HR de
 

Winning a Job Interview with a Winning Resume

Does your resume unlock your potential, take your skills to the highest level and win you the interview and the job you want now? The job market today is highly competitive and even if you think you have what it takes to get an interview you won’t get over the line without a polished, prof
 

Importance of Proper English during Job Interview

Importance of Proper English during Job Interview Your job interview is crucially important and it will determine whether or not you will get the job Depending on the type of job you re going for it is very important for you to use proper English In most cases jobs which offer higher salaries will h
 

Finding The Right Student Loan Option

Finding The Right Student Loan Option Finding the right student loan can be a struggle to many students It is one major decision that can make or break a student’ s future financial stability If you make the mistake of getting a student loan that you cannot properly manage as you go along
 

How To Build Customer Loyalty With CRM

How To Build Customer Loyalty With CRM In order for a CRM system to become successful a company must make it an integral part of their philosophy and corporate strategy As I have stated in previous articles it is not simply enough to view CRM as simply being another technological solution It is a pa
 

How to Build a Career During Recession

A college degree could suggest a particular career but it can also be applied to many other careers. As a result the fresh graduate is not forced on a single job. He has a variety of options on what field to work on. That is why many of the fresh graduates opts to transfer from one job to another
 

HR Interview - HR Interview Mistakes You Will Want To Avoid

HR Interview Mistakes You Will Want To Avoid The job interview can be a stressful process This is especially true for those who are going after a competitive position Your nonverbal communication combined with the answers you give during the interview will determine if you are hired mosgoogle While
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape