Lernkarten

Karten 78 Karten
Lernende 1 Lernende
Sprache English
Stufe Berufslehre
Erstellt / Aktualisiert 01.09.2017 / 08.09.2017
Lizenzierung Keine Angabe     (Oracle)
Weblink
Einbinden
0 Exakte Antworten 78 Text Antworten 0 Multiple Choice Antworten
Fenster schliessen

Which is the complete hierarchy of the following seven interfaces?

RowSet, JdbcRowSet, JoinRowSet, CachedRowSet, FilteredRowSet, WebRowSet, ResultSet

  • RowSet extends ResultSet.
  • JdbcRowSet and CachedRowSet extend RowSet.
  • WebRowSet extends CachedRowSet.
  • JoinRowSet and FilteredRowSet extend WebRowSet.
Fenster schliessen

What is the meaning of JDBC and what is it used for?

Java Database Connectivity.

Used to interact with a database using SQL based queries.

 

Fenster schliessen

What are Java DB, MySQL and MariaDB?

Database management systems (DBMS).

(Java DB is in SDK, MariaDB is an OpenSource version of MySQL.)

Fenster schliessen

Which JDBC driver is required to connect to a MySQL database?

Connector/J

Fenster schliessen

What are MySQL workbench, Apache ant and XAMPP?

Apache ant: Java-based tool for building, running and compiling.

XAMPP: Database administration tool.

MySQL workbench: Database visualization tool.

Fenster schliessen

What are the four types of JDBC drivers?

  1. ODBC Bridge (implement JDBC API as a mapping to another API, such as ODBC)
  2. Native API (written partly in the Java programming language and partly in native code)
  3. Net pure Java (use a pure Java client and communicate with a middleware server)
  4. 100% Pure Java (pure Java, implement the network protocol for a specific data source)
Fenster schliessen

For which interfaces must a JDBC driver implementation provide implementation classes?

Driver, Connection, Statement, ResultSet and so on...!

Fenster schliessen

Which SQL Standard must a JDBC compliant driver implement?

SQL92