Envié una solicitud electrónica. Acudí a una entrevista en Infosys (Nabarangapur) en jul 2022
Entrevista
Difference b/w Primary key and unique key.
Is unique key with not null constraint same as primary key?
2. Difference b/w Having and Where?
3. Can we decrement values in sequence?
4. What will you suggest if I want to delete a huge no. of records from an existing table.
5. Question about exceptions, how will you handle an exception about sequence
if the maximum value of the sequence has been reached (if seq max value is 100000 and the next customer Id is 100001)
6. How do you check for Null values in a table?
7. How can you improve a query for faster retrieval of data?
Some questions of sub nested queries.
Asked 4-5 questions on Sequence.
Asked few questions about functions and overloading.
Some questions on Performance tuning and full table scan
Otras opiniones sobre las entrevistas para el puesto de Plsql Developer en Infosys
Envié una solicitud electrónica. El proceso duró 1 día. Acudí a una entrevista en Infosys (Chennai) en oct 2021
Entrevista
It was overall a difficult interview for me and it went around for 1 hr. It was online interview via MS teams.
The questions were basically related to how developments and cost estimations are done