Hibernate MCQs (FREE Multiple Choice Questions)

1: JDBC stands for_____.

A. Jeremy Does Backflips Consistently

B. Java Does Best Connection

C. Java DataBase Connection

D. Just Do Both Carefully

2: Which of the following correctly describes SessionFactory?

A. A single-threaded, short-lived object representing a conversation between the application and the persistent store

B. Short-lived, single threaded objects containing persistent state and business function

C. Instances of persistent classes that are not currently associated with a org.hibernate.Session

D. A thread-safe, immutable cache of compiled mappings for a single database

3: Hibernate will assume an instance is an unsaved transient instance if:

A. The identifier property (if it exists) is null

B. All of these

C. You supply an unsaved-value in the mapping document for the class, and the value of the identifier property matches

D. The version property (if it exists) is null

4: Which of the following statements are true about Hibernate catching:

A. The first level caching is provided by the EntityManager

B. The first level caching is limited to a particular user or request

C. Hibernate provides 2 levels of caching

D. All of these

5: Which of the following XML elements is true for Hibernate?

A. <hibernate-hibernate>

B. <hibernate-java-java>

C. <hibernate-mapping>

D. <hibernate-tabular>

6: A persistent framework is a(n) ____ service that stores and gets objects into a database.

A. modular

B. open

C. ORM

D. OS

7: Which is true:

A. Session.Cloak()

B. Session.Close();

C. Session.Close

D. Session.Cloak

8: Which of the following shortcomings are addressed by Hibernate Search?

A. The API mismatch

B. The structural mismatch

C. The duplication mismatch

D. All

9: The createhibernate.cfg.xml is a/an ____ configuration file.

A. MXL

B. LMX

C. XXML

D. XML

10: What instructs Hibernate how to map the classes to the database?

A. A variable

B. The Declare statement

C. xpath mapping file

D. XML mapping file

11: Java is a/an _____ language

A. client

B. tough

C. javascript

D. Object-Oriented

12: Hibernate is a high performance ORM. ORM stands for?

A. object redundant marker

B. object real maker

C. object relational marker

D. object relational mapping

13: If Hibernate does not commit the transaction it can _______.

A. zip it up

B. backflip

C. rollback

D. fallback

14: A database _____ data.

A. stores

B. tabs

C. non-persists

D. grows

15: Java is to the business logic as ____ is to the database

A. vbscript

B. javascript

C. SQL

D. perl

16: SessionFactory is _____.

A. delayed

B. self-orienting

C. thread safe

D. lousy

17: Which of the following is TRUE about Hibernate Search?

A. Hibernate Search works well in clustered mode

B. Hibernate Search provides synchronous and asynchronous index updates

C. Hibernate Search works well in non-clustered mode

D. All

18: An ORM solution should consist of which of the following functions:

A. Specifying queries that refer to classes and properties of classes

B. Performing basic CRUD operations on objects of persistent classes

C. All of these

D. Specifying mapping metadata

19: The reason for Hibernate is because their is a mismatch or impedance between the object model and the ____?

A. rational database

B. revised database

C. relational database

D. redundant database

20: Query objects use ____ to retrieve data from the relational database

A. HQL

B. C#

C. .Net

D. Java

21: Hibernate takes care of mapping Java to the database using ___?

A. xpath

B. XML

C. PL-SQL

D. XSLY

22: POJO stands for_____.

A. Plain Ole Java Object

B. Plain Old Java Object

C. Plaine Ole Java Object

D. Plaine Old Java Object

23: Databases represent data in a ____ format.

A. tabular

B. delimited

C. reformatted

D. delayed

24: A _______ represents a measure of work done in the database.

A. sproc

B. UDF

C. transaction

D. table

25: The Hibernate framework is stored in (a) _____.

A. browser

B. javascript

C. JAR

D. XML

26: Which of the following is TRUE about @GeneratedValue annotation?

A. Its is used to specify the table to persist the data

B. It is used to mark this class as an Entity bean

C. It is used to specify the identifier property of the entity bean

D. It is used to specify the primary key generation strategy

27: A/an ______ is a primitive data type.

A. Variable

B. OOP

C. SQL

D. Integer

