Top 20 Oracle BI Publisher Interview Questions and Answers

 

 

Ques. 1): What is the main difference between BI publisher and XML publisher?

Answer: BI publisher can be installed as a standalone version running off of several OC4J compliant engines, such as Application Server and Tomcat. BI publisher can be pointed anywhere, so that reports can be run out of an OLTP or warehouse database, MSSQL and even within EBS. Licensing is already included in EBS, and the standalone costs whatever plus maintenance. XML Pub operates entirely within EBS and can only be used within EBS.

Oracle Fusion Applications interview Questions and Answers

Ques. 2): What is a data template in BI publisher?

Answer: Data template is an xml structure which have the queries to be run for a database so that output can be generated in xml format, this generated xml output is further applied on a layout template for the final required output.

Oracle Accounts Payables Interview Questions and Answers

Ques. 3): What is the default output format of the report in BI publisher?

Answer: The default output format defined during the layout template creation will be used to generate the output, the same can be modified during the request submission and it will overwrite the one defined at layout template.

Oracle ADF Interview Questions and Answers                                 

Ques. 4): What are the various sections in the data template?

Ans: The various sections in the data template in BI publisher are as:

• Parameter section
• Lexical Section
• Trigger Section
• SQL statement section
• Data Structure section

Oracle Access Manager Interview Questions and Answers

Ques. 5): In BIP, how do you display the company logo in the report output?

Ans: In BIP, you can just copy and paste the logo (.gif, .jpg or any format) on the header section of .rtf file. Resize the log per the company standards.

Oracle Fusion HCM Interview Questions and Answers

Ques. 6): What is a layout template in BI publisher?

Answer: Layout template defines how the user views the output, basically it can be developed using Microsoft word document in rft (rich text format) or Adobe pdf format. The data output in xml format (from Data template) will be loaded in layout template at run time and the required final output file is generated.

Oracle SCM Interview Questions and Answers

Ques. 7): How do we create subtotals and Grand Total in BI Publisher?

Answer: If I have a report in OBIEE Answers with three columns –

Brand, Type and Revenue.

An OBIEE Report can be created as follows:

• Create the BI Publisher Report
• Login into bi publisher through word and open the BIP report
• Insert the table wizard and Add the columns Brand, Type and Revenue
• In the Group by – select Brand
• click the radio button of Group left
• click on finish.

Oracle Financials Interview questions and Answers

Ques. 8): In how many ways you can display images in a BI Publisher Report?

Answer: The images can be displayed in below 5 ways:

•     Direct Insertion into RTF Template
•     URL Reference
•     OA_MEDIA directory reference
•     Image from BLOB datatype from database
•     Using UI Beans

Oracle Cloud Interview Questions and Answers

Ques. 9): How to submit a layout in the backend?

Answer: we must write a procedure for this using the below code

FND_REQUEST.ADD_LAYOUT (

 TEMPLATE_APPL_NAME     => 'application name',

TEMPLATE_CODE           => 'your template code',

TEMPLATE_LANGUAGE       => 'En',

TEMPLATE_TERRITORY      => 'US',

OUTPUT_FORMAT           => 'PDF'

);

Oracle PL/SQL Interview Questions and Answers

Ques. 10): What are the various XML publisher tables?

Answer:

• PER_GB_XDO_TEMPLATES
• XDO_DS_DEFINITIONS_B
• XDO_DS_DEFINITIONS_TL
• XDO_DS_DEFINITIONS_VL
• XDO_LOBS
• XDO_TEMPLATES_B
• XDO_TEMPLATES_TL
• XDO_TEMPLATES_VL
• XDO_TEMPLATE_FIELDS
• XDO_TRANS_UNITS
• XDO_TRANS_UNIT_PROPS
• XDO_TRANS_UNIT_VALUES

Oracle SQL Interview Questions and Answers

Ques. 11): How to get SYSDATE in the header section dynamically when we run the report?

