Database Management System II - Prefinals Examination

A key constraint that can be inserted multiple times in the table in different attributes and must be no duplicate.

A constraint that used to fill a column with a default and fixed value if the user didn't input data.

A percent sign and asterisk wildcard character can only be effective in criteria when you are using (equal) operator.

A key constraint that specifies the constrained columns' values must UNIQUELY identify each row. Can be inserted once in a table.

A key constraint that can be unique, compound, bi-directional, or clustered.

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.

A key use used to connect the secondary table to the PRIMARY table.

A foreign key option which refuses to update or delete a record from the parent table if there are records in the child table.

A foreign key option that updates or deletes records from the child table automatically when updating or deleting a record from the parent table.

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

If you are going to upload data from an excel file to your MySQL database table, what function in MySQL would you use?

As a database designer, your Project Manager asked you to create an SQL which will join three tables that will show only the record of a specific person. What type of join is appropriate?

Between the relation customer with an attribute of customer_ID (primary key) and relation account with an attribute of customer_ID (unique key) where should be the reference key be located?