Oracle Interview Questions

Oracle-DBA Expert

Interviewed at Centroid Systems

3.8★

Oct 27, 2022

1) Day to day task 2) checking basic wheatear is it clear are not.

What is difference between row cursor and select cursor

details about datapump questions on all oracle database objects like view,snapshot,synonym,etc questions on GG what is trandata, logdump, architechture

DBA ORACLE

Interviewed at GMS (Argentina)

2.7★

Oct 30, 2020

Preguntas generales de la vida personal , pequeño examen de conocimientos escrito.

Oracle HCM Cloud Consultant

Interviewed at LTM Limited

3.4★

Aug 2, 2023

Errors encountered during payroll process run

It's 10am on Wednesday morning and you get a call from 2 users saying a report they run daily that normally takes 5 mins to run, has been running for the past 30 mins. Q. What questions would you ask ? How would you go about resolving the situation ? Q. How would you identify fragmentation ? How would you resolve it ?

Oracle PlSql Developer

Interviewed at Changepond

3.4★

Feb 28, 2020

Trigger, sub queries, Mview

R12 AP Invoice is partial accounted and invoice payment is done and accounting created, but we can see partial accounted.

Write one sample query related to joins and sub query

Oracle Database Administrator

Interviewed at In-Solutions Global

3.4★

Jan 28, 2017

list Various listener commands, diff btn lock and latch, types of standby databases available, calculate cache hit rate and miss rate, groupby orderby diff...