28: The configuration object class is used to create a(n) ____?

A. SessionFactory

B. Rational Database

C. ArrayList

D. VariableRepository

29: Which of the followings might be able to solve N+1 problem?

A. add @Fetch annotation and specify a FetchMode of JOIN

B. add @Fetch annotation and specify a FetchMode of SUBSELECT

C. use LEFT JOIN FETH clause on the HQL

D. All of these

30: The ____ element is used to link data to the database.

A. <HTML>

B. <JAVA>

C. <property>

D. <XML>

31: Which of the following correctly describes Hibernate Envers?

A. Facilitates auditing of Hibernate mappings, which extend JPA, like custom types and collections/maps of "simple" types (Strings, Integers, etc.)

B. Facilitates auditing of all mappings defined by the JPA specification

C. Facilitates querying historical data

D. All

32: Which of the following is a VALID key component of Hibernate Configuration?

A. Both database connection and class mapping setup

B. Class mapping setup but NOT database connection

C. Database connection but NOT class mapping setup

D. SessionFactory but NEITHER database connection NOR class mapping setup

33: Which of the following property makes hibernate to generate SQL as per the chosen database?

A. dialect

B. session

C. transaction

D. driver_class

34: Which of the following property needs to be defined to activate second-level caching?

A. transactionManager

B. hibernate-configuration

C. sessionFactory

D. cache.provider_class

35: Which of the following are valid Hibernate interceptors?

A. Session-scoped

B. Session-scoped but NOT SessionFactory-scoped

C. Both Session-scoped and SessionFactory-scoped

D. SessionFactory-scoped

36: Which of the following is NOT true about Metamodel?

A. All

B. javax.persistence.metamodel.Metamodel acts as a repository of metamodel objects and provides access to them

C. Handle to javax.persistence.metamodel.Metamodel can be obtained from either the javax.persistence.EntityManagerFactory or the javax.persistence.EntityManagervia their getMetamodel method

D. The metamodel is a set of objects that describe a domain model

37: Which one of the following statements is true about detached instance?

A. An instance will be detached after it gets retrieved from the database by the execution of query.

B. Changes made to the detached instance are still guaranteed to synchronize with the database.

C. A persistent instance will become detached after the session is closed.

D. Hibernate does NOT allow you to re-associate detached instances with a new persistence manager.

38: Which one of the following statement is NOT true about SessionFactory?

A. You can use SessionFactory to create Session instance

B. SessionFactory is not lightweight and is expensive to create

C. One SessionFactory can manage more than one database

D. The SessionFactory caches generated SQL statements and other mapping meta data that Hibernate uses at runtime

39: Which of the following elements is used to declare the persistent class in Hibernate configuration file?

A. <property>

B. <session-factory>

C. <mapping>

D. <hibernate-configuration>

40: Which of the following provides an interface between application and data stored in the database?

A. Transaction

B. Session

C. TransactionFactory

D. ConnectionProvider

41: Which of the following is NOT a valid value for 'hbm2ddl.auto' property in hibernate configuration?

A. validate

B. truncate

C. create

D. update

42: Which one of the following statements is true about the instance states?

A. Detached instants can be made persistent by calling saveOrUpdate()

B. Transient instants can be made persistent by calling delete()

C. Transient instants are previously persistent and associated with an unique session

D. Persistent instants can be made transient by calling update()

43: Which one of the following statements is NOT true about ordering query result?

A. You can use asc and desc to specify ascending and descending order

B. You cannot order query results by more than one properties

C. The default ordering is ascending

D. HQL provides an ORDER BY clause for ordering query result

44: Which one of the following statements is NOT true about named queries?

A. The named query must be HQL strings. Native SQL is not supported in named query

B. The getNamedQuery() method obtains a query instance of named query

C. Named queries are precompiled when session factory is created

D. Named queries allow externalizing query strings to the mapping metadata

45: Which of the following is NOT a type of hibernate cache?

A. First Level Cache

B. Application layer level cache

C. Transaction layer level cache

D. SQL cache

46: Hibernate offers an implementation of which specification?

A. ORM

B. JDBC

C. JMS

D. JPA

47: Which of the following is NOT true about Session and Transaction scope in Hibernate?