Answer: You cannot insert form fields in the Header section, but you can just insert the code to achieve this. For example: insert this in the header section to view the sysdate: You could format the date as you would like.

<?xdofx: sysdate(‘YYYY-MM-DD’)?>

Oracle RDMS Interview Questions and Answers

Ques. 12): How do you create a BI Publisher report with two sub reports?

Answer: If I have a report in OBIEE Answers with these columns –

• Year, Brand, Revenue
• Region, District, Revenue

An OBIEE Report can be created as follows:

• Create the BI Publisher Report
• Login into bi publisher through word and open the BIP report
• Insert the table wizard
• Add the columns Year, Brand and Revenue
• In the Group by select Year and Brand
• click the radio button of Group left
• click on finish.
• delete the ones indicated in circles
• create a table with 2 rows and 3 columns
• Give the column headings in the first row
• copy paste the following indicated by the arrow mark
• apply the necessary formating and delete the first table
• give the necessary aggregation as shown below
• create the other sub report similarly
• publish the template
• view it in bi publisher
• Thus, we can create sub reports in BI Publisher

Oracle 10g Interview Questions and Answers

 

Ques. 13): How to calculate the running total in XMLP?

Answer:

• <?xdoxslt:set_variable($_XDOCTX, ‘RTotVar’, xdoxslt:get_variable($_XDOCTX, ‘RTotVar’) + ACCTD_AMT(This is column name) )?>
• <?xdoxslt:get_variable($_XDOCTX, ‘RTotVar’)?>

 

Ques. 14): How to use Variables in XML publisher?

Answer: In XML publisher the declaration of variables can be done as:

Declaring the Variable R and Assigning the Values 4 to R

<?xdoxslt:set_variable($_XDOCTX, ‘R’, 4)?>

Get the Variable value
<?xdoxslt:get_variable($_XDOCTX, ‘R’)?>

This adds 5 to variable R and displays it
<?xdoxslt:set_variable($_XDOCTX, ‘R’, xdoxslt:get_variable($_XDOCTX, ‘R’)+5)?>

This subtracting 2 to varaible R and displays it

<?xdoxslt:set_variable($_XDOCTX, ‘R’, xdoxslt:get_variable($_XDOCTX, ‘R’)-2)?>

 

 

 

Top 20 C language Interview Questions & Answers

 

Ques: 01. Why is C language being considered a middle level language?

Ans: This is because C language is rich in features that make it behave like a high level language while at the same time can interact with hardware using low level methods. The use of a well structured approach to programming, coupled with English-like words used in functions, makes it act as a high level language. On the other hand, C can directly access memory structures similar to assembly language routines.


Ques: 02. What are preprocessor directives?

Ans: Preprocessor directives are placed at the beginning of every C program. This is where library files are specified, Explain Which would depend on Explain What functions are to be used in the program. Another use of preprocessor directives is the declaration of constants.Preprocessor directives begin with the # symbol.


Ques: 03. Where does global, static, and local, register variables, free memory and C Program instructions get stored?

Ans: Global: Wherever the linker puts them. Typically the ―BSS segment on many platforms.Static: Again, wherever the linker puts them. Often, they‘re intermixed with the globals. The only difference between globals and statics is whether the linker will resolve the symbols across compilation units.Local: Typically on the stack, unless the variable gets register allocated and never spills.Register: Nowadays, these are equivalent to ―Local variables. They live on the stack unless they get register-allocated.


Ques: 04. What are header files and Explain What are its uses in C programming?

Ans: Header files are also known as library files. They contain two essential things: the definitions and prototypes of functions being used in a program. Simply put, commands that you use in C programming are actually functions that are defined from within each header files. Each header file contains a set of functions. For example: stdio.h is a header file that contains definition and prototypes of commands like printf and scanf.


Ques: 05. What does the format %10.2 mean when included in a printf statement?

