Question

Fill in the blanks:

1. A______is helps to collect specific information from the pool of data in the database.

2._______statement retrieves zero or more rows from one or more database tables or database views.

3._______statement is used to add one or more records to a database.

4._______statement is used for modifying records in a database.

5._______statement is used to remove one or more records in a database.

6._______statement is used for creating a database or a table in any RDBMS Software.​

Answer 1

1. A____search tool__is helps to collect specific information from the pool of data in the database.

2.____Alter___statement retrieves zero or more rows from one or more database tables or database views.

3.____insert___statement is used to add one or more records to a database.

4.__update_____statement is used for modifying records in a database.

5.____delete___statement is used to remove one or more records in a database.

6.___create____statement is used for creating a database or a table in any RDBMS Software.​

Explanation:

• In a database table, the columns are called fields.

• Database tables are objects, meant to store data. Tables are composed of rows and columns.

• Rows of a database table represent a complete record whereas the fields or columns represent and attribute or a field of that individual record.
• For example if 'Dept' table contains data of all departments in a company then- Name, Location, Average salary will be fields or attributes of a complete record of a each department.

• Columns may be added to a table even after it's creation. This can be done by ALTER TABLE command which can alter the structure of the table, keeping data integrity in mind.
• To know more about database tables, visit:

What  is a database? Brainly.in

brainly.in/question/11418382

Answer 2

Explanation:

here's your answerrrrrrrrrrrrrr