Answered

Looking for answers? Westonci.ca is your go-to Q&A platform, offering quick, trustworthy responses from a community of experts. Ask your questions and receive accurate answers from professionals with extensive experience in various fields on our platform. Experience the ease of finding precise answers to your questions from a knowledgeable community of experts.

Q1: Fill in the blanks in each of the following statements: a. The international standard database language is ______________. b. A table in a database consists of ___________and ___________ c. Statement objects return SQL query results as ___________ d. The ___________uniquely identifies each row in a table. e. SQL keyword _________ is followed by the selection criteria that specify the rows to selectin a query. f. SQL keywords ___________specify the order in which rows are sorted in a query. g. Merging rows from multiple database tables is called __________ the tables. h. A(n) ________ is an organized collection of data. i. A(n) ________is a set of columns whose values match the primary-key values of anothertable. j. method _______is used to obtain a Connection to a database. k. Interface ___________helps manage the connection between a Java program and adatabase. l. A(n) ___________object is used to submit a query to a database

Sagot :

Lanuel

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.

We appreciate your visit. Hopefully, the answers you found were beneficial. Don't hesitate to come back for more information. Thank you for choosing our platform. We're dedicated to providing the best answers for all your questions. Visit us again. Thank you for visiting Westonci.ca, your go-to source for reliable answers. Come back soon for more expert insights.