Ans: This format is used for two things: to set the number of spaces allotted for the output number and to set the number of decimal places. The number before the decimal point is for the allotted space, in this case it would allot 10 spaces for the output number. If the number of space occupied by the output number is less than 10, addition space characters will be inserted before the actual output number. The number after the decimal point sets the number of decimal places, in this case, it?s 2 decimal spaces.


Ques: 06. Describe about storage allocation and scope of global, extern, static, local and register variables?

Ans:Globals have application-scope. They‘re available in any compilation unit that includes an appropriate declaration (usually brought from a header file). They‘re stored wherever the link erputs them, usually a place called the ―BSS segment. Extern? This is essentially ―global. 

Static: Stored the same place as globals, typically, but only available to the compilation unit that contains them. If they are block-scope global, only available within that block and its subblocks.

Local: Stored on the stack, typically. Only available in that block and its subblocks.(Although pointers to locals can be passed to functions invoked from within a scope where that local is valid.)

Register: See tirade above on ―local vs. ―register. The only difference is that the C compiler will not let you take the address of something you‘ve declared as ―register.
 

Ques: 07. Describe the order of precedence with regards to operators in C.

Ans: Order of precedence determines Explain Which operation must first take place in an operation statement or conditional statement. On the top most level of precedence are the unary operators !, +, – and &amp;. It is followed by the regular mathematical operators (*, / and modulus % first, followed by + and -). Next in line are the relational operators &lt;, &lt;=, &gt;= and &gt;. This is then followed by the two equality operators == and !=. The logical operators &amp;&amp; and || are next evaluated. On the last level is the assignment operator =.


Ques: 08. What is output redirection?

Ans: It is the process of transferring data to an alternative output source other than the display screen. Output redirection allows a program to have its output saved to a file. For example, if you have a program named COMPUTE, typing this on the command line as COMPUTE &gt;DATA can accept input from the user, perform certain computations, then have the output redirected to a file named DATA, instead of s Explain Howing it on the screen.


Ques: 09. What is a far pointer? Where we use it?

Ans: In large data model (compact, large, huge) the address B0008000 is acceptable because in these model all pointers to data are 32bits long. If we use small data model(tiny, small, medium) the above address won‘t work since in these model each pointer is 16bits long. If we are working ina small data model and want to access the address B0008000 then we use far pointer. Far pointer is always treated as a 32bit pointer and contains a segment address and offset address both of16bits each. Thus the address is represented using segment : offset format B000h:8000h. For any given memory address there are many possible far address segment : offset pair. The segment register contains the address where the segment begins and offset register contains the offset of data/code from where segment begins.


Ques: 10. Explain What is the difference between the expression “++a” and “a++”?

Ans: In the first expression, the increment would happen first on variable a, and the resulting value will be the one to be used. This is also known as a prefix increment. In the second expression, the current value of variable a would the one to be used in an operation, before the value of a itself is incremented. This is also known as postfix increment.


Ques: 11. What is the difference between functions getch() and getche()?

Ans: Both functions will accept a character input value from the user. When using getch(), the key that was pressed will not appear on the screen, and is automatically captured and assigned to a variable. When using getche(), the key that was pressed by the user will appear on the screen, while at the same time being assigned to a variable.


Ques: 12. What are macros? What are its advantages and disadvantages?

Ans: Macros are abbreviations for lengthy and frequently used statements. When a macro is called the entire code is substituted by a single line though the macro definition is of several lines.The advantage of macro is that it reduces the time taken for control transfer as in case of function. The disadvantage of it is here the entire code is substituted so the program becomes lengthy if a macro is called several times.


Ques: 13. What is an endless loop?

Ans: An endless loop can mean two things. One is that it was designed to loop continuously until the condition within the loop is met, after Explain Which a break function would cause the program to step out of the loop. Another idea of an endless loop is when an incorrect loop condition was written, causing the loop to run erroneously forever. Endless loops are oftentimes referred to as infinite loops.


