Interview Questions and Answers for 'Oracle' | Search Interview Question

Interview Questions and Answers - Order By Newest

Q31. How to know the default column value of a Table in Oracle ?

Database

Ans. Select DATA_DEFAULT
from DBA_TAB_COLUMNS
where TABLE_NAME = '' and COLUMN_NAME='';

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve sql database oracle}

Q32. Difference between JDBC and Hibernate ?

Database

Ans. JDBC is a standard Java Api for Database communication whereas Hibernate is an ORM framework that uses JDBC to connect with Database.

Hibernate is another layer of object table mapping over JDBC that provide a database independent, object oriented and an efficient way of database communication.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve JDBC Hibernate JDBC vs Hibernate Asked in 3 Companies}

Q33. What is the difference between Oracle , Cassandra and Redis ?

Database

Ans. Oracle is a relational database. Cassandra is a noSQL Database whereas Redis is an inmemory cache.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve oracle casandra redis}

Q34. What is the order in which triggers gets fired ?

Database

Ans. There is no specific order in which database fires the triggers if they are for the same operation. If we need to have a specific order for their execution, we should have them all in a stored procedure and the procedure should get executed upon the event.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve oracle database triggers sequence of trigger execution sequence in which triggers gets fired Asked in 1 Companies}

Q35. What is the difference between JDBC, Hibernate and ODBC ?

Database

^{This question was recently asked at 'Oracle Argentina'.This question is still unanswered. Can you please provide an answer.}

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve jdbc odbc hibernate jdbc vc odbc jdbc vs hibernate Asked in 1 Companies}

Q36. How different is the Search algorithm when we query Cassandra Tables and When we query Oracle Tables ?

Cassandra

Ans. Relational Database uses linear search if we don't query using indices. Performance for linear search is O(n). If indices have been used , relational database uses binary search. Performance for binary search is O(Log n).

Casandra uses hash search. Performance for Hash Search is O(1).

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve cassandra vs oracle nosql vs relational search algorithm}

Q37. Can we override wait() or notify() ?

Core Java

Ans. No, because these are final.

public final void wait() throws InterruptedException

public final void notify()

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve wait notify Asked in 1 Companies}

Q38. How did you use Spring in your project ? Which Spring annotations have you used in your project ?

Spring

Ans. @RequestMappping

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve spring spring annotations Asked in 1 Companies}

Q39. Write a program to make a triangle of stars.

^{This question was recently asked at 'Oracle'.This question is still unanswered. Can you please provide an answer.}

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve Asked in 1 Companies}

Q40. All the meaningful words that can be formed from a phone keypad

^{This question was recently asked at 'Oracle'.This question is still unanswered. Can you please provide an answer.}

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve Asked in 1 Companies}

Q41. Interface vs Abstraction

Core Java

^{This question was recently asked at 'Oracle financial services'.This question is still unanswered. Can you please provide an answer.}

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve interface vs abstraction interfacing vs abstraction relation between interface and abstraction How interface provide abstraction Asked in 1 Companies}

Q42. Explain your current project architecture.

Architecture

^{This question was recently asked at 'Oracle financial services'.This question is still unanswered. Can you please provide an answer.}

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve project architecture Asked in 1 Companies}

Q43. Explain Servlet config

Java EE

^{This question was recently asked at 'Oracle financial services'.This question is still unanswered. Can you please provide an answer.}

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve servlet servlet config Asked in 1 Companies}

Search Interview Questions

Help us and Others Improve. Please let us know the questions asked in any of your previous interview.