Intern — Junior
Have you had experience working with database management systems (DBMS)?
sobes.tech AI
Answer from AI
Yes, I have experience working with database management systems (DBMS). I have used relational databases such as MySQL and PostgreSQL for storing and retrieving data in Java projects.
For example, I wrote SQL queries for selecting, inserting, and updating data, and also used JDBC to connect and interact with the database from a Java application:
String query = "SELECT * FROM users WHERE id = ?";
PreparedStatement stmt = connection.prepareStatement(query);
stmt.setInt(1, userId);
ResultSet rs = stmt.executeQuery();
while (rs.next()) {
System.out.println("User name: " + rs.getString("name"));
}
I am also familiar with the basics of data normalization and indexing to optimize queries.