SQR (Structured Query Reporter) Interview Preparation Guide
Download PDF

SQR (Structured Query Reporter) guideline for job interview preparation. Explore list of Structured Query Reporter (SQR) frequently asked questions(FAQs) asked in number of SQR (Structured Query Reporter) interviews. Post your comments as your suggestions, questions and answers on any Structured Query Reporter (SQR) Interview Question or answer. Ask Structured Query Reporter (SQR) Question, your question will be answered by our fellow friends.

16 Structured Query Reporter (SQR) Questions and Answers:

1 :: Tell me Did you worked with functions, procedures in SQR?

Yes. It is similar to use function, procedure and packages in SQR. The only difference is - Use begin-Sql Begin procedure(param1,param2) End End-Sql

2 :: Can you explain your experience with CI?

1. Mainly for upload the data from the flatfile to peoplesoft application tables.
2. It will high-level of validation before updating data in the database.
3. If we want to upload data into parent-child tables, CI is best.
4. While expose CI from one component please check whether this component have level0 design or not. If it is, then do it otherwise no use to create CI.

3 :: Explain Exp in Object oriented prog?

Object-oriented programming (OOP) is a programming paradigm that uses "objects" ? data structures consisting of datafields and methods together with their interactions ? to design applications and computer programs. Programming techniques may include features such as data abstraction, encapsulation, modularity, polymorphism, and inheritance. It was not commonly used in mainstream software application development until the early 1990s.Many modern programming languages now support OOP.Ex.,C++,Java etc.,

4 :: How to send emails using SQR?

using call system command

5 :: Any Experience in UNix?

Tell if you have any experience in Unix

6 :: Can you explain What are the compulsary SQCs that should be used in SQR Program?

Setenv.sqc,setup02.sqc,prcsapi.sqc,prcsdef.sqc,curdttim.sqc,datetime.sqc are some of the SQC's that should be present.

7 :: Explain difference between BI, CI, IB?

BI - Business Inerlink - This is peoplesoft object that behave like DLL. If you have to modify something on other application, like some of directory that controls single sign on Business Interliks are used.

CI: Component Interface - This is used to validate any entries in peoplesoft system. say some third party system sent one inbound file and based on the data in inbound file you want to insert row in peoplesoft, you also want the current validation at component (say xyz) to take place. Then create a component interface with xyz component. read the inbound and process it through newly build CI.

IB - Inegraion Broker - This is integration point of peoplesoft with all other peoplesoft and thirdparty application that uses Messaging.

8 :: What is Normalization in oracle?

Normalization is the process of organizing data in a database. This includes creating tables and establishing relationships between those tables according to rules designed both to protect the data and to make the database more flexible by eliminating two factors: redundancy and inconsistent dependency.

Redundant data wastes disk space and creates maintenance problems. If data that exists in more than one place must be changed, the data must be changed in exactly the same way in all locations. A customer address change is much easier to implement if that data is stored only in the Customers table and nowhere else in the database.

9 :: Explain the difference in using inner join and outer joins?

Inner join : An inner join (sometimes called a "simple join") is a
join of two or more tables that returns only those rows that satisfy the join condition.


Outer Joins : An outer join extends the result of a simple join. An
outer join returns all rows that satisfy the join condition and also returns some or all of those rows from one table for which no rows from the other satisfy the join condition