Quiz for Connecting to a DB

Q1: Which Java package is used for database connectivity?

A. java.db B. java.sql C. javax.db D. org.sql

Q2: Which method is used to establish a connection with the database?

A. Driver.connect() B. DriverManager.getConnection() C. DB.connect() D. DB.openConnection()

Q3: What information is required to connect to a DB?

A. URL, username, password B. Driver only C. URL only D. Password only

Q4: What is the typical format of a JDBC URL for MySQL?

A. jdbc:mysql://host:port/db B. sql:mysql://host/db C. jdbc:mysql/db D. mysql:jdbc//host:port

Q5: Which interface is used to run SQL queries?

A. Driver B. Statement C. Connection D. ResultSet

Q6: What is returned by getConnection() if the connection fails?

A. null B. SQLException C. Error D. ConnectionException

Q7: How do you close a DB connection?

A. conn.stop() B. conn.destroy() C. conn.close() D. conn.exit()

Q8: Which JDBC driver type is pure Java and platform-independent?

A. Type-1 B. Type-2 C. Type-3 D. Type-4

Q9: How do you load a JDBC driver?

A. Class.forName("com.mysql.cj.jdbc.Driver") B. new Driver() C. Driver.register() D. Driver.loadDriver()

Q10: Which object is created after connecting to DB?

A. Driver B. Connection C. ResultSet D. Statement

Q11: What does 'try-with-resources' ensure in JDBC?

A. Auto-imports classes B. Auto-connects to DB C. Auto-rollback D. Auto-close resources

Q12: Which exception is thrown on DB connection failure?

A. IOException B. SQLException C. DBException D. ConnectException

Q13: Which of these does NOT relate to DB connection?

A. Connection B. Statement C. DriverManager D. Runnable

Q14: Which of these is thread-safe?

A. Connection B. Statement C. PreparedStatement D. None are guaranteed thread-safe

Q15: What is a common port number for MySQL?

A. 5432 B. 1433 C. 3306 D. 1521

Q16: How do you check if a connection is still open?

A. connection.status() B. connection.ping() C. connection.isClosed() D. connection.check()

Q17: Which method is used to execute update SQL commands?

A. executeUpdate() B. runUpdate() C. updateQuery() D. executeQuery()

Q18: What is the advantage of using connection pooling?

A. Less memory usage B. Faster DB operations C. Automatic schema generation D. Prevents SQL injection

Q19: Which tool is often used with JDBC for connection pooling?

A. Hibernate B. Tomcat C. HikariCP D. JSP

Q20: Which of these can help secure DB connection credentials?

A. Hard-coding in source B. Plain text in code C. Environment variables or config files D. URL query parameters