1. If two transactions are executing concurrently, each one will see the world as if they were
executing sequentially, and if one needs to read data that is written by another, it will have
to wait until the other is finished. Which property of database ensures this?
a) Durability b) Consistency c) Atomicity d) Isolation
Wrong!Try again..
Wrong Again! Try one more chance..
Wrong! The correct answer is d) Isolation
Correct! Isolation
2. Which method can be used for establishing a connection to a JDBC 4.1 data source?
a) Class.getConnection() b) Class.getJDBCConnection() c) DriverManager.getConnection() d) DriverManager.getJDBCConnection()
Wrong! Try again..
Wrong Again! Try one more chance..
Wrong! The correct answer is c) DriverManager.getConnection()
Correct! DriverManager.getConnection()
3. The following property of database means that once a transaction is complete, it is
guaranteed that all of the changes have been recorded to say a hard disk, with the fact that the transaction has been completed.
a) Durability b) Isolation c) Atomicity d) Consistency
Wrong! Try again.
Wrong Again! Try one more chance..
Wrong! The correct answer is a) Durability
Correct! Durability
4. Which of the following database property means that you can guarantee that all of a transaction happens, or none of it does; You can do complex operations as one single unit, all or nothing, and a crash, power failure, error, or anything else won't allow you to be in a state in which only some
of the related changes have happened?
a) Consistency b) Isolation c) Durability d) Atomicity
Wrong! Try again.
Wrong Again! Try one more chance..
Wrong! The correct answer is d) Atomicity
Correct! Atomicity
5. Which of the following statements are true about JSP tag library?
A. Defines standard tag that can be used anywhere
B. Single library and can be used across multiple jsp containers
C. Support iteration and condition
D. Has tags for manipulating XML documents
a) A, B, C b) A, C, D c) A, B, D d) All of them
Wrong! Try again.
Wrong Again! Try one more chance.
Wrong! The correct answer is a) All of them
Correct! All of them
6. Which of the following are NOT true?
1. To update a table column with different values for each record we can use a PreparedStatement
2. To return a single value from database after accessing multiple tables we can use a Stored Function
3. If we need to send mutiple parameters and get multiple values back from database we can use a Stored Procedure
4. A CallableStatement cannot execute a SQL query to access data from a table.
a) None of the above b) 2 and 3 c) 1, 2 and 4 d) 3 and 4
Wrong! Try again.
Wrong Again! Try one more chance..
Wrong! The correct answer is a) None of the above
Correct! None of the above
7. The following interfaces in JDBC can be used to fire a SELECT SQL query into the database :