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

Explain state records. What is its purpose?

What is peoplesoft configuration manager?

In PeopleCode Debugger what are the valid values?

How to get a single ouptut by combining two or more queries?

Explain what are the search keys you use to find patches and fixes?

What are peopletools utilities?

You want to authenticate a user in peoplesoft. How would you do that?

Explain integration broker and its components.

What are the People Tools available for Integration Broker?

DB is in windows, application server can be configured in Windows or Unix or Anyone?

How can you configure sql trace?

Do you know what is the purpose of state records?

For more PeopleSoft Administration Interview Questions Click Here