Freshers Technical Interview Questions.

I could see there is lot of struggle for clearing this technical round.

So I wish I could help you out with these following questions.  Guys be clear with basic syntax of any one programming language to build your logic.  Either of these C/C++/JAVA

Just practice these logic and try building the programs, execute it and enjoy programming.  If you were not able to do it, its okay, we have source in the net, check that out!!!

1.  Palindrome or not.
2.  Amstrong number or not.
3.  Print the following when n=4

    *
    **
    ***
    ****

4.  Print the following when n =5

         1
       121
     12321
   1234321
 123454321

5.  Find odd/even
6.  Find Prime number or not.
7.  Swap two numbers without using temporary variable.
8.  Call by value, call by reference.
9.  Escape sequence.
10.  Pointers in C
11.  Types of testing.
12.  Difference between black box testing and white box testing
13.  What is regression testing.
14.  What is system testing.
15.  What is database.  why do we need database.
16.  What are the types of database.

Answers for PL/SQL Questions.

Praise to GOD!!

You may find better answers for these if you browse through.  But to brush up before going to the interview, this may help you to remember in a faster way.  Please correct me if I had made any mistakes.

All the very best guys..

Please find the list of Capgemini PlSQL and Unix interview questions.

When they start to ask about what is cursor.  You mention what is cursor, and types of cursor, difference between them.

1.  What is Cursor,
Cursor means
CUrrent
Set
Of
Records.

The private SQL area which holds this Current set of records for processing a query for DML operations (INSERT, Update, Delete)

2.  Types of Cursor

Implicit and explicit cursors.

Implicit cursors are the select statements that are used to retrieve more than one row from the table/tables.  Where we don't explicitly specify the CURSOR keyword.

Whereas in Explicit cursor, we declare and define the cursor, we open the cursor, fetch the records, and process the records and close the cursor.

(Here they might ask you this question, what if, you don't close the cursor after the cursor is used.  Prepare for it as well)

They may ask you to define few types of attributes as CURSOR NOT FOUND, INVALID_CURSOR.


3.  What is trigger.
(Oracle definition)
Oracle lets you define procedures called triggers that run implicitly when an INSERT, UPDATE, or DELETE statement is issued against the associated table or, in some cases, against a view, or when database system actions occur. These procedures can be written in PL/SQL or Java and stored in the database, or they can be written as C callouts.

Source:  http://docs.oracle.com/cd/B10500_01/server.920/a96524/c18trigs.htm

4.  Types of Triggers.
Source:  http://docs.oracle.com/cd/B10500_01/server.920/a96524/c18trigs.htm

5.  What is mutating error.

There are two exceptions to this recursion:

• When a triggering statement modifies one table in a referential constraint (either the primary key or foreign key table), and a triggered statement modifies the other, only the triggering statement will check the integrity constraint. This allows row triggers to enhance referential integrity.
• Statement triggers fired due to DELETE CASCADE and DELETE SET NULL are fired before and after the user DELETE statement, not before and after the individual enforcement statements. This prevents those statement triggers from encountering mutating errors.

6.  Is it possible to commit/Rollback inside a Function.  (If yes, how, if no, why?)
Search as Autonomous transaction

8.  How to add trailing zeros to numbers.
LPAD(). RPAD()

Capgemini PlSQL Interview Questions

Hey Guys,

Please find the list of Capgemini PlSQL and Unix interview questions.

1.  What is Cursor,
2.  Types of Cursor
3.  What is trigger.
4.  Types of Triggers.
5.  What is mutating error.
6.  Is it possible to commit/Rollback inside a Function.  (If yes, how, if no, why?)
7.  INSTR() purpose.
8.  How to add trailing zeros to numbers.
9.  Difference between Static and dynamic cursor.
10.Connect by Prior.
11.Correlated Sub query.
12.What are the types of Collections.
13.What are bind variables.
14.What is table partitioning. and types
15.What is view.
16.Difference between view and materialized view.
17.Cascade constraints are used when?
18.How to display the day of the year.
19.What are invisible indexes.
20.What is Raise application error.
21.How to add a not null column to a table with data.


Unix:
1. What are the types of editors
2. How to navigate through editors.
3. Purpose of Cat command.
4. Purpose of Grep command.
5. Purpose of mv, rm, cd commands.
6. Use of cron tab.
7. Types of shell