Interview Questions.

Question 1. What Is The Difference Between Show And Display?

Answer :

Show is used to display a couple of variable at a time.
Display is used to show most effective one variable at a time.
Question 2. What Are The Debugging Commands In Sqr?

Answer :

Show & Display are debugging instructions

SQL Server 2008 Interview Questions
Question 3. How To Place An Corporate Logo In Sqr?

Answer :

Using "Declare Image" command

Question 4. What Is -debug Command Line Flag?

Answer :

This is used for Debugging in SQR.

SQL Server 2008 Tutorial
Question five. What Are The Sections In Sqr? Which One Is Necessary?

Answer :

Setup, Heading, Footing, Program & Procedure Sections. Program segment is the Mandatory segment.

Oracle 11g Interview Questions
Question 6. What Is -rs & -rt Flags?

Answer :

RS is used to generate SPF report ie; preventing this system after the comilation. _RT is used to run the SPF report .This is also one sort of Performance increasing approach by using saving the compilation time.

Question 7. What Is -tnn Flag?

Answer :

This is especially used for trying out purpose. We can restrict the device to generate only a selected quantity of pages rather than producing all pages for checking out. This is used in Windows Environment.

Oracle 11g Tutorial OBIEE Interview Questions
Question eight. What Is -bnn Flag?

Answer :

This is used to specify the range of rows which might be to be taken from Dbase to the Buffer due to the fact default the system takes 10 rows at a time.

Question nine. How To Refer A Global Variable In Local Procedure?

Answer :

