1. Home
  2. Back Today Date :- Saturday 22nd of March 2025 02:44:28 AM

JDBC - Online Exam Test Papers | JDBC - MCQs[multiple choice questions and answers ] | JDBC - Mock Test Papers | JDBC - Practice Papers | JDBC - Sample Test Papers |

Question:
Which of the following is advantage of using PreparedStatement in Java?

1. Slow performance

2.Encourages SQL injection

3.Prevents SQL injection

4.More memory usage

Posted Date:-2022-01-18 07:06:23

More MCQS Questions and answers

  1. Are ResultSets updateable?
  2. How constructor can be used for a servlet?
  3. Identify the DSN in the following statement: DriverManager.getConnection("jdbc:odbc:oradsn", "scott", "tiger")
  4. Identify the isolation level that prevents the dirty in the JDBC Connection class?
  5. Which of the following code is used to get an attribute in a HTTP Session object in servlets?
  6. Which of the following contains both date and time?
  7. Which of the following is not a JDBC connection isolation levels?
  8. Which of the following is used to limit the number of rows returned?
  9. Which of the following is used to rollback a JDBC transaction?
  10. Which statement is correct if we want to connect the Oracle database using the thin driver provided by Oracle Corp.?
  11. A good way to debug JDBC-related problems is to enable???..?
  12. Can servlet class declare constructor with ServletConfig object as an argument?
  13. DatabaseMetaData interface is used to get?????..?
  14. How many stages are used by Java programmers while using JDBC in their programs?
  15. How many statement objects can be created using a Connection?
  16. How many transaction isolation levels provide the JDBC through the Connection interface?
  17. How many ways to register a driver?
  18. JDBC API supports____________ and __________ architecture model for accessing the database.
  19. JDBC-ODBC driver is also known as?
  20. Parameterized queries can be executed by?
  21. Select the packages in which JDBC classes are defined?
  22. Stored procedure can be called by using the ????..?
  23. Thin driver is also known as?
  24. What are the major components of the JDBC?
  25. What are the types of ResultSet in JDBC?
  26. What does setAutoCommit(false) do?
  27. What is blob in the following statement? create table profilepic(photo blob);
  28. What is JDBC Savepoint?
  29. What is the correct sequence to create a database connection? i. Import JDBC packages. ii. Open a connection to the database. iii. Load and register the JDBC driver. iv. Execute the statement object and return a query resultset. v. Create a statement object to perform a query. vi. Close the resultset and statement objects. vii. Process the resultset.
  30. What is the difference between servlets and applets? i. Servlets execute on Server; Applets execute on browser ii. Servlets have no GUI; Applet has GUI iii. Servlets creates static web pages; Applets creates dynamic web pages iv. Servlets can handle only a single request; Applet can handle multiple requests
  31. What should be the correct order to close the database resource?What should be the correct order to close the database resource?
  32. Which data type is used to store files in the database table?
  33. Which JDBC driver can be used in servlet and applet both?
  34. Which method is used to get three-letter abbreviation for locale’s country in servlets?
  35. Which methods are required to load a database driver in JDBC?
  36. Which of the following code retrieves the body of the request as binary data?
  37. Which of the following driver converts the JDBC calls into database-specific calls?
  38. Which of the following driver is the fastest one?
  39. Which of the following interface provides the commit() and rollback() methods?
  40. Which of the following is advantage of using JDBC connection pool?
  41. Which of the following is advantage of using PreparedStatement in Java?
  42. Which of the following is method of JDBC batch process?
  43. Which of the following is not a type of ResultSet object?
  44. Which of the following is not a valid statement in JDBC?
  45. Which of the following is the correct to register a JdbcOdbcDriver?
  46. Which of the following is used to call stored procedure?
  47. Which of the following method is static and synchronized in JDBC API?
  48. Which of the following method is used to perform DML statements in JDBC?
  49. Which one of the following contains date information?
  50. Which statement(s) is/ are true about transactions? i. A transaction is a set of one or more SQL statements that make up a logical unit of work. ii. A transaction ends with either a commit or a rollback, depending on whether there are any problems with data consistency or data concurrency. iii. A lock is a mechanism that allows two transactions from manipulating the same data at the same time. iv. To avoid conflicts during a transaction, a DBMS uses locks, mechanisms for blocking access by others to the data that is being accessed by the transaction.
Search