Tag: databases

No Rows retrieved

8 is displayed 20 times

8 is displayed 1 time

error message

True

False

specifies that the empty space created by deleting the records must be retained for this table and should not be used by other tables

specifies that the empty space created by deleting the records, can be used by other tables.

specifies that this transaction can be rolled back later

This clause cannot be used with truncate statement

rowid

row_num

sl_no

rownum

sid

Primary Key

Check

Unique

Not Null

Foreign Key

JDBC is an API to connect to relational-, object- and XML data sources

JDBC stands for Java DataBase Connectivity

JDBC is an API to access relational databases, spreadsheets and flat files

JDBC is an API to bridge the object-relational mismatch between OO programs and relational

java.jdbc and javax.jdbc

java.jdbc and java.jdbc.sql

java.sql and javax.sql

java.rdb and javax.rdb

Type 1 driver

Type 2 driver

Type 3 driver

Type 4 driver

Type 1 driver

Type 2 driver

Type 3 driver

Type 4 driver

PreparedStatement

ParameterizedStatement

ParameterizedStatement and CallableStatement

All kinds of Statements (i.e. which implement a sub interface of Statement)