Ques: 14. Why is it that not all header files are declared in every C program?

Ans: The choice of declaring a header file at the top of each C program would depend on Explain What commands/functions you will be using in that program. Since each header file contains different function definitions and prototype, you would be using only those header files that would contain the functions you will need. Declaring all header files in every program would only increase the overall file size and load of the program, and is not considered a good programming style.


Ques: 15. Difference between pass by reference and pass by value?

Ans: Pass by reference passes a pointer to the value. This allows the callee to modify the variable directly.Pass by value gives a copy of the value to the callee. This allows the callee to modify the value without modifying the variable. (In other words, the callee simply cannot modify the variable, since it lacks a reference to it.)


Ques: 16. What is dynamic data structure?

Ans: Dynamic data structure provides a means for storing data more efficiently into memory. Using dynamic memory allocation, your program will access memory spaces as needed. This is in contrast to static data structure, wherein the programmer has to indicate a fix number of memory space to be used in the program.


Ques: 17. What could possibly be the problem if a valid function name such as tolower() is being reported by the C compiler as undefined?

Ans: The most probable reason behind this error is that the header file for that function was not indicated at the top of the program. Header files contain the definition and prototype for functions and commands used in a C program. In the case of ?tolower()?, the code ?#include ? must be present at the beginning of the program.


Ques: 18. What will be the outcome of the following conditional statement if the value of variable s is 10?

Ans: s &gt;=10 &amp;&amp; s &lt; 25 &amp;&amp; s!=12 The outcome will be TRUE. Since the value of s is 10, s &gt;= 10 evaluates to TRUE because s is not greater than 10 but is still equal to 10. s&lt; 25 is also TRUE since 10 is less then 25. Just the same, s!=12, Explain Which means s is not equal to 12, evaluates to TRUE. The &amp;&amp; is the AND operator, and follows the rule that if all individual conditions are TRUE, the entire statement is TRUE.


Ques: 19. What is FIFO?

Ans: In C programming, there is a data structure known as queue. In this structure, data is stored and accessed using FIFO format, or First-In-First-Out. A queue represents a line wherein the first data that was stored will be the first one that is accessible as well.


Ques: 20. What are enumerated types?

Ans: Enumerated types allow the programmer to use more meaningful words as values to a variable. Each item in the enumerated type variable is actually associated with a numeric code. For example, one can create an enumerated type variable named DAYS whose values are Monday, Tuesday… Sunday.

Top 20 PowerShell Interview Questions & Answers

Ques: 1. What do you understand by PowerShell?

Ans: With PowerShell, you can control your system operations such as accessing data storage, registry, and file system. PowerShell is a command-line tool built upon the .NET framework to help the windows system administrator. The operations in the command line are executed by cmdlets. Cmdlets are .NET classes to implement operations in the PowerShell.

It also has a good expression parser and a scripting language to control and automate the administration of the windows system. This open-sourced tool was developed by Microsoft and released in 2006.

 BlockChain Interview Question and Answers

Ques: 2. What is $null in PowerShell?

Ans: The $null is a variable in the PowerShell that is used to represent NULL as the name suggests. It can be assigned to a variable, use it for comparisons, etc. In PowerShell, $null is an object that holds the value of NULL. To assign $null, use the following command

PS> $null –eq $variable

Here, the $variable holds the value of $null.

Ques: 3. Can you explain String Interpolation in PowerShell?

Ans: The String Interpolation is the way of displaying the value of the variable by surrounding the variable in the double-quotes.

//example

$var = “Nature”

Echo “the value is $var”

The above statement produces the ‘value is Nature’. Here the $var is surrounded by double quotes when used in the echo statement. So, it prints the value of the variable instead of the variable name itself. It is called string interpolation.

Ques: 4. What are cmdlet's in PowerShell?

