The language for managing data in relational database management system is (DML)

A category of SQL statement which uses statements such as rollback and savepoint which group DML statements togerther to be executed is (DCL)

SQL category which creates, modifies, deletes database objects is (Data Definition Language).

SQL statements such as select, insert, update, and delete belongs to (Data Definition Language)

Operators such as less than, greater than or equal, and equal belongs to (relational) operator.

In logical operator (AND), if one condition is false and others are true, then the result is true.

The step in planning a query where the process of finding the fields needed in what relation they contained in is (determine).

In planning a query, (identify) is the process where you point out what condition you want to apply in the query.

(Identify) is the process in planning a query which the user checks what attribute contains the data needs to be shown.

Constraint which checks the permissible values for a given attribute is (CHECK).

(Referential Integrity) constraint applies either two key which are primary and unique as well as null constraint.

A constraint that refers to the correctness of the meaning of the data is (Domain).

A constraint that defines the relationship between relations and ensures that the relationships are true.

The (check) constraints enforce domain integrity by limiting the values that are accepted by an attribute.

A qualifier of an object in database which serves as a name space for a collection of database objects.

A database object which is the main repository of data is (view).

In table, the record is the collection of values in the same row.

A (view) is a database object which is populated by select sql statement and derive from other views or table.

A view does not need to contain all the columns of the base table, and it can be updateable, deleteable, and insertable, or read-only too.

A database object which provides another name to a database object is (nickname).

A (unique) index is one that can be traversed in either direction, so it's ascending or descending.

A (compound) index consists of several columns that form the index.

A (Index) is a virtual table derived from one or more tables or other views.

A (cluster) index consists of several columns that form the index

A (unique) index is one that can be traversed in either direction

A (sequence) allows the user/designer to define rules for the data in a relation.

An (index), when created in a relation, it generates automatic unique numeric value.

A form in normalization is (3NF) which states that all fields can be determined only by the key in the table and no other column.

BCNF or the Boyce Codd Normal Form is the extension of (3NF) and one of the form for database normalization.

In database normalization, the (3NF) states that all attributes - Non-keycolumns - should be dependent on the key.

Database normalization form that states "no multi-valued dependencies".

(2NF) in database normalization states that each cell in the relation should be single valued.

In (1NF), rules to follow is, all data entries or entries in a column must be in the same type.

In database normalization, the rule "all attributes - non-key columns - should be dependent on the key is on (1NF).