DBMS 2 - Midterm Exam

SQL stands for Syntax Query Language which is the standard language of relational databases. This statement is not (True).

A square bracket [ ] represents any character not in brackets. This statement is (True)

(Identify) is one of the steps in multi-table query wherein we need to set our goals and set exactly what information we need.

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 write like "Between x, y". This statement is (True).

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

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

SELECT attribute1, attribute2, attribute3 FROM relation_name is a (valid) Select query statement structure.

A percent sign and asterisk 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-d]%" this criteria using the wildcard characters means find data that contains letter b to d range. This statement is (True).

A database object that means the structure of the database or name spaces for a collection of database objects is the (View).

A (table) is populated invoked using SELECT statement. Its data/record can be derive from other tables.

An (synonyms) are ordered set of pointers that refer to rows in a base table.