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
Hi Jyothi,
ReplyDeleteThanks for highlighting this and indicating about Capgemini PlSQL Interview Questions where more study and thought is necessary.
Is is true the number of people with Unix skills , is really declining?
A lot of Microservices, serverless computing bandwagon is seen on the market, does it means Unix/Linux and servers will be non-existent in future?
Appreciate your effort for making such useful blogs and helping the community.
Thank you,
Irene Hynes