DBMS 2 Long Test Examination - Midterm period

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)

In designing a multi-table query, (locate) is the step where the criteria should be put to be met by the information neeeded.

(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).

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

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

In (2NF), ruels 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).