A. Multiple instances of SessionFactory are created, usually on application startup, from a Configuration instance

B. A Session is an inexpensive, non-threadsafe object that should be used once and then discarded for: a single request, a conversation or a single unit of work

C. In order to reduce lock contention in the database, a database transaction has to be as short as possible

D. A SessionFactory is an expensive-to-create, threadsafe object, intended to be shared by all application threads

48: Which one of the following statements is NOT true about persistence annotations?

A. The @Table annotation can be used to specify mapping database schema name

B. The @Column annotations is used to specify the column name of the foreign key

C. The @Entity annotation indicates that the class is mapped to a table in database

D. The @Id annotation indicates the field is the primary key for the entity

49: Which of the following is the FIRST Hibernate object that is created in any Hibernate application?

A. Configuration

B. Transaction

C. Session

D. SessionFactory

50: Which one of the following statement is NOT true about Hibernate's Query interface?

A. If the query returns more than result for the uniqueResult() method, the first one will be returned.

B. Both the createQuery() and createSQLQuery() method of Session interface can return a Query instance

C. You can paging the query result by using setFirstResult() and setMaxResult() method

D. You can use method chaining (methods return receiving object instead of void) with Query interface

51: Which one of the following statements is NOT true about comparison operator in HQL?

A. You can use = NULL to test whether the value is null

B. The HQL where clause supports arithmetic expressions

C. The where clause is a logical expression evaluating to true false or null

D. The "like" operator allows wildcard(%) searches

52: Which of the following is NOT true about default flush operation in Hibernate?

A. Hibernate flushes by default before some queries

B. Hibernate flushes by default when session.flush() is executed

C. Hibernate flushes by default when commit() is executed

D. Hibernate NEVER flushes by default

53: Which of the following statement is TRUE about sorting in Hibernate?

A. A sorted collection is sorted in-memory using java comparator, while order collection is ordered at the database level using order by clause

B. An order collection is sorted in-memory using java comparator, while sorted collection is ordered at the database level using order by clause

C. A sorted collection is either sorted in-memory using java comparator or using order by clause at the database level

D. An order collection is either sorted in-memory using java comparator or using order by clause at the database level

54: Which of the following is an INVALID LockMode?

A. OPTIMISTIC_FORCE_INCREMENT

B. UPDATE

C. PESSIMISTIC_FORCE_INCREMENT

D. OPTIMISTIC

55: Which one of the following statements is NOT true about hibernate Session?

A. Session is Hibernate's interface for persistence-related operations such as storing and retrieving objects

B. An instance of Session is lightweight and is inexpensive to create and destroy.

C. Hibernate session has nothing to do with the web-tier HttpSession.

D. Hibernate can detect changes to the objects and make updates to the database automatically even if changes are made within the same session.

56: Which one of the following statements is true?

A. The load() method and get() method of Session interface are same

B. The load() method can return a poxy than immediately hitting the database.

C. The load() method of Session interface will return null if no row find in the database

D. The get() method of Session interface will throw exception if no row find in the database

57: Which one of the following statement is true about the following query: FROM Item AS item WHERE item.description like ? AND item.date > ?

A. The as keyword is optional

B. The query indicates that there is a table named item and has columns named as "description" and "date"

C. The index of binding parameter start from 1 instead of 0

D. The FROM WHERE AND are HQL keywords and has to be uppercase

58: Which of the following is used by Hibernate to redirect the logging output to preferred logging frameworks?

A. log4j

B. JCL

C. Simple Logging Facade for Java (SLF4J)

D. JDK logging

59: Their are five mismatches that occur when storing objects in relational database:granularity,inheritance,identity,associations and

A. files

B. data

C. databases

D. navigation

60: Which one of the following statements is NOT true about embedded objects?

A. The @AttributeOverride annotation defines what type the database uses to save the embeddable field

B. The @Embedded annotation means the annotated field is embeddable type

C. User @Emebeddable on a class means it's fields and properties will be persistable as part of another entity.

D. The Embeddable type can be reused on other types

61: Which of the following is NOT true about First Level Cache?

A. Hibernate uses this cache by default

B. It loads objects and make them available to the entire application

C. it reduces the number of generated SQL queries within a given transaction

D. It always "associates" with the Session object

62: Which of the following is NOT a valid caching strategy?

A. Read-only

B. Write-only

C. Nonstrict read/write

D. Read/write

63: Which one of the following statements is true about how Hibernate retrieves an object?

A. You cannot retrieve objects using native SQL queries in Hibernate

B. HQL Hibernate Query Language is a full object oriented query language

C. When you're using get() method to retrieve an object that doesn't exist in the database, Hibernate will throw an exception

D. When you using load() method to retrieve an object that doesn't exist in the database, Hibernate will return null

64: Object-oriented languages represent data as a ____ of objects

A. delimited

B. tabular

C. array

D. graph

65: Which one of the following statements is NOT true about entity lifecycle events?

A. If the timestamp of the most recent update made to the queried table is early than the timestamp of the cached query results, then the cached results are discarded

B. UpdateTimestampsCache is a special cache region that holds timestamps of the most recent updates to each table

C. The query cache must be enabled using a Hibernate property setting:hibernate.cache.use_query_cache true

D. Hibernate allows you to specify a different named cache region for each query

66: Which one of the following statements is NOT true about many to many relationship mapping?

A. The many to may relationship can be both unidirectional or bidirectional

B. mappedBy element must be included for the bidirectional many to many relationship

C. The @JoinColumn and @InverseJoinColumns are used to defined the column names of the foreign keys in the join table

D. The @JoinTable annotation must be defined on the reverse side of the many to many relation ship

67: Which one of the following statements is NOT true about using components in Hibernate?

A. Hibernate component is the lowest level of unit and cannot own other component

B. We can declare a component of an entity by using <component> element

C. Component is the user defined class that is persisted to the table of owning entity

D. Hibernate support both unidirectional and bidirectional composition

68: Which of the following is NOT true about Hibernate OGM (still being developed)?

A. It is a persistence engine providing Java Persistence (JPA) support for NoSQL storage solutions

B. It is expected to be used to interact with all NoSQL solution in all use cases

C. It reuses Hibernate Core's object life cycle management and (de)hydration engine but persists entities into a key/value store instead of a relational database

D. It reuses the Java Persistence Query Language (JP-QL) as an interface to querying stored data

69: Which one of the following statements is NOT true about Hibernate's cascading persistence?

A. cascade ="delete" tells Hibernate to navigate the association when performing delete

B. cascade="all-delete-orphan" is the same as cascade="all" in addition it deletes any persistent instant when it get dereferenced

C. cascade="save-update" is the default setup in hibernate

D. cascade ="none" tells hibernate to ignore association

70: Which one of the following statements is true about using annotation to setup Inheritance Models?

A. The default value of discriminatorType element in @DiscriminatorColumn is DiscriminatorType.INTEGER

B. the @Inheritance annotation is used on the subclass to setup the inheritance mapping strategy

C. the @DiscriminatorValue annotation is used to specify the value in the in the discriminator column in database

D. the name element of @DiscriminatorColumn annotation specify the name of table

71: Which of the following statements is true about using cache in Hibernate?

A. Caching query will have more impact on applications that perform many inserts, deletes or updates.

B. The iterate()method of the Session and Query interfaces is provided to take advantage of second-level cache.

C. The query cache cache all the entities properties returned in the query result set

D. To enable query cache all it needs is to invoke setCacheable(true) on the query instance.

72: Which one of the following statements is NOT true about HQL joins?

A. Path navigation from one entity is a form of outer join.

B. Join conditions can be specified explicitly by using the 'join' keyword

C. An inner join between two entities returns the objects from both entity types that satisfy all the join conditions

D. Join conditions can be specified implicitly as a result of path navigation.

73: Which of the following is NOT true about Second Level Cache?

A. It is called 'second-level' because there is already a cache operating in Hibernate for the duration of an open session

B. It always "associates" with the Session Factory object

C. It exists as long as the session factory is alive

D. By default it effectively holds on to the identifiers for an individual query

74: Which of the following statements is NOT true about mapping one class to multiple tables using annotation?

A. entities may be mapped across multiple tables by making use of the @SecondaryTables annotation