After special person (ex.#,&) we use underscore(_) after that variable name.

SQL Interview Questions
Question 10. How Does Peoplesoft Process Monitor Knows That The Process (say Sqr Report) Is At What Stage Such As Initiated, In Process, Completed Etc?

Answer :

From the Field Value of 'RUNSTATUSDESCR'area from 'PS_PMN_PRCSLIST' table.

OBIEE Tutorial
Question 11. What Are On-destroy Parameters?

Answer :

ON-BREAK causes the desired motion to carry out in a tabular document when the value of a subject adjustments . The default movement prints the field most effective when its price modifications (PRINT=CHANGE).Mainly used for Redundancy of Printing on a page.

SSRS(SQL Server Reporting Services) Interview Questions
Question 12. How To Pass Command Line Flags To A Sqr Report Running Through Process Scheduler?

Answer :

Using override alternatives inside the system definition in the Process Scheduler within the People Tools.

SQL Server 2008 Interview Questions
Question 13. What Are The Steps Required To Run The Sqr From Peoplesoft Environment?

Answer :

Three steps we ought to fallow to run the SQR software from the peoplesoft environment (Process Scheduler).

These steps consist of:

Making the SQR software API aware with the aid of calling two processes (stdapi-init, stdapi-term) from the Begin-software segment and consisting of the Stdapi.Square inside the backside of this system.
Create new run manage table or the usage of present run manage desk and creating run manipulate page, element and sign in the factor. Creating new run manage SQC if we create a new run manage table.
Giving the permission to the user through giving method businesses.
JasperReports Tutorial
Question 14. What Are The Differences Between Load Lookup And Array?

Answer :

ARRAYS:

Arrays may be declared in any section. 
Number of rows aren't automatically 
We need to insert records in to Array via programming.
We can retrieve any wide variety of fields from a desk.
We have Length & Data type.   
We can not at once print from Array. 
LOAD-LOOKUP:

Load-Lookup is asserted in only in SETUP phase best.
Numbers of rows are robotically added.
Rows are automatically inserted in to  Load-Lookup.
We can retrive only Two fields from from a desk. A table.
We do not have Length & Data type.
We can directly print from
 

Question 15. Can You Connect More Than One Database Using One Sqr?

Answer :

Yes.

Business Objects-Crystal Reports Interview Questions
Question sixteen. Can You Call Procedure In Oracle From Sqr? How?

Answer :

To call a database system the use of Begin-select paragraph, the syntax is as follows:

Begin-pick
[(report arguments)]
from Dual
End-choose
To call from Begin-square, the syntax will be

Begin-SQL
;;
End-SQL

Software Development Lifecycle (SDLC) Tutorial
Question 17. How Many Ways Of Performance Tuning Are There In Sqr?

Answer :

Using LOADF-LOOKUP & LOOKUP.
Using ARRAYS.
Using MULTIPE REPORTS.
Using SQT Files.
Using –Bnn Command line Flag.
Running on BATCH SERVER.
Using Proper Programming Logic in SQR such as Using BREAK assertion in EVALUATE Command.
Proper SQL tuning including the use of Sub queries in place of Joins.
IDMS (Integrated Database Management System) Interview Questions
Question 18. How Will You Perform Error Handling In Sqr?

Answer :

We can do Error dealing with in SQR using some command line flags along with –O, -L,-ZMF,-XMB and the use of Error dealing with instructions which includes

ON-ERROR = Skip/Warn/Stop (for Compile time errors)
ON-ERROR = Procedure Name (for execution stage errors).

Oracle 11g Interview Questions
Question 19. What Is Use Of Setenv.Square?

Answer :

This is used to set the Default Environment primarily based on the Database such Printer Type, Paper Size, Date formats Etc….

Question 20. How Will You Display An Image In Sqr?

Answer :

Using 'DECLARE-IMAGE , END-DECLARE' command.

JasperReports Interview Questions
Question 21. Which Section Is Mandatory In An Sqr Program?

Answer :

'BEGIN-PROGRAM' Section is Mandatory for an SQR software.

Question 22. What Is The Sqc Used To Read Data From Translate Table?

Answer :

'READXLAT.Sq.' is the SQC used to read information from Translate Table.

Question 23. What Is The Sqt File? What Are The Advantages Of Sqt Files?

Answer :

SQT' file is not anything but resultant document after the compilation (i.E.) Runtime File. By the usage of this SQT record for Execution we can boom the Performance of the program with the aid of reduciong the Compilation Time.

PeopleSoft Component Interface Interview Questions
Question 24. What Is The Purpose Of Stdapi.Sq.?

Answer :

This is a Process Scheduler Interface sq. Which is used to provoke and terminate a few field values consisting of Process_instance & Run_cntl_id

OBIEE Interview Questions
Question 25. How To Pass Inputs To The Sqr While Running Through The Process Scheduler?

Answer :

Using Procedures & SQC's to get right of entry to facts on Run Control Page (Run Control Fields).

Question 26. How To Pass Inputs For Sqr Program While Running From Windows?

Answer :

Using ASK & INPUT Commands.

Software Development Lifecycle (SDLC) Interview Questions
Question 27. Is There Any Read-simplest Variable In Sqr?

Answer :

Column Variables & System Variables are Read-Only Variables.

SQL Interview Questions
Question 28. What Are Different Types Of Variables In Sqr?

Answer :

Types of variables in SQR are:

Column Variables.
List Variables.
System Variables.
Document Variables.
Substitution Variables.
User Defined Variables
Question 29. What Is The Difference Between Sqr And Sqc?

Answer :

SQR:

This is nothing however the Actual
This includes Program Section.
This may be Compiled & Executed. 
We cannot call one SQR from SQR or SQC
SQC :

This is sort of a characteristic in SQR.
This does not includes software Section.
This can not be Compiled and Executed
We can call one SQC from every other SQC or any other SQR
iReport Interview Questions
Question 30. How Can You Debug Sqr Programs?

Answer :

We can Debug SQR using Debugging Commands which include:

1. #IF DEBUGxxx
#END-IF
2. DISPLAY and
three. SHOW

Question 31. What Are The Commands Used In File Handling Of Sqr?

Answer :

Using File Handling we will Import.

Steps are

Opening a File Using 'OPEN FOR-READING' command.
Reading Data From File Using 'READ' command.
Writing Data into Table Using 'BEGIN-SQL' paragraph & 'INSERT' command

Question 32. Briefly Explain Most Commonly Used Sqc's In Sqr Programs?

Answer :

Some of the most usually used SQC's are

STDAPI.Sq. : This Is Process Scheduler Interface that is used to provoke and terminate a few field values such as Process_instance & Run_cntl_id
SETENV.Square : This is used to set the Default Environment primarily based at the Database such Printer Type, Paper Size,Date formats Etc….
NUMBER.Sq. : This record contains generalized exercises to layout numbers.
DATETIME.Square : This record includes generalized workouts to layout dates and instances.
RESET.Sq. : This is an important Footing SQc.
PeopleCode Interview Questions
Question 33. Can You Call A Sqr From Another Sqr? How?

Answer :

We can name one SQR application from any other SQR program using Call.Callsystem. But that is possible handiest in UNIX Operating device.

SSRS(SQL Server Reporting Services) Interview Questions
Question 34. What Is Load-research? Give The Syntax For Load-research?

Answer :

The LOAD-LOOKUP command defines an array containing a set of keys and values and masses it into memory. With LOAD-LOOKUP, you may lessen the quantity of tables which might be joined in a single SELECT. Use this command together with one or more LOOKUP commands.

Syntax: begin-setup
load-lookup
name=prods
table=products
key=product_code
return_value=description
give up-setup

Question 35. Is It Possible To Increase The Array Size Once Defined?

Answer :

No, it isn't always viable to boom the Array length once described

Question 36. What Are The Sections And Paragraphs Available?

Answer :

There are five sections and 3 paragraphs available in SQR programming.

The sections encompass:

Begin-setup End-setup.
Begin-program End-software.
Begin-method End-technique.
Begin-heading End-heading.
Begin-footing End-footing
And the paragraphs include
Begin-pick paragraph.
Begin-SQL paragraph.
Begin-document paragraph

Business Objects-Crystal Reports Interview Questions
Question 37. Difference Between Process And Job?

Answer :

Process: A system is a unmarried mission, software or routine (including SQR reports or Batch Cobol) that runs either on patron or server.
Job: It is one or greater system of the equal or distinct kind, which can run either in collection or Parallel. (A group of process may be blended and run as procedure task)
Question 38. Define Process Scheduler?

Answer :

It is an centralized device that enables utility developers, machine administrators and alertness customers to manage People tender batch method. Process Scheduler enables you to time table going for walks procedure and create activity.

Question 39. Define An Array?

Answer :

An Array may be defined to store intermediate outcomes or records retrieved from the database.

Question 40. Difference Between Ask V/s Input?

Answer :

ASK : It is requests the user for the value and substitutes the value throughout compilation. It is used handiest inside the setup phase.
INPUT : It requests the person for the fee at runtime. (i.E., at execution degree). It may be used everywhere in the programming section.
Note: INPUT is mere green than ASK.

IDMS (Integrated Database Management System) Interview Questions
Question forty one. Explain Briefly About On-smash Processing?

Answer :

On-wreck option on columns will reason every column to interrupt independently from each different. When a smash occurs the following happens, After procedure are processed in descending sequence from the highest level to the level of the present day smash filed.

Question 42. What Are Positional Co-ordinates?

Answer :

Printing in SQR is setting output at the web page grid. Position syntax is used to outline where to region statistics on the page within a given phase.

JasperReports Interview Questions
Question 43. Explain Print Function?

Answer :

The print command, is both explicit and implicit, is the focal point for formatting and processing.
Explicit print is used to print database column referenced through its pseudonym (&column call) or a person described variable.
The Implicit print is simplest valid for database columns as they're retrieved in the pick para.
Question 44. What Does Sqr Report Structure(program) Consists Of Or Types Of Sections In Sqr Program?

Answer :

Report or Program – Determines wherein SQR will start and quit execution of your document. People soft makes use of this section to govern the go with the flow of processing by calling strategies using the do command, thereby utilising modular programming.
Setup Section – Contains commands, which describe the general file traits (Note: the setup section is preprocessed and is automatically run before the program starts execution. This segment can most effective consist of SQR commands.
Programming section –
Begin – SQL: The SQL paragraph allows you to execute any non-pick out SQL Statement.
Begin-Document-: Allows you to combine background text. With the statistics retrieved from the database.
 Begin-Select: Select paragraph is the coronary heart of the SQR program. For every row of data retrieved from the question, acting as an implicit while loop can also manner a hard and fast of instructions there. Here you specify what columns of statistics to retrieve from the database. Other strategies can be referenced within a select paragraph, which in turn may additionally include other select paragraphs.
Note: In start choose SQR requires that columns names be flesh to the left margin and SQR commands be indented.

Heading Section
Footing Section
Procedure Section : A process is a listing of instructions or paragraphs, which are processed while referenced through a corresponding, do command. Procedure names should be specific. Procedures can incorporate regular SQR instructions in addition to three unique varieties of paragraphs: A. SQL B. Document C. Select
Question forty five. How Sqr Programs Are Evaluated And Executed At Different Times?

Answer :

FIRST PASS: Or Compile stage. SQR procedures the subsequent additives of the program.

All # include outside source documents (SQCs) are inserted into the source software.
All # commands are evaluated.
The setup section is processes which includes allocation and populace of memory arrays created with the aid of the load-look up command.
Optimization of the SQL records get right of entry to path is decided.
Checks syntax of SQR source program.
SECOND PASS: Actual execution of this system source occurs beginning on the begin Report stopping at the quit-file.

Process information for the frame segment.
Senses page overflow or reaction to new-web page command in code.
Process heading phase
Process footing segment
Writes entire page buffer to report.
Question forty six. How Many Types Of Sqr Data Elements Are There?

Answer :

Columns, variables, Literal

Question 47. Explain Briefly About Flags?

Answer :

The SQR command helps numerous flags. Each flag starts offevolved with a sprint (-). Flags with arguments must be followed directly by the argument and not using a intervening space.

SQR Command-Line Flags :Flag Description :

A Causes the file output to be appended to an present document of the person name
Bnn (Oracle,SYBASE CT-Lib) suggests what number of rows to buffer each time records is retrieved from the database. The default is 10 rows.
C Specifies that the cancel conversation box seem while the program.
CB (Callable SQR) forces the communication box for use.
DEBUG (xxx) (Sybase) Causes traces preceded by way of #DEBUG to be compared. Without this flag, those lines are neglected.
E(record) Causes mistakes messages to be directed to the named record, or to the default document report errs. If no errors occur, no document is created.
F (file) (Directory) overrides the default output document call program .Lis
KEEP In addition to .LIS files, creates an .SPF record for each report that your application generates.
LOCK(RR]CS]RO]RL]XX] (SQL Base) Defines the sorts of locking (isolation stage for the session.
NR (SQL Base) specifies that the No Recovery mode is used while connecting to the database.
XCB Do not use the communication field.
XL Prevents SQR from logging on to the database. Programs run in this mode can't include any SQL statements.
XMB Disables the mistake message show so that a software can be run with out interruption by error message bins.
XP (SYBASE DB-Lib) Prevents SQR from growing transient saved pro-cedures.
XTB Preserves the trailing blanks in an LIS record.
ZIV Invokes the SPF viewer after generating program .Spf report. Using this flag implicitly invokes the –KEEP flag to create program .Spf file. 
ZMF(File) specifies the total course and name of the SQR Error Message file. The Sqr err.Dat located in the listing indicated with the aid of the SQR DIR environment Variable is the default.
Question 48. How Many Types Of Sqr Files Are There?

Answer :

There are 5 forms of SQR documents:

SQC: SQC application documents contain typically included approaches which are referred to as by means of other SQR packages.
LIS whilst an SQR reviews generate output it's far sent to a document with an. LIS extension.
LOG: SQR.LOG record is the output record utilized by People tender. This document contains all statistics consisting of mistakes and displays statements. That is output to the terminal throughout the execution of SQR.
MAX: SQR does now not dynamically allocate reminiscence. The default application allocations (which had been coded for decrease        DOS memory) usually must be extended for complicated SQR packages.
Note: People smooth uses a .MAX file to growth any SQR parameter in which default is not ok for the program. There is one main .MAX file for processing underneath SQR W (home windows) known as ALLMAXES.MAX

SQT: These application documents are precompiled SQR programs. As a People tender 5+ there aren't any introduced precompiled SQR applications.
Question forty nine. What Is Difference Between .Lis And .Spf File?

Answer :

. LIS (list file) is used for line printer execution. Normally it's far used for printing cheques.
.SPF report is transportable format, that is used for all window-primarily based programs with any printer. Normally it's far used for MSPAINT, Image, and Graphics.
Question 50. What Is A Flag?

Answer :

It is an characteristic given to programming for processing and producing output destination record.

Question fifty one. What Is Sqr? Features Of Sqr?

Answer :

SQR (Structured Query Reports) is a programming language utilized in statistics processing and data reporting. 
SQR software can execute a couple of queries.
Features:

More flexible
Scalability for Client and Server structure.
Multiple platform portability
Multiple RDBMS portability