What does setAutoCommit(false) do?(a) commits transaction after each query(b) explicitly commits transaction(c) does not commit transaction automatically after each query(d) never commits transactionThe question was posed to me in an online quiz.The query is from JDBC topic in portion Java Beans & JDBC of Java

What does setAutoCommit(false) do?(a) commits transaction after each q

1.	What does setAutoCommit(false) do?(a) commits transaction after each query(b) explicitly commits transaction(c) does not commit transaction automatically after each query(d) never commits transactionThe question was posed to me in an online quiz.The query is from JDBC topic in portion Java Beans & JDBC of Java
Answer» Correct choice is (c) does not commit TRANSACTION automatically after each query To EXPLAIN I would say: setAutoCommit(FALSE) does not commit transaction automatically after each query. That saves a LOT of time of the execution and hence improves performance.

Discussion

No Comment Found

Related InterviewSolutions

Is design pattern a logical concept.(a) True(b) FalseThe question was asked by my college director while I was bunking the class.The query is from Design Patterns topic in division Java Beans & JDBC of Java
What does MVC pattern stands for?(a) Mock View Control(b) Model view Controller(c) Mock View Class(d) Model View ClassI got this question during an online exam.The doubt is from Design Patterns in division Java Beans & JDBC of Java
Which design pattern represents a way to access all the objects in a collection?(a) Iterator pattern(b) Facade pattern(c) Builder pattern(d) Bridge patternThe question was asked in an international level competition.My question is from Design Patterns in chapter Java Beans & JDBC of Java
Which design pattern suggests multiple classes through which request is passed and multiple but only relevant classes carry out operations on the request?(a) Singleton pattern(b) Chain of responsibility pattern(c) State pattern(d) Bridge patternThis question was addressed to me in final exam.The query is from Design Patterns topic in section Java Beans & JDBC of Java
Which of the below is not a valid design pattern?(a) Singleton(b) Factory(c) Command(d) JavaI got this question in semester exam.My question is based upon Design Patterns in section Java Beans & JDBC of Java
Which design pattern ensures that only one object of particular class gets created?(a) Singleton pattern(b) Filter pattern(c) State pattern(d) Bridge patternThis question was addressed to me during an interview.Query is from Design Patterns topic in section Java Beans & JDBC of Java
Which design pattern provides a single class which provides simplified methods required by client and delegates call to those methods?(a) Adapter pattern(b) Builder pattern(c) Facade pattern(d) Prototype patternThe question was asked in an interview for job.I would like to ask this question from Design Patterns topic in portion Java Beans & JDBC of Java
Which of the below is not a valid classification of design pattern?(a) Creational patterns(b) Structural patterns(c) Behavioural patterns(d) Java patternsI have been asked this question in an interview.This question is from Design Patterns topic in division Java Beans & JDBC of Java
Which of the below author is not a part of GOF (Gang of Four)?(a) Erich Gamma(b) Gang Pattern(c) Richard Helm(d) Ralph JohnsonThis question was posed to me in a job interview.My query is from Design Patterns in section Java Beans & JDBC of Java
Which of the following is method of JDBC batch process?(a) setBatch()(b) deleteBatch()(c) removeBatch()(d) addBatch()I got this question in quiz.Enquiry is from JDBC topic in division Java Beans & JDBC of Java

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment