What is Normalization?
Answers were Sorted based on User's Feedback
Answer / hinaresh2003
The normalization is a step by step process of removing
redundancies and dependencies of attributes in data
structure
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / sambireddy
dividing the relation into sub relations for freeing of
certain undesirable characteristics—insertion, update, and
deletion anomalies nothing but a normalization
Is This Answer Correct ? | 2 Yes | 0 No |
What is an odbc driver?
What is jdbc architecture?
How do we call a stored procedure from jdbc?
Compare jdbc and odbc and how is jdbc required in this context.
Can I get a null resultset?
What is jdbc vs odbc?
java.lang.ClassNotFoundException:oracle.jdbc.driver.OracleDr iver? I get this error at run time.I used oracle10G. I set CLASS PATH:C:\oraclexe\app\oracle\product\10.2.0 \server\jdbc\lib\ojdbc14.jar; I write JDBC PROGRAM like import java.sql.*; class Example { public static void main(String args[]) { try { Class.forName ("oracle.jdbc.driver.OracleDriver"); System.out.println("Driver Loaded"); Connection con=DriverManager.getConnection ("jdbc:oracle:thin:@localhost:1521:xe","system","salmas"); System.out.println("Driver Connected"); Statement st=con.createStatement(); ResultSet rs=st.executeQuery("select * from emp"); while(rs.next()) { System.out.println(rs.getInt(1)); System.out.println(rs.getString(2)); System.out.println(rs.getString(3)); } st.close(); con.close(); } catch(Exception e) { System.out.println(e); } finally { System.out.println("it's finally block executed"); } } }
i have 1000 records in resultset, how to get first 100 records from resultset, because resultset fetch all 1000 records at a time?
can we define indexes on a foreign key? Explain pros and cons?
Give an example of code used for setting up connection with a driver.
What is @entity in java?
What is JDBC Batch Processing and what are it’s benefits?