Answer:
a. SQL.
b. Rows and columns.
c. ResultSet objects.
d. Primary key.
e. WHERE.
f. ORDER BY.
g. Joining.
h. Database.
i. Foreign key.
j. DriverManager; getConnection ().
k. Connection.
l. Statement.
Explanation:
A database management system (DBMS) can be defined as a collection of software applications that typically enables computer users to create, store, modify, retrieve and manage data or informations in a database. Generally, it allows computer users to efficiently retrieve and manage their data with an appropriate level of security.
A structured query language (SQL) can be defined as a domain-specific language designed and developed for managing the various data saved in a relational or structured database.
In Computer programming, any word restricted for use, only in object names because they belong to the SQL programming language are called reserved word.
Some examples of reserved words in structured query language (SQL) are UPDATE, GROUP, CURRENT_USER, CURRENT_DATE, WHERE, CREATE, DELETE, ORDER BY, etc.
Filling in the missing words or texts in the question, we have;
a. The international standard database language is SQL.
b. A table in a database consists of rows and columns.
c. Statement objects return SQL query results as ResultSet objects.
d. The primary key uniquely identifies each row in a table.
e. SQL keyword WHERE is followed by the selection criteria that specify the rows to selectin a query.
f. SQL keywords ORDER BY the order in which rows are sorted in a query.
g. Merging rows from multiple database tables is called joining the tables.
h. A database is an organized collection of data.
i. A foreign key is a set of columns whose values match the primary-key values of another table.
j. DriverManager method, getConnection () is used to obtain a Connection to a database.
k. Interface connection helps manage the connection between a Java program and a database.
l. A statement object is used to submit a query to a database.
