|Hypertext Markup LanguageCascading Style SheetsExtensible Markup LanguageJava ScriptjQueryAngularJSOracle SQLOracle PL/SQLOracle D2K FormsOracle D2K ReportsOracle DatabaseJavaJava Database ConnectivityJava ServletJava Server PagesHibernateApache TomcatCC++PHPMy-SqlUnix/LinuxMS-DOSHR Interviews|
|Can we execute native SQL query in hibernate?|
Hibernate does provide a way to use native SQL statements to supports special database features through its dialect of SQL that are not supported in HQL.
Thanks for your comment.!
Write a comment(Click here) ...
|What is Hibernate?|
Hibernate is an Object/Relational Mapping solution for Java environments.
Hibernate not only takes care of the mapping from Java classes to database tables, but also provides data query and retrieval facilities.
|What is Object Relational Mapping (ORM)?|
Object/Relational Mapping refers to the technique of mapping data from an object model representation (Java Object) to a relational data model (database tables) representation.
|Explain advantage and disadvantage of ORM model?|
Advantages of ORM frameworks:
Database vendor independence: An ORM is abstracts layer for an application and gives you the portability to support multiple databases.
Reduction in development effort: An ORM frameworks manage metadata and API for database access and management,that increases productivity and speed up in coding.
Maintainability: An ORM work through configuration which allow sharing, reusability and fewer lines codes for DB operation that requires less maintenance.
Disadvantages of ORM frameworks:
Overhead: For simple and small applications, ORM framework can be overhead which required configuration, mapping and object management.
Performance impact: An ORM API do extra work to support efficient object state management with database table.
|What are the advantage of Hibernate?Or Difference between JDBC and Hibernate?|
Hibernate is database independent, same code will work for all kind of database like Oracle,MySql,SQLServerDerby, DB2PostGreSQL etc.
There is no need to create connection pools in case of Hibernate. Where in JDBC, connection pools need to be created.
Hibernate Supports Caching(1st level & 2nd level cache), that improve application’s performance andretains the objects in cache that reduce repeated hits to the database.While in JDBC you need to implement your java cache.
Development become fast,you don’t need to be an expert of writing complex and tune queries, as Hibernate take care of Query writing and tuning process .While in case of JDBC, its job of developer to write queries and tune them.
Hibernate support Lazy loading and Load objects only when required.
|Explain hibernate architecture? Or Basic Hibernate APIs?|
Hibernate architecture has following components:
Configuration (org.hibernate.cfg.Configuration):It represents database connection and O/R mapping setup. It will be used to build SessionFactory.
SessionFactory (org.hibernate.SessionFactory):It’s a Singleton, thread-safe and immutable cache of compiled mappings for a single database. SessionFactory instantiate Session object.
Session (org.hibernate.Session): A single-threaded, lightweight, short-lived object and designed to be instantiated on an interaction with database for persistent store.
Persistent objects and collections: Short-lived, single threaded objects containing persistent state and business function.These can be ordinary JavaBeans/POJOs and associated with org.hibernate.Session.
Transient objects and collections: Instances of persistent classes that are not currently associated with an org.hibernate.Session.
Transaction (org.hibernate.Transaction): A single-threaded, short-lived object used by the application to specify units of work and to maintain integrity in the database.
Query (org.hibernate.Query):It is an object oriented representation of Hibernate query that help w to retrieve data from database. A query instance is obtained by calling session.createQuery().
|What is hibernate SessionFactory and Session?|
SessionFactory: The SessionFactory is a heavyweight object, and there would normally be a single instance of this per application. It is thread-safe as it is created one per database and can be concurrently accessed by multiple threads. It is created using Configuration object and used to create session object.
Session: The Session is used to communicate between application and persistent store (database). This is factory for org.hibernate.Transaction. As it is not thread-safe, application should create and destroy it once a unit of work done though it may be used to multiple units as per requirement. It also represents a transaction in a database.
|Is hibernate SessionFactory thread safe?|
|Is hibernate Session thread safe?|
|What is POJOs?|
POJO (Plain Old Java Objects) is a simple Java Bean class with some properties. This class uses standard Java Bean naming conventions with private visibility of properties and getter and setter methods of that.
|What is caching and define it for ORM perspective?|
Caching is one of the important features implemented by an application for better Performance. an ORM perspective, data retrieved from a database is cached in memory or to disk, so there is no need to hit database for every request.
Cached data is available at three different scopes in an application:
Transaction scope: data is fetched in one session, and the same query is executed again in that same session before that unit of work is completed. This data is stored in memory/disk by default, so the call to the database for the second query is avoided. Because a unit of work is for one request, this data isn't shared or accessed concurrently.
Process scope: Data is cached across sessions or across units of work. If a query is executed in one session, and the same query is executed in a second session after closing the first, this data is cached so that the second call to the database is avoided. Because two requests can access the same data in these two sessions, this data is accessed concurrently. You should use this scope with caution.
Cluster scope: Data is shared between multiple processes on the same machine or on different machines in a cluster.
|Explain different caching strategies are in Hibernate?|
Hibernate have following three different caching strategies:
First-level cache: It is at the transaction level and enabled by default in Hibernate. Caching at the first level is associated with a session. If the same query is executed multiple times in the same session, the data associated with the query is cached.
Second-level cache: It is configured at the process level or the cluster level. In Hibernate, you can configure it for a particular class or for a collection to improve performance. You can use the second-level cache with large and complex object graphs that may be loaded often. It is associated with one SessionFactory and can be reused in more than one Session created from the same SessionFactory.
Query result sets cache: It is useful when you run a particular query often with the same parameters. By default, the queries aren't cached and requires two additional physical cache regions that hold the cached query result sets and the timestamp when a table was last updated.
|What is difference between transient,persistent and detached object in hibernate? Or Explain life cycle of an object in Hibernate?|
Object in hibernate has following states:
Transient - Objects instantiated using the new operator are called transient objects.
An object is transient if it has just been instantiated using the new operator, and it is not associated with a Hibernate Session. It has no persistent representation in the database and no identifier value has been assigned. Transient instances will be destroyed by the garbage collector if the application does not hold a reference anymore.
Persistent - An object that has a database identity associated with it is called a persistent object.
A persistent instance has a representation in the database and an identifier value. It might just have been saved or loaded; however, it is by definition in the scope of a Session. Hibernate will detect any changes made to an object in persistent state and synchronize the state with the database when the unit of work completes.
Detached - A detached instance is an object that has been persistent, but its Session has been closed.
A detached instance can be reattached to a new Session at a later point in time, making it persistent again. This feature enables a programming model for long running units of work that require user think-time. We call them application transactions, i.e., a unit of work from the point of view of the user.
|What is removed state of object in hibernate?|
A persistent object is considered to be in the removed state when a delete() or remove() operation is called on it. The delete() method is provided by a Hibernate session, whereas the remove() method is provided by the JPA.
|How many ways we can query data from Database in Hibernate?|
Hibernate provides three different queries way to retrieve data
Hibernate supports an object oriented query language (HQL) which is an extension of SQL. It is a database independent and translated into SQL at runtime.
Hibernate query language is very efficient, simple and flexible query language to do various type of operations on relational database without writing complex database queries.
HQL syntax is not case sensitive but Java classes and properties names are case sensitive in HQL query.
|What is criteria API?|
Criteria API allows you to build up a query object dynamically. The Criteria Query API lets you build nested, structured query expressions in Java, providing a compile-time syntax-checking that is not possible with a query language like HQL or SQL
Hibernate provided createCriteria() methods to create a Criteria object and Restrictions class for expression .
|Pipes and Cistern|
Two pipes A and B can fill a tank in 6 hours and 4 hours respectively. If they are opened on alternate hours and if pipe A s opened first, in how many hours, the tank shall be full?
A large tanker can be filled by two pipes A and B in 60 min and 40 min respectively. How many minutes will it take to fill the tanker from empty state if B is used for first half of the time, and A and B fill it together for the other half?
A tank is filled by 3 pipes with uniform flow. The first two pipes operating simultaneously fill the tank in the same time during which the tank is filled by the third pipe alone. The 2nd pipe fills the tank 5 hours faster than first pipe and 4 hours slower than third pipe. The time required by first pipe is?
Two pipes A and B together can fill a cistern in 4 hours. Had they been opened separately, then B would have taken 6 hours more than A to fill the cistern. How much time will be taken by A to fill the cistern separately?
Two pipes A and B can fill a tank in 24 min and 32 min respectively. If both the pipes are opened simultaneously, after how much time B should be closed so that the tank is full in 18 min?
Two pipes A and B can fill a tank in 36 min and 45 min respectively. A water pipe C can empty the tank in 30 min. First A and B are opened. after 7 min, C is also opened. In how much time, the tank is full?
Two pipes can fill a cistern in 14 hours and 16 hours respectively. The pipes are opened simultaneously and it is found that due to leakage in the bottom it took 32 min more to fill the cistern. When the cistern is full, in what time will the leak empty it?
Bucket P has thrice the capacity as Bucket Q. It takes 60 turns for Bucket P to fill the empty drum. How many turns it will take for both the buckets P and Q, having each turn together to fill the empty drum?
In a class , 30 % of the students offered English, 20 % offered Hindi and 10 % offered Both.If a student is offered at random, what is the probability that he has offered English or Hindi?
In a lottery ,there are 10 prizes and 25 blanks.A lottery is drawn at random. what is the probability of getting a prize ?
Two dice are thrown simultaneously .what is the probability of getting two numbers whose product is even?
Two diced are tossed the probability that the total score is a prime number?
Two cards are drawn at random from a pack of 52 cards What is the probability that either both are black or both are queens?
Two dice are thrown together .What is the probability that the sum of the number on the two faces is divisible by 4 or 6?
A bag contains 6 white and 4 black balls .Two balls are drawn at random .Find the probability that they are of the same colour?
In a simultaneous throw of a pair of dice,find the probability of getting a total more than 7?
An unbiased die is tossed.Find the probability of getting a multiple of 3?
|Problems on Ages|
My brother is 3 years elder to me. My father was 28 years of age when my sister was born while my mother was 26 years of age when i was born. If my sister was 4 years of age when my brother was born,then what was the age my father and mother respectively when my brother was born?
बैंकिंग कार्मिक चयन संस्थान Institute of Banking Personnel Selection(IBPS) - 7855 पद - 29/07/2022 अंतिम तिथि
कर्मचारी चयन आयोग (एसएससी) Staff Selection Commission (SSC) - 1411 पद - 29/07/2022 अंतिम तिथि
|Jobs in Rajasthan|
राजस्थान अधीनस्थ और मंत्रिस्तरीय सेवा चयन बोर्ड Rajasthan Subordinate and Ministerial Services Selection Board (RSMSSB) - 5546 पद - 22-Jul-2022 अंतिम तिथि
उत्तर मध्य रेलवे भर्ती प्रकोष्ठ Railway Recruitment Cell(NCR) - 1659 पद - 01/08/2022 अंतिम तिथि
|Jobs in West Bengal|
इंडियन पोस्ट सर्विस Indian Post Service - 2357 पद - 19/08/2021 अंतिम तिथि - पश्चिम बंगाल पोस्टल सर्कल
भारतीय स्टेट बैंक State Bank of India(SBI) - 6100 पद - 26/07/2021 अंतिम तिथि - CRPD/APPR/2021-22/10
कर्मचारी चयन आयोग Staff Selection Commission(SSC) - 25271 पद - 31/08/2021 अंतिम तिथि
|Jobs in Madhya Pradesh|
राष्ट्रीय स्वास्थ्य मिशन मध्य प्रदेश National Health Mission MP(NRHM) - 5215 पद - 22/06/2021 अंतिम तिथि
|Jobs in Punjab|
पंजाब स्टेट पावर कॉर्पोरेशन लिमिटेड Punjab State Power Corporation Limited (PSPCL) - 2632 पद - 20/06/2021 अंतिम तिथि
|Jobs in Chhattisgarh|
स्वास्थ्य सेवा निदेशालय, छत्तीसगढ़ Department of Health & Family Welfare, Chhattisgarh - 267 पद - 26/06/2021 अंतिम तिथि