MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Which statements about JDBC are true?

A	JDBC is an API to connect to relational-, object-and XML data sources
B	JDBC stands for Java DataBase Connectivity
C	JDBC is an API to access relational databases, spreadsheets and flat files
D	JDBC is an API to bridge the object-relational mismatch between OO programs and relationaldatabases

Explanation:

Detailed explanation-1: -Explanation. JDBC is a standard Java API for database-independent connectivity between the Java programming language and a wide range of databases. Q 3-Which of the following is true about JDBC architecture? A-JDBC API layer provides the application-to-JDBC Manager connection.

Detailed explanation-2: -The Java Database Connectivity (JDBC) API is a Java API for accessing relational (tabular) data, especially those stored in a relational database. JDBC has been an integral part of Sun’s Java Development Kit since 1.1 and is supported by virtually all relational database vendors.

Detailed explanation-3: -JDBC API ‘Statement‘ is used to execute SQL queries in the database. We can create the Statement object by calling Connection ‘createStatement()‘ method. We can use Statement to execute static SQL queries by passing query through different execute methods such as execute(), executeQuery(), executeUpdate() etc.

There is 1 question to complete.