Given a SQL Statement, if you have been asked to check the right syntax ?

Given a SQL Statement, if you have been asked to check the
right syntax ?

Question Posted / guest

Given a SQL Statement, if you have been asked to check the right syntax ?..

Answer / nimmathota

Run in backend whether WinSQL or Toad and check if errors
out if it is the cursor will stop exactly where the syntax
is wrong

Is This Answer Correct ?

0 Yes

1 No

More PeopleSoft Administration Interview Questions

When a business requirement in Fit or Gap Analysis does not meet by PeopleSoft then what to do?

PeopleSoft tracks object changes using a system table. Which PeopleTools System table is used to track object changes?

How would you connect as a tier in application designer?

Explain how many message nodes are possible for a database?

Can you give an example of peoplesoft server process logs?

You want to enable debug mode in peoplesoft application server. How would you do it?

you have created a Menu and a Page and given user access to that page, which of the tables gets affected on this?

What bea product is used for db transaction in peoplesoft? How would you log into the bs mode?

Which crystal report does peoplesoft query tool create by default?

what happens when changing from NO EDIT TO EDIT option?

What is a connectivity software?

PS Query definition is stored on which server?

For more PeopleSoft Administration Interview Questions Click Here