Web Design and Development MCQs with Answers
Practice important Web Design and Development MCQs with answers and explanations.
Multiple Choice Questions
Q271: What does the getColumnType(int) method return?
- A: The SQL type of the column
- B: The name of the column
- C: The display size of the column
- D: The database product name
View Answer
A
Q272: How do you access metadata about a database in JDBC?
- A: By calling getMetaData() on a ResultSet
- B: By calling getMetaData() on a Connection
- C: By executing a SQL query
- D: By using the ResultSet object directly
View Answer
B
Q273: Which JDBC driver type translates JDBC calls into ODBC calls?
- A: Type-1 JDBC-ODBC Bridge
- B: Type-2 Native API/partly Java driver
- C: Type-3 Net-protocol/all-Java driver
- D: Type-4 Native-protocol/all-Java driver
View Answer
A
Q274: ___________ is the process of making multiple threads execute in a specific order.
- A: Scheduling
- B: Serialization
- C: Synchronization
- D: None of the above
View Answer
C
Q275: What is a characteristic of Type-2 JDBC drivers?
- A: They are purely Java-based
- B: They convert JDBC calls to database-specific calls
- C: They use a network middle-tier server
- D: They are less efficient than Type-1 drivers
View Answer
B
Q276: What is the main advantage of Type-4 JDBC drivers?
- A: They are platform-independent
- B: They translate calls into ODBC calls
- C: They use database-specific APIs
- D: They rely on a middle-tier server
View Answer
A
Q277: What does the isReadOnly() method of DatabaseMetaData check?
- A: The read/write mode of the database
- B: The version of the database product
- C: The name of the JDBC driver
- D: The number of columns in the ResultSet
View Answer
A
Q278: What method is used to get the database product name from DatabaseMetaData?
- A: getDatabaseProductName()
- B: getDatabaseProductVersion()
- C: getDriverName()
- D: getDatabaseType()
View Answer
A
Q279: What does the getDriverName() method return in DatabaseMetaData?
- A: The name of the JDBC driver
- B: The name of the database product
- C: The version of the database product
- D: The read-only status of the database
View Answer
A
Q280: How does a Type-3 JDBC driver handle database requests?
- A: Sends requests through a middle-tier server
- B: Directly communicates with the database
- C: Converts JDBC calls into ODBC calls
- D: Uses a database-specific API
View Answer
A