what is difference between excute query ()and execute update
()?
Answers were Sorted based on User's Feedback
Answer / ashwani
execute query() returns a single resultset object.
exceute update() excecutes the insert, update and the delete
operation of the sql statement.This returns the integer
value or say the number of record affected by the SQL
statement execution.
| Is This Answer Correct ? | 15 Yes | 1 No |
Answer / mano
execute query() used in select operation.
execute update() is used in delete, update and insert
operations.
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / gambhir
executeQuery() is used to perform DDL operation like
(create,alter) while executeUpdate() is used to perform DML
operation like (insert/update/delete).
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / vikneswarank
excuteQuery() its method used perform select query and
delete query return ResultSet object.
excuteUpdate() used to perform DML operation return type
int
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / megala devi
Execute query():it is using for DML(Data definition
language) and DDL (Data Manipulation Language)and mainly its
used for select query
example:String sql="select * from Employee_Details";
st.executequery(sql);
Execute update():it is using for DML(Data definition
language) and DDL (Data Manipulation Language)and mainly its
used for insert query,update query,delete
example:String sql="insert into Employee_Detail........";
st.executeUpdate(sql);
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / naresh
executeQuery() method used for only selecting the records
and its return value is in the form of ResultSet Object.
executeUpdate() method used for DDL and DML commands and
its returns the int value.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is inner class?
What is the disadvantage of synchronization?
Define immutable object?
Explain working of call by reference function invoking.
What is abstract class constructor called?
How many types of exception can occur in a java program?
Is string pool garbage collected?
Explain the difference between string, stringbuffer and stringbuilder in java?
In the first round, there are 30 aptitude and 30 java questions. We are suppose to finish both the papers within 60 minutes. I cleared this round. Next was test for programming skills. In this section, Some 7 n's were asked. 1. What is the difference b/w sleep(1000) and wait(1000) 2. what is the diff b/w static block and static function? 3. Write a program to validate IP address using string tokenizer. 4. Write a program to create singleton class 5. write a function to reverse the string 6. Write a prog to print prime nos upto n. EX: If n=9, It shld print 1,2,3,5,7 7. One program on collections- Write a program to print no. of times a number is repeating in an array. EX- {1,3,1,2,5,7,3,7,34,3,8,3} It should print: 1- 2 times 3- 4 times and so on 7. Write a func to print fibonocci series After this I had technical interview, which went on for. 60 mins or so. There were qn's about multi threading, Exception handling and collection classes. Knowledge about collections was very important for the post I was interviewed for.
what is the difference between preemptive scheduling and time slicing? : Java thread
if two references are having same hash codes,is that means those are refering to same object?
What access modifiers can be used for class ?