B. The "table" attribute needs to be defined in the @Column annotation to specify which table the column belongs

C. The @PrimaryKeyJoinColumn annotation specifies the primary key of the primary table

D. entities may be mapped across multiple tables by making use of the @SecondaryTable annotation

75: Which of the following does NOT correctly describe LockMode.NONE?

A. It represents the absence of a lock

B. All objects switch to this lock mode at the end of a Transaction

C. Objects associated with the session via a call to update() or saveOrUpdate() also start out in this lock mode

D. If an object is requested with this lock mode, a WRITE lock will be obtained if it is necessary to actually read the state from the database

76: Which one of the following statements is NOT true about using annotation mapping Entity hierarchies?

A. The @Inheritance annotation has a "strategy" attribute which can be used to define the inheritance mapping strategy

B. The @DiscriminatorColumn is used to defined the named of the column that is used to differentiate subclasses

C. The root class of the hierarchy needs to be marked by the @Inheritance annotation

D. The @DiscriminatorValue doesn't have default value and must be defined.

77: Which of the following statement is NOT true?

A. The load() method returns null, when the unique id could not found in the database

B. The load() method returns proxy by default and the data base will not be effected until the invocation of the proxy

C. The load() method throws an exception,when the unique id could not found in the database

D. The get() method returns null when the unique id is unavailable in the database.

78: Which of the following correctly describes org.hibernate.SQL log category?

A. Log all SQL DDL statements as they are executed

B. Log all SQL DML statements as they are executed

C. Log all JDBC parameters

D. Log the state of all entities

79: Which one of the following statements is NOT true about join strategy (table per subclass)?

A. It is more is expensive to query subclass when using join strategy

B. Join strategy is the most efficient way to insert data

C. Join strategy is the most efficient way to store data

D. In join strategy every class will have its state mapped to a different table

80: Which one of the following statements is NOT true about entity lifecycle events

A. Firing of a PostPersist event does not indicate that the entity has committed successfully to the database

B. If the PERSIST cascade option is set on a relationship of an object that is being persisted and the target object is also a new object, the PrePersist event is triggered on the target object.

C. The PostLoad callback occurs after the data for an entity is read from the database and the entity instance is constructed.

D. When the SQL for deletion of an entity gets sent to the database, the PostRemove event will get fired and it indicates success of deletion

81: Which of the following is NOT a valid id generator class?

A. hilo

B. primary

C. identity

D. sequence

82: Which one of the following statements is NOT true about the following HQL query: from Item item join item.bids bid where item.description like '%gc%' and bid.amount > 100

A. The query returns a List of Object[] arrays

B. The query assigns the alias "item" to the class ITEM and alias "bid" to the Bid class

C. The query returns all combinations of associated Bids and Items

D. The bids collection of each Item will be eagerly loaded.

83: Which one of the following statements is true about entity type and value type in Hibernate?

A. An object of value type always has a primary key value in the database

B. Value type objects belongs to an entity and is embedded in the table row of owning entity

C. An object of Entity type does NOT have its own database identity

D. An Entity type object cannot exist independently and has to bond to another object

84: Which one of the following statements is True about the following query: from Item as I where i.description = :description

A. the Item indicates the name of the entity class and it's case sensitive

B. The query is using native SQL syntax

C. the letter I is alias and the "as" keyword must be place in front of the alias

D. this query is using positional parameter binding

85: Which one of the following statement is NOT true about many to one relationship mapping?

A. The @JoinColumn must be defined with @OneToMany annotation

B. The @JoinColumn defines the name of the foreign column

C. If the relationship is bidirectional mappedBy attribute must be defined for the @OneToMany annotation

D. The @ManyToOne defines a single-valued association to another entity class that has many-to-one multiplicity.

86: Which one of the following statements is NOT true about transient state?

A. objects referred by other transient instances are transient

B. Transient instance is always associated with a row in a database

C. After a persisted instance gets deleted, it'll become a transient instance

D. Objects instantiated using new operator aren't persisted immediately and their state is transient.

87: Which of the following is not TRUE about StatelessSession interface/implementation in Hibernate Batch?

A. It does not provide many of the higher-level life cycle semantics

