trig,procedure and function,delete and drop
Ingeniero De Software Oracle Interview Questions
537 ingeniero de software oracle interview questions shared by candidates
Questions on performance tuning
Logfile sync, wait events, scattered vs sequential read and when to be concerned, heterogenous DB migration, liquibase, jenkins pipelines for databases, git webhooks
Pagination atomic integer interface and abstract class optimistic and pessimistic logging streams
Asked all the questions about Oracle basic to advaced PLSQL. Given queries to remove duplicate records and to fetch the 3rd highest salary.
types of subqueries? and difference between them? types of triggers? types of trigger? write a trigger which will using do insert, update and delete on 'employee' table and keep audit in 'audit' table. if inserting insert into table also in audit table if deleting delete from also insert in audit table if upadte is require then update table and this update entry should insert in audit table types of cursors and create procedure take cursor and display emp name and salary.? what is database name? database structure you use to create database objects?
What are the constraints in MySQL?
Probability of getting 2, 2nd time when threw a dice.
Angle between hour hand and minute hand at 3:15.
Why you are looking for change(switch job)?
Viewing 181 - 190 interview questions