Interview Questions

Q:

How can you generate debugging output from PL/SQL?

Answer

Use the DBMS_OUTPUT package. Another possible method is to use the SHOW ERROR command.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 4652
Q:

What is meant by exception specification?

A) A function is limited to throwing only a specified list of exceptions. B) A catch can catch all types of exceptions.
C) A function can throw any type of exceptions. D) none of the mentioned
 
Answer & Explanation Answer: A) A function is limited to throwing only a specified list of exceptions.

Explanation:

C++ provides a mechanism to ensure that a given function is limited to throwing only a specified list of exceptions. It is called as exception specification.

Report Error

View Answer Report Error Discuss

Filed Under: C++

0 4650
Q:

How can you implement a condition in a workflow?

Answer

You can implement a condition by using either of the following ways:




     =>   By creating a rule condition - Specifies that you can implement conditions either directly in code or by using a tool, called the Rule Condition Editor. Rule conditions are stored in a separate Extensible Markup Language (XML) file. When a rule condition occurs in a workflow, the expression in a condition is evaluated and a Boolean value is returned.

     =>   By creating a code condition - Refers to defining a condition directly in code. A code condition can be created by writing a method in the code. The method contains code for the condition and returns a Boolean value.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

1 4626
Q:

Explain the working with directories using opendir(), readdirs(), closedir() along with examples.

Answer

Opendir():- It opens the directory. This function returns a directory stream on success and FALSE and an error on failure.


Syntax:


Opendir(directory, context)


Context is a set of options that can modify the behavior of a stream


Example: opens sample directory.


$dir = opendir("directory");


 


Readdir(): It returns an entry from a directory handle opened by opendir().


Syntax:


Readdir(dir_stream)


Example:


$file = readdir($dir);


 


closedir(): It closes a directory handle opened by opendir().


Syntax:


closedir(dir_stream)


Example:


$file = close($dir);

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 4616
Q:

What is the difference between JOIN and UNION?

Answer

SQL JOIN allows access to records of other table based on the given conditions between two tables.


Ex: If we are provided with the department ID of each employee, then we can use the department ID of the employee table to merge with the department ID of the department table to access department names.


UNION operation allows addition of 2 similar data sets to create a resulting set that contains all the data from the source data sets.


Ex: If we are provided with 2 employee tables of the same structure, we can UNION them to create a singular result that will contain all employee from both the table.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

1 4614
Q:

Does VB Supports OOPS Concepts?

Answer

Visual Basic is not support Inheritance and Data binding OOPS Concept 

Report Error

View answer Workspace Report Error Discuss

7 4613
Q:

How can we extract string "abc.com" from a string "https://info@abc.com" using regular _expression of php?

Answer

We can use the preg_match() function with “/.*@(.*)$/” as the regular expression pattern.
For example:
preg_match("/.*@(.*)$/","https://info@abc.com",$data);
echo $data[1];
?>

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 4611
Q:

What is SLR rate?

Answer

SLR Rate is the minimum amount or percentage of the deposits that a bank has to keep with the RBI in the form of money,gold or any other approved security. In simple terms it is the ratio between cash and some approved security.

Report Error

View answer Workspace Report Error Discuss

Subject: Bank Interview

1 4603