Database Systems Final Exam

What is the method used to move to the next row in a ResultSet?

• forward()

• next()

• continue()

• shift()

Which of the following statements is true about password hashing?

• It converts plain-text passwords into fixed-length irreversible strings.

• It encrypts and decrypts passwords for storage.

• It stores passwords in base64 format.

• It is reversible if the right algorithm is known.

What is the purpose of the Class.forName() method in JDBC?

• To create a Statement object

• To close the connection

• To load the JDBC driver

• To configure the database URL

Which is a SQL operation used in the Update part of CRUD?

• SELECT

• DELETE

• INSERT

• UPDATE

Which of the following is a Java API used to connect to a database?

• JDBC

• APIConnect

• SQLBridge

• JSQL

Which JDBC object holds data returned from a database query?

• Connection

• ResultSet

• Statement

• DriverManager

What is a major purpose of using PreparedStatement over Statement?

• To speed up network connections

• To provide GUI support

• To prevent SQL Injection

• To improve memory usage

In user authentication, which of the following verifies a user's identity?

• Role assignment

• Biometric check

• Authorization

• Encryption

Which of the following is NOT a type of JDBC driver?

• Type 1

• Type 3

• Type 4

• Type 5

Which role does HTTPS play in a secure login system?

• It compresses passwords for faster transfer.

• It ensures secure encrypted communication.

• It prevents brute-force attacks.

• It hashes all inputs automatically.