Interview Questions

Q:

Explain Check constraint.

Answer

Oracle check constraint is used to ensure that before inserting the data in the database, it is validated and checked for the condition.
Example:
Below, the constraint is that the id has to be between 0 and 1000.
create table employee ( id number check (id between 0 and 1000), Name varchar(200) );

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2904
Q:

Which of the following is not a RM principle?

A) Apply the RM process to situations where serious injury might occur B) Accept no unnecessary risk
C) Integrate RM into all phases of missions and activities D) Make risk decisions at the appropriate level
 
Answer & Explanation Answer: A) Apply the RM process to situations where serious injury might occur

Explanation:

Apply the RM process to situations where serious injury might occur is not a RM (Risk Management) principle.

 

Risk Management :: A decision-making process for managing day-to-day schedules when there are conflicts.

Report Error

View Answer Report Error Discuss

Filed Under: Conflict management
Exam Prep: Bank Exams , CAT
Job Role: Analyst , Bank Clerk

9 2903
Q:

Explain the use of keyword WITH ENCRYPTION. Create a Store Procedure with Encryption

Answer

It is a way to convert the original text of the stored procedure into encrypted form. The stored procedure gets obfuscated and the output of this is not visible to


CREATE PROCEDURE Abc


WITH ENCRYPTION


AS


<< SELECT statement>>


GO

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 2899
Q:

What’s the difference between htmlentities( ) and htmlspecialchars( )?

Answer htmlspecialchars only takes care of , single quote ‘, double quote " and ampersand. htmlentities translates all occurrences of character sequences that have different meaning in HTML.
Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 2899
Q:

Why do capital expenditures increase assets (PP&E), while other cash outflows, like paying salary, taxes, etc., do not create any asset, and instead instantly create an expense on the income statement that reduces equity via retained earnings ?

Answer

Capital expenditures are capitalized because of the timing of their estimated benefits – the lemonade stand will benefit the firm for many years. The employees’ work, on the other hand, benefits the period in which the wages are generated only and should be expensed then. This is what differentiates an asset from an expense.


 

Report Error

View answer Workspace Report Error Discuss

Subject: Accounts Receivable Exam Prep: Bank Exams , CAT
Job Role: Bank Clerk , Bank PO

4 2897
Q:

Which programming language was removed from the Visual Studio family when VB.net was released?

Answer

Visual Foxpro was part of Visual Studio 6.0.


It was excluded in the .Net version and was released as an independent programming language.

Report Error

View answer Workspace Report Error Discuss

0 2895
Q:

The shortcut key to quit from tally is

A) CTRL + Q B) CTRL + ESC
C) CTRL + T D) CTRL + P
 
Answer & Explanation Answer: A) CTRL + Q

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Bank Interview
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

1 2893
Q:

What are the restrictions when overriding a method ?

Answer

Overridden methods must have the same name, argument list, and return type (i.e., they must have the exact signature of the method we are going to override, including return type.)


The overriding method cannot be less visible than the method it overrides( i.e., a public method cannot be override to private).


The overriding method may not throw any exceptions that may not be thrown by the overridden method

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2892