Ans: The PowerShell cmdlet (Command let) is just a group of commands that are used in the PowerShell to perform a function. It is a lightweight .NET framework class object that is invoked by the PowerShell runtime. Programmers can create and invoke it manually too. You can construct your cmdlet by grouping a few lines of PowerShell code. The cmdlet has a .ps1 extension.

Ques: 5. How to call a function in powershell?

Ans: To call a function in PowerShell, first, you have to declare the function using the function keyword. Then to call the function, just type and enter the function name.

//example

function functionName {

$args[0] - $args[1]

}

PSC:\>functionName 10 5 5

You can also pass arguments to the called function as you see in the example above.

Ques: 6. What are Filters in PowerShell?

Ans: A lot of commands in the PowerShell return values that are not always useful. To get useful return objects from the commands we can use filters. Filters can be created using the Filter parameter or even using the Where-Object. We can use the Filter parameter with the Get-ChildItem to get the items that we specified in the filter.

//example

PS> Get-ChildItem -Path C:\folder\ -Filter '*1*.txt'

The above command filters and returns the files with a prefix as ‘1’. The same result can be achieved using the Where-Object, but generally, the filter is much faster than the Where-Object.

Ques: 7. What are $Home and $PID in PowerShell?

Ans: The $HOME is an automatic variable in the PowerShell. It contains the path of the user’s home directory. It is equivalent to C:\Users\. The $PID is also an automatic variable that contains the process identifier of the process which is hosting the PowerShell’s current session.

Ques: 8. Is PowerShell’s Execution Policy a security layer?

Ans: No. The execution policy in PowerShell is part of the security strategy but merely prevents potentially malicious scripts being executed by accident and, with the ‘ allsigned ‘ policy ensures that scripts cannot be altered without your knowledge. By default, this setting is set to ‘ Restricted ‘, meaning that no PowerShell script file can be run but it will execute PowerShell code within the PowerShell console.

Ques: 9. What is $Error and $ForEach variable?

Ans:

$Error – This variable contains an array of error objects which represents the most recent errors. The most recent error is the first error in the array.

$ForEach – This variable contains the enumerator (should not be confused with the resulting values) of a for each loop. Properties and methods of enumerators can be used on the value of the $ForEach variable. This kind of variable exists only while the for each loop is in running state, and it is deleted once the loop is completed.

Ques: 10. Explain Execution Policies and types of Execution Policy?

Ans: This is the common PowerShell Interview Questions asked in an interview. There are 6 types of execution policies in PowerShell. These are:-

• Restricted: This is the default type. Under this, PowerShell will not run any script including PowerShell profiles too.
• RemoteSigned: PowerShell will only run any script that is created locally. Any script that has been coming from the Internet should be digitally signed with a signing certificate code and is trusted by the computer.
• AllSigned: PowerShell will only run any script that has been digitally signed using a trusted code signing certificate.
• Unrestricted: PowerShell will run any script. If the script comes from an untrusted source, users are prompted once to execute it.
• Bypass: This policy will run any script without any question or prompt.
• Undefined: There is no execution policy set for this in the current scope.

Ques: 11. What is the PowerShell order in which execution policy is evaluated?

Ans: Windows PowerShell has execution policies in the following order of precedence: 

• Group Policy: Example is Computer Configuration.
• Group Policy: Example is User Configuration.
• Execution Policy: Such as Process (or PowerShell.exe -Execution Policy) – which is the CURRENT SCOPE.
• Execution Policy: Such as Current User – Which is SAVED in the HKCU registry.
• Execution Policy: Such as Local Machine – which is SAVED in the HKLM registry.

Ques: 12. Can you explain the differences between the concept of WMI between old and new?

Ans:

Old WMI

• Uses old-style native code providers and a repository for itself.
• Available only on Windows as mentioned.
• It has been more or less deprecated which means it’s is not focused on further improvement or development.

New WMI

