|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|
|What is Place holder Columns?|
|A placeholder is a column is an empty container at design time. The placeholder can hold a value at run time has been calculated and placed in to It by pl/sql code from anther object. You can set the value of a placeholder column is in a Before Report trigger , A report level formula column(if the place holder column is at report level) A formula column in the place holder group or a group below it. Uses of place holder columns enables u to populate multiple columns from one piece of code. U can calculate several values in one block of pl/sql code in a formula column and assign each value into a different placeholder column. U therefore create and maintain only program unit instead of many. Store a Temporary value for future reference.|
|What is Formula Column?|
|A formula column performs a user-defined computation on another column(s) data, including placeholder columns.|
|What is Summary columns?|
|A summary column performs a computation on another column's data. Using the Report Wizard or Data Wizard, you can create the following summaries: sum, average, count, minimum, maximum, % total. You can also create a summary column manually in the Data Model view, and use the Property Palette to create the following additional summaries: first, last, standard deviation, variance.|
|What is Boilerplate?|
Boilerplate is any text or graphics that appear in a report every time it is run. Report Builder will create one boilerplate object for each label selected in the Report Wizard (it is named B_Column name). Also, one boilerplate object is sometimes created for each report summary. A boilerplate object is owned by the object surrounding it, unless otherwise noted.
|What is Data Link?|
|When we join multiple quires in a report the join condition is stored in the data link section.Data links relate the results of multiple queries. A data link (or parent-child relationship) causes the child query to be executed once for each instance of its parent group. When you create a data link in the Data Model view of your report, Report Builder constructs a clause (as specified in the link's Property Palette) that will be added to the child query's SELECT statement at runtime. You can view the SELECT statements for the individual parent and child queries in the Builder, but can not view the SELECT statement that includes the clause created by the data link you define.|
|What is Query Builder?|
it's a gui tool to build a query in Report Wizard, Data Wizard or Data model.
|What is Break Column?|
|We can break a column through data model , it Display once for a group|
|How do u call Report from form?|
|RUN_PRODUCT and RUN_REPORT_OBJECT|
|What is the Firing sequence of report trigger?|
|The reports triggers are fired in the following sequence. Before Parameter Form After Parameter Form Before Report Between Pages After Report|
|What happens when Flex mode is on?|
|When flex mode is on, reports automatically resizes the parent when the child is resized.|
|What happens when confine mode on?|
|When confine mode is on, the object cannot be moved outside its parent in the layout.|
|What is the minimum number of groups required for a matrix report?|
|The minimum of groups required for a matrix report are 4|
|What is the use of an Anchor in Reports?|
|Anchor is used to make fixed distance between two objects in Reports Layout.|
|What is the difference between Frame and Repeating Frame?|
|Frames are used to surround other objects and protect them from being overwritten or pushed by other objects. For example a frame might be used to surround all objects owned by a group to surround column headings or to surround summaries. Repeating frames surround all of the fields that are created for a group’s columns. The repeating frame prints (is fired) once for each record of the group.|
|What are different types of column in reports?|
There are three types of columns in Oracle report:
|What are the various page layout sections in Oracle Reports ?|
A report has three sections :
What is the difference between Apache Tomcat server and Apache web server?
What is the full form of DOS?
Explain the use of help DOS Command?
How we can create a directory in DOS?
|Pipes and Cistern|
A tank can be filled by one tap in 10 minutes and by another in 30 minutes. Both the taps are kept open for 5 minutes and then the first one is shut off. In how many minutes more is the tank completely filled?
Assume that a sum of money is divided equally among n girls. Each girl will receive $60. If another girl is added to the group and the sum is divided equally among all the girls, each child girl gets a $50 share. What is the sum of money?
|Problems on Trains|
A 300 meter long metro train crosses a platform in a metro station in 39 seconds while it crosses a lamp post in 18 seconds. What is the length of the platform?
|Problems on Ages|
In a group of 7 people, the average age is found to be 17 years. Two more people joined with an average age 19 years. One person left the group whose age was 25 years. What is the new average age of the group?
|Profit and Loss|
Irvin sold a book at a profit of 12%. If Irvin had sold it for Rs 18 more, then 18% would have been gained. Find the cost price?
Non stick cooking utensils are coated with?
The group of metals Co, Ni, Fe may best called as?
|General Knowledge of India|
'Kanchipuram' is in which of the following states?
|General Knowledge of World|
In which year was Pulitzer Prize established?
The roads of cities in the Indus Valley Civilization generally divided the city into?
|Jobs in West Bengal|
इंडियन पोस्ट सर्विस Indian Post Service - 2357 पद - 19/08/2021 अंतिम तिथि - पश्चिम बंगाल पोस्टल सर्कल
भारतीय स्टेट बैंक State Bank of India(SBI) - 6100 पद - 26/07/2021 अंतिम तिथि - CRPD/APPR/2021-22/10
कर्मचारी चयन आयोग Staff Selection Commission(SSC) - 25271 पद - 31/08/2021 अंतिम तिथि
|Jobs in Madhya Pradesh|
राष्ट्रीय स्वास्थ्य मिशन मध्य प्रदेश National Health Mission MP(NRHM) - 5215 पद - 22/06/2021 अंतिम तिथि
|Jobs in Punjab|
पंजाब स्टेट पावर कॉर्पोरेशन लिमिटेड Punjab State Power Corporation Limited (PSPCL) - 2632 पद - 20/06/2021 अंतिम तिथि
|Jobs in Chhattisgarh|
स्वास्थ्य सेवा निदेशालय, छत्तीसगढ़ Department of Health & Family Welfare, Chhattisgarh - 267 पद - 26/06/2021 अंतिम तिथि
दिल्ली सबऑर्डिनेट सर्विस सिलेक्शन बोर्ड Delhi Subordinate Services Selection Board(DSSSB) - 5807 पद - 03/07/2021 अंतिम तिथि
|Jobs in Madhya Pradesh|
राष्ट्रीय स्वास्थ्य मिशन मध्य प्रदेश National Health Mission MP(NRHM) - 2850 पद - 31/05/2021 अंतिम तिथि
इंडियन पोस्ट सर्विस Indian Post Service - 4368 पद - 29/05/2021 अंतिम तिथि
दिल्ली सबऑर्डिनेट सर्विस सिलेक्शन बोर्ड Delhi Subordinate Services Selection Board(DSSSB) - 7236 पद - 24/06/2021 अंतिम तिथि