SQR (Structured Query Reporter) Interview Preparation Guide
Refine your Structured Query Reporter (SQR) interview skills with our 16 critical questions. Our questions cover a wide range of topics in Structured Query Reporter (SQR) to ensure youre well-prepared. Whether youre new to the field or have years of experience, these questions are designed to help you succeed. Dont miss out on our free PDF download, containing all 16 questions to help you succeed in your Structured Query Reporter (SQR) interview. Its an invaluable tool for reinforcing your knowledge and building confidence.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.
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.
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.
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
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
10 :: Suppose We wish to print the EMPLID in the BARCODE Format. What are the commands we have to be used in SQR?
PRINT-BAR-CODE