• Supports old-style native code providers and a repository, as well as new-style MI providers as discussed.
• Available only on Windows as mentioned.
• This is the way forward. It has an essentially stateless relationship with the remote machine.

Ques: 13. What are the various Differences between OMI and CIM.?

Ans:

OMI

• It uses WS-MAN where OMI code includes the protocol stack od WS-MAN. It supports only new-style MI providers.
• It is available on any implementing platform. If something can talk to OMI, it will be able to talk to NEW WMI as well.

CIM

• It defines the standard. It is created by DMTF.
• In this case, early versions were implemented as OLD WMI actually by Microsoft, but the newest version implemented both in NEW WMI and OMI by Microsoft as well as others.

Ques: 14. What are the differences among WinRM and WSMan and DCOM?

Ans:

 

WSMan: 

• WS-Management abbreviated as WSMAN or Web Services-Management is basically a Distributed Management task force.
• It is an open standard which defines a SOAP-based (full form Simple Object Access Protocol) protocol for the management of its servers, devices, applications and also various Web services.

WinRM:

• WinRM is a feature which came from Windows Vista and it allows administrators to remotely run management scripts.
• It can handle remote connections using the WS-Management Protocol.

DCOM:

• DCOM means Distributed COM.
• It is used to connect LIVE objects which are on the remote machine.
• The RPC protocol that it uses was designed for continuous back-and-forth messaging.
• It is network and memory inefficient.

Ques: 15. What are Scriptblocks?

Ans: Scriptblocks are one of most Powerful concept of PowerShell. By definition, is a collection of statements or expressions between “{” and “}” that can be used as a single unit. It can be stored in a variable, can be passed to function and can be executed remotely by the operator “&”

Syntax :

{<statement list>}

Like functions, a scriptblock can include parameters :

              {

            param ([type]$parameter1 [,[type]$parameter2])

            } 

And script blocks can include the DynamicParam, Begin, Process, and End keywords.

 

Ques: 16. What is Variable Interpolation?

Ans: When you add a variable to a double-quoted string, PowerShell replaces the variable name by its value. This feature is called variable interpolation.

              $HighOne = "Love"

"The most powerful Emotion is $HighOne" 

Output:

PS C:\Users\Administrator>

$HighOne = "Love"
"The most powerful Emotion is $HighOne"

"The most powerful Emotion is Love

PS C:\Users\Administrator>

Ques: 17. What is the {0} -f that I saw in some string codes?

Ans: This is string formatting using the PowerShell format operator. In PowerShell, you do not need to use “+” operator to concatenate strings. Actually is more in-tune with PowerShell syntax if you use interpolation or the -f (from format)

It is simple. You add the placeholder {N} and then type a command-separated list of values in order to be replaced. {0} represents the first value in the command-separated list, {1} the second and so on.

Ques: 18. What is a hash table in PowerShell?

Ans: Hash table is a data structure which used the mechanism of value/key pair. The professionals who create PowerShell scripts use variables to store data. For the storage of data in a highly secure environment hash table is used.

Ques: 19. How is Windows Powershell different from Stsadm ?

Ans: Unlike stsadm, which accept and return text, Windows PowerShell is built on the Microsoft .NET Framework and accepts and returns .NET Framework objects. In addition to that it also gives you access to the file system on the computer so that you can access registry,digital signature certificate etc.

Ques: 20. How Do You Comment Out Code In Powershell?

Ans: Like other languages powershell also supports single/Inline comments line and multi line comments.

Starting with PowerShell V1 there’s only # to make the text after it a comment.

In PowerShell V2 “<# #>” can be used for block comments (multi-line) and more specifically for SYNOPSIS, DESCRIPTION, NOTES, LINK help comments.

Example: Sinlgle/Inline comments

 # This is a single or inline comment starts with hash in Powershell

Example: Block comments (multi-line)

<# this is a first line of comment

 this is a second line of comment

this is a third line of comment

.

.

this is a last line of comment

#>