- World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Our Services
Get 9,000 Interview Questions & Answers in an eBook.

Get it now !!
Send your Resume to 6000 Companies
SQR Interview Questions & Answers - Learning Mode

SQR Interview Questions & Answers - Learning Mode

SQR (Hyperion SQR Production Reporting, Part of OBIEE) is a programming language designed for generating reports from database management systems. The name is an acronym of Structured Query Reporter, which suggests its relationship to SQL (Structured Query Language). SQR is a specialized programming language for accessing, manipulating, and reporting enterprise data. With SQR, you build complex procedures that perform multiple calls to multiple data sources and implement nested, hierarchical, or object-oriented program logic.

Try SQR Interview Questions & Answers - Exam Mode


Sort By : Latest First | Oldest First | By Rating

SQR Interview Questions & Answers - Learning Mode
Try SQR Interview Questions & Answers - Exam Mode
Question: What is difference between Load Look up and Array

Answer: Load Lookup is essentailly an array which acts in the form of a table. Load Lookup is used to reduce the complexity of joins - it populates the values of a certain field depending on the ke field specified from a certain table. Then the users can query from the preloaded lookup table instead of joining tables.

While arrays are used to store and retrieve data using the get and put commands
Question: Normalization in oracle?

Question: Outer join, inner join in sql?

Question: Performance tuning of SQR?

Question: What is search Record?
How to create SQC?
How to connect other application in component interface?

Answer: Search record is a record that has at least one search key. Sqc is nothing but sqr program , but the saving convention is sqc. By using Keys , methods , and properties we can connect other application in ci.<br> Source:
Question: Experience in UNix?

Question: Did u worked with functions, procedures in SQR?

Answer: 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 Source:
Question: How can you send emails using SQR

Answer: using call system command
Question: What is the difference in using inner join and outer joins?

Answer: 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
Question: Exp in Object oriented prog?

Question: How do u decide between appeng/Ci and SQR while conversion?

Question: What are the compulsary SQC's that should be used in SQR Program?

Answer: Setenv.sqc,setup02.sqc,prcsapi.sqc,prcsdef.sqc,curdttim.sqc,datetime.sqc are some of the SQC's that should be present. Source:
Question: Diff b/w BI,CI,IB?

Question: How do you generate tow output files from one SQR.

Answer: Using create report you can create multiple reports in one single SQR report
Question: Tell me ur experience with CI?

Question: Did u worked with functions, procedures in SQR?

Answer: 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 Source:
Question: We wish to print the EMPLID in the BARCODE Format. What are the commands we have to be used in SQR?

Answer: PRINT-BAR-CODE Source:


India News Network
Latest 20 Questions
Payment of time- barred debt is: (a) Valid (b) Void (c) Illegal (d) Voidable
Consideration is defined in the Indian Contract Act,1872 in: (a) Section 2(f) (b) Section 2(e) (c) Section 2(g) (d) Section 2(d)
Which of the following is not an exception to the rule, "No consideration, No contract": (a) Natural love and affection (b) Compensation for involuntary services (c) Completed gift (d) Agency
Consideration must move at the desire of: (a) The promisor (b) The promisee (c) The promisor or any other party (d) Both the promisor and the promisee
An offer which is open for acceptance over a period of time is: (a) Cross Offer (b) Counter Offer (c) Standing Offer (d) Implied Offer
Specific offer can be communicated to__________ (a) All the parties of contract (b) General public in universe (c) Specific person (d) None of the above
_________ amounts to rejection of the original offer. (a) Cross offer (b) Special offer (c) Standing offer (d) Counter offer
A advertises to sell his old car by advertising in a newspaper. This offer is caleed: (a) General Offer (b) Special Offer (c) Continuing Offer (d) None of the above
In case a counter offer is made, the original offer stands: (a) Rejected (b) Accepted automatically (c) Accepted subject to certain modifications and variations (d) None of the above
In case of unenforceable contract having some technical defect, parties (a) Can sue upon it (b) Cannot sue upon it (c) Should consider it to be illegal (d) None of the above
If entire specified goods is perished before entering into contract of sale, the contract is (a) Valid (b) Void (c) Voidable (d) Cancelled
______________ contracts are also caled contracts with executed consideration. (a) Unilateral (b) Completed (c) Bilateral (d) Executory
A offers B to supply books @ Rs 100 each but B accepts the same with condition of 10% discount. This is a case of (a) Counter Offer (b) Cross Offer (c) Specific Offer (d) General Offer
_____________ is a game of chance. (a) Conditional Contract (b) Contingent Contract (c) Wagering Contract (d) Quasi Contract
There is no binding contract in case of _______ as one's offer cannot be constructed as acceptance (a) Cross Offer (b) Standing Offer (c) Counter Offer (d) Special Offer
An offer is made with an intention to have negotiation from other party. This type of offer is: (a) Invitation to offer (b) Valid offer (c) Voidable (d) None of the above
When an offer is made to the world at large, it is ____________ offer. (a) Counter (b) Special (c) General (d) None of the above
Implied contract even if not in writing or express words is perfectly _______________ if all the conditions are satisfied:- (a) Void (b) Voidable (c) Valid (d) Illegal
A specific offer can be accepted by ___________. (a) Any person (b) Any friend to offeror (c) The person to whom it is made (d) Any friend of offeree
An agreement toput a fire on a person's car is a ______: (a) Legal (b) Voidable (c) Valid (d) Illegal
Cache = 0.359375 Seconds