Java - Online Test - Database - javasearch.buggybread.com


Share

Search Java Test Questions


 223 test questions in repository.




Java - Test Questions on 'Database' - 5 questions found


What is Dirty Read in Database Transactions ?Database
Data Read by Transaction 2 which hasn't yet updated by Transaction 1
Data Read by Transaction 2 which has been updated and commited by Transaction 1
Data Read by Transaction 2 which has been updated but not commited by Transaction 1
Inability of Transaction 2 to read Data when Transaction 1 is updating.

  database transaction

In majority of the cases, the following join will give maximum number of results ?Database
Inner Join
Outer Join
Left Join
Right Join

  sql  sql joins

Which if the following is true for SQL Joins ?Database
Left Join and Right Join gives equal number of Results
Outer Join and Inner Join gives equal number of Results
Inner Join gives maximum number of results records
Inner Join gives minimum number of result records

  sql  sql joins

Which of the following is not true for Prepared Statements ?Database
Prepared Statements provides better performance
Prepared Statements prevent SQL Injection attacks
Prepared Statements provide ORM capabilities
Prepared Statement provides DB side caching

  database  Prepared Statements

Which Database feature assist in ACID capabilities ?Core Java
Indexes
Stored Procedures
Locking
Cursors

  acid







comments powered by Disqus