|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 are various types of parameters ?|
There are two types of parameters:
|Apart from the global report triggers what are the other triggers used in Oracle Reports?|
Other types of triggers :
|How do you display a message in reports?|
|Name some of the procedures in the SRW package ?|
|SRW.Message, SRW.User_Exit, SRW.Do_Sql, SRW.Run_Report|
|What is SRW Package?|
|The Report builder Built in package know as SRW Package (Sql Report Writer) This package extends reports, Control report execution, output message at runtime, Initialize layout fields, Perform DDL statements used to create or Drop temporary table, Call User Exit, to format width of the columns, to page break the column, to set the colors Ex: SRW.DO_SQL, It’s like DDL command, we can create table, views, etc.|
|What is User Parameters?|
|Parameter, which is created by user. For to restrict values with where clause in select statement. We can use Lovs in user parameter with static and Dynamic Select Statement.|
|What is System Parameters?|
These are built-in parameters provided by Oracle corporation.
COPIES Is the number of report copies that should be made when the report is printed.
DESFORMAT Is the definition of the output devices format (e.g., landscape mode for a printer). This parameter is used when running a report in a character-mode environment, and when sending a bitmap report to a file (e.g. to create PDF or HTML output).
DESNAME Is the name of the output device (e.g., the file name, printers name, mail userid).
DESTYPE Is the type of device to which to send the report output (screen, file, mail, printer, or Screen using PostScript format).
MODE Is whether the report should run in character mode or bitmap.
ORIENTATION Is the print direction for the report (landscape, portrait,default).
PRINTJOB Is whether the Print Job dialog box should appear before the report is run
|What are the different types of anchors in Reports?|
|A There are two types of anchors in Oracle Reports: Implicit (Creates when a report will run) Explicit (Anchors you create)|
|What is the difference between Bind and Lexical parameter?|
1-Bind parameters are used to replace a single value in SQL or PL/SQL, such as a character string, number, or date.
|How can you print one record per page in the output?|
|You can set the maximum records per page property of the Repeating frame to|
|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