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 square bracket [ ] represents any character not in brackets. This statement is (True)

In query, (does not equal) is write like "Not in ('x')".

Query criteria for text >="x" means searchers for all values that begins with "x". This statement is not (False).

Query criteria for number that searchers for all values in the range between x and y is written as "Between x, y". This statement is (True).

SELECT * FROM 'relation_name' is a (valid) Select query statement structure.

A percent sign wildcard character can only be effective in criteria when you are using "equal" operator. This is not (False).

Underscore ( _ ) is a wildcard character that represents zero or more character.

"b%" this criteria using the wildcard character means find data that CONTAINS letter b. This statement is (True).

SELECT relation_name FROM attribute1 WHERE attribute1 = "x" can be a (valid) SELECT query statement.

A dashed " - " wildcard character represents any single character within the brackets. This statement is (False).

A criteria " ='x%' " means searches for all values beginning with x. This statement is not (False).

A criteria h[^oa]t, means finding hit, but not hot and hat data. This statement is not (True).

>, >=, <, <=, = are all (comparison) operators which is use in query criteria to compare data.