Final Exam: Database Developer

WHAT YOU WILL LEARN

• 

  add rows to a database table by running an INSERT query from a Java app
  

  adopt a DataSource object to create a Connection with a database
  

  compare and contrast a JdbcRowSet and ResultSet
  

  configure eager loading of entities on the many sides
  

  configure lazy and eager loading for collections
  

  configure lazy loading of entities on the many sides
  

  configure one-to-one mapping with a join table
  

  configure one-to-one-mapping with a shared primary key
  

  configure the table name using the @Table annotation
  

  contrast the AUTO and IDENTITY generation types
  

  define collection mapping for primitive data types
  

  describe the features offered by a WebRowSet
  

  describe the role of batch updates and transactions when working with JDBC
  

  describe the role of JDBC and JDBC drivers in enabling interactions between a Java app and a database
  

  download and install MySQL and the MySQL Workbench tool
  

  download image files from a SQL table into your file system
  

  drop a table and database from a Java app
  

  execute JPQL queries
  

  execute native queries
  

  execute stored procedures that return values and retrieve the outputs generated
  

  hook into the entity lifecycle
  

  hook into the entity lifecycle after load
  

  hook into the entity lifecycle before and after entity load
  

  identify the different JDBC objects that enable a Java app to work with a database, and recall the role played by each of them
  

  identify the different ways to specify connection details when connecting to a database using JDBC
  

  identify the implications of cascade type NONE
  

  identify the types of ResultSets available in JDBC
  

  identify why object-relational mapping is needed to work with databases
  

  install MySQL and MySQL Workbench on a Windows machine
  

  load large image files into a SQL table using JDBC
• 

  outline the basic functionality that the Hibernate framework provides and how it differs to JPA
  

  outline the basic functionality that the JPA framework provides and how it differs to Hibernate
  

  perform an update and delete operations on entities
  

  perform read operations on database entities
  

  perform scrolling and navigation over the contents of a JdbcRowSet
  

  persist collections using the Set interface
  

  persist entities in a certain order
  

  persist nested objects in collections
  

  recall how a WebRowSet records modifications to its contents
  

  recall the implications of cascade type NONE
  

  recognize the limitations of a TYPE_FORWARD_ONLY ResultSet
  

  recognize the primary key as a required field
  

  refresh the contents of a ResultSet
  

  refresh the contents of a ResultSet while iterating over its contents
  

  remove data from a SQL table by performing deletes from a ResultSet
  

  retrieve many entities in order of specific attributes
  

  run basic criteria queries
  

  scroll through a ResultSet to access data in various locations
  

  set up a bidirectional one-to-one mapping between entities
  

  set up an Apache Maven project on a Windows machine
  

  set up a one-to-one mapping between entities
  

  specify entity attributes using XML
  

  summarize the basic structure of the Criteria API
  

  summarize the effects of cascade type MERGE
  

  summarize the effects of cascade type PERSIST and REMOVE
  

  use a CachedRowSet to work with data while disconnected from the database
  

  use begin and commit transactions
  

  use database connection details in a properties file to set up a connection to a database using JDBC
  

  use @GeneratedValue to generate primary key values
  

  use the IDENTITY generation type for multiple tables