Database Management System I - BSIT - Midterm Exam

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.