|Hypertext Markup LanguageCascading Style SheetsExtensible Markup LanguageJava ScriptjQueryAngularJSOracle SQLOracle PL/SQLOracle D2K FormsOracle D2K ReportsOracle DatabaseJavaJava Database ConnectivityJava ServletJava Server PagesHibernateApache TomcatCC++PHPMy-SqlUnix/LinuxMS-DOSHR Interviews|
|How many Types of Reports available in Reports?|
There are eight different layout formats:
|What Types of Triggers are Available in Report?|
Report Level Triggers:
|What are Format triggers?|
Format triggers enable you to modify the display of objects dynamically at run time or to suppress display altogether For Headings, for repeating frames, for field, for boilerplate object To format a column based on certain criteria.
|What is Data Model?|
|Data Model is logically group of the Report Objects through query and Data model tools. Once query is compiled report automatically generates group. The queries build the groups and then Groups are used to populate the report. The only function of queries in report is to create the groups. The Report Editor's Data Model view enables you to define and modify the data model objects for a report.|
|What is Layout model?|
|Layout Model is to physically arrange Data model group objects on the Report. The Report Editor's Layout Model view enables you to define and modify the layout model objects for a report. In this view, objects and their property settings are represented symbolically to highlight their types and relationships.|
|What is Previewer?|
|Previewer is a work area in which you can preview your report and manipulate the actual or live data at the same time. In the Previewer you can customize reports interactively, meaning that you can see the results immediately as you make each change. In order to edit your report, such as changing column size, move columns, align columns insert page numbers, edit text, change colors, change fonts set format masks, insert field the Previewer must be in Flex Mode.|
|What is Parameter Form?|
|Parameters are variables for report that users can change at runtime immediately prior to the execution of the report. You can use system parameters to specify aspects of report execution, such as the output format, printer name, mailed or number of copies. We can also create own parameters through sql or Pl/sql at runtime. When you run a report, Report Builder uses the Parameter Form view as a template for the Runtime Parameter Form. If you do not define a Runtime Parameter Form in the Parameter Form view, Report Builder displays a default Parameter Form for you at runtime.|
|What is Query?|
|The first thing in data model is the query. Through query we access database objects with sql query. Compiled query creates groups. We can create query through query builder, sql query and import query from o/s file or database.|
|What is Group?|
|Groups are created to organize the columns in your report. When you create a query, Report Builder automatically creates a group that contains the columns selected by the query. You create additional groups to produce break levels in the report, either manually or by using the Report Wizard to create a group above or group left report.|
|What is Repeating Frame?|
|Repeating frames surround all of the fields that are created for a groupâ€™s columns. Repeating frames correspond to groups in the data model. Each repeating frame must to be associated with a group of data model the repeating frame prints (is fired) once for each record of the group.|
|What is Flex mode and Confine mode?|
|What is Page Break?|
|To limit the records per page.|
|What is Page Protector?|
|The Page Protect property indicates whether to try to keep the entire object and its contents on the same logical page. Setting Page Protect to Yes means that if the contents of the object cannot fit on the current logical page, the object and all of its contents will be moved to the next logical page. Ex: if you set yes, the object information prints another page.|
|What is the Print Condition?|
|The print condition type First, All, All but first, Last, All but last refer to the frequency with which you want to appear based upon the setting of the print condition object. A print condition object of Enclosing Object is whichever object encloses the current object (could be the parent or a frame within the parent), while Anchoring Object is the parent object (unless you have explicitly anchored the object in which case it is the object to which it is anchored).|
|What is Print Direction?|
|The Print Direction property is the direction in which successive instances of the repeating frame appear.|
|What is Vertical and Horizental Elasticity?|
|The Horizontal Elasticity property is how the horizontal size of the object will change at runtime to accommodate the objects or data within it, same for vertical elasticity to vertical direction.|
|General Knowledge of India|
How many coastal state are in India?
A person is to count 4500 currency notes. Let an denote the number of notes he counts in the nth minute. If a1 = a2 = .... = a10 = 150 and a10 , a11 ,... are in an AP with common difference – 2, then the time taken by him to count all notes is ?
The value of product 6 1/2 * 6 1/4 * 6 1/8 * 6 1/16 * -----∞ upto infinite terms?
What is nohup command in unix?
How do display the 10th, 11th and 12th line of a file in Unix?
The mean of 100 students marks was found to be 40. it was found later that a mark 53 was read as 83. the correct mean is?
The geometric mean of three observations 40, 50 and X is 10, then the value of X is ?
Who appoints the members of National human rights commission?
The President of India can resign by writing under his hand addressed to?
Under which article of the constitution of India can the President of India refer a matter to the Supreme Court for its opinion?
|General Computer Knowledge|
The term VPN stands for ?
The transmission control protocol(TCP) is a............ layer protocol ?
What is the difference between Procedure and Function?
Define exception and How will you raise an exception in PL/SQL procedure?
What is the advantage of using packages for storing PL/SQL objects?
|Fill in the blank|
I ________ station before the train arrived.
If I ______ a king, I would help everyone.
Radha___________her daughter for an hour.
Institute of Banking Personnel Selection (IBPS) - CRP SPL-IX - 1163 Posts - 26/11/2019 Last date
Reserve Bank of India (RBI) - 199 Posts - 11/10/2019 Last date
Life Insurance Corporation of India (LIC) - 7942 Posts - 01/10/2019 Last date
State Bank of India (SBI) - CRPD/APPR - 700 Posts - 06/10/2019 Last date
|Jobs in Jharkhand|
Jharkhand Staff Selection Commission (JSSC) -JANMCE - 1985 Posts - 04/10/2019 Last date
|Jobs in Madhya Pradesh|
National Health Mission (NHM) - 1392 Posts - 05/10/2019 Last date
|Jobs in Bihar|
Bihar Vidhan Parishad - 136 Posts - 11/10/2019 Last date
NABARD - 91 Posts - 02/10/2019 Last date
Institute of Banking Personnel Selection (IBPS) - CRP Clerks-IX - 12075 Posts - 09/10/2019 Last date
Haryana State Cooperative Apex Bank Ltd - 978 Posts - 31/08/2019 Last date