B. A stateless session does not implement a first-level cache

C. A stateless session has no persistence context associated with it

D. Operations performed using a stateless session cascade to associated instances

88: Which of the following is NOT a valid org.hibernate.ConnectionReleaseMode?

A. ON_OPEN

B. AFTER_TRANSACTION

C. AFTER_STATEMENT

D. ON_CLOSE

89: Which one of the following statements is true about the following HQL query: select department from Department department join department.employees employee where employee.address.state = 'CA' and department.name='marketing'

A. The query is using outer join

B. The department objects returned are lazy loaded.

C. The query will return all departments not matter the department has an employee or not

D. The query returns a List of Object[] arrays, at index 0 is Department and Index 1 is Employee

90: Which of the following correctly describes org.hibernate.cache log category?

A. Log all first-level cache activity but NOT second-level cache activity

B. Log NEITHER first-level NOR second-level cache activity

C. Log both first-level and second-level cache activity

D. Log all second-level cache activity

91: If you want to save your modifications at any time without knowing about the state of an session, then which of the following operations will you use:

A. Neither Merge nor Update

B. Merge

C. Update

D. Both Merge and Update

92: Which of the following statements is NOT true about persistent instance?

A. Any change made on the persistent object will be synchronized with the database after the transaction ends.

B. Before session get closed, an object will becomes persistent after it get saved by the persistence manager's save() method.

C. A persistent instance has a primary key set as its database identifier

D. An object is not persistent if it's retrieved from the database by the execution of query.

93: Which one of the following statements is true about joining associations in Hibernate?

A. In HQL the LEFT keyword in LEFT JOIN FETCH is optional

B. When using HQL join queries you have to explicitly specify the join condition using either WHERE or ON clause

C. HQL provides a fetch join in the FROM clause to lazy load the associated objects

D. When using outer joins, Hibernate will always return a list containing distinct items.

94: Which of the following statements is True about one to one relationship mapping?

A. mappedBy element should be specified in the @OneToOne annotation in the entity that defines a join column

B. One to one mapping can only be unidirectional

C. The @JoinColumn annotation goes on the mapping of the entity that is mapped to the table containing the foreign key

D. One to one mapping can only be bidirectional

95: Which one of the following statement is NOT true about single table inheritance strategy?

A. The single table strategy uses one table to contain all the possible state of a hierarchy

B. Single table strategy will be more wasteful of database space.

C. There shouldn't be any columns left unfilled in the single table strategy

D. The single table strategy is the most performance way in polymorphic queries and write operations.

96: Which of the following is NOT true about SessionFactory?

A. Its a Singleton class

B. Its initialization process is expensive as it loads all configurations including database setting, OR settings

C. It helps in customized extraction of data.

D. Configures HIBERNATE with HIBERNATE configuration file for use in application

97: Which one of the following statements is NOT true about using annotation to map Compound Primary Key?

A. The primary key class needs to be marked with @IdClass annotation

B. The primary key class must be private, but it's optional to implement Serializable

C. Mapping compound primary key requires creating a separate primary key class containing the primary key fields

D. The primary key class must include equals() and hashCode() method

98: Which of the following is NOT true about sharding in Hibernate (Hibernate Shards)?

A. The primary goal of Hibernate Shards is to enable application developers to query and transact against sharded datasets using the standard Hibernate Core API

B. Hibernate Shards can be conceptually divided into Generalized sharding logic, Application specific sharding logic and Hibernate Default sharding

C. Hibernate Shards primarily consists of shard-aware implementations of many of the Hibernate Core interfaces

D. Hibernate Shards can be conceptually divided into Generalized sharding logic and Application specific sharding logic

99: Which one of the following statements is true about the following HQL query: select p.number from employee e join e.phones p

A. This query is using outer join so it'll return all the Phone entity instances no matter it is associated with an Employee or not.

B. This query is missing the joining condition so it won't work

C. The query indicates that the "number" is the name of one of the columns of the Phone table

D. Because the "phones" is a collection association field, the path navigation couldn't continue

100: Which of the following is not a Session method?

A. Session.saveorupdate()

B. Session.remove()

C. Session.save()

D. Session.persist()