Database Management System II - Final Examination | Quizalize

Loading...

Database Management System II - Final Examination | Quizalize

20 questions

Q.

Your team lead ask you to combine all fields of two tables (employee & department) and show matching data. What SQL Join statement are you going to use.

1

120 sec

Q.

Your are in an interview for a job and the interviewer is asking you which is the table that contains the primary key between the two tables in the SQL (SELECT * FROM employees INNER JOIN departments ON employees.department_id = departments.department_id). Which is it?

2

30 sec

Q.

Your project manager wants you to combine two table which the first table will show all its record and the second table will match the record from the first table. Which join will you use?

3

30 sec

Q.

A key constraint that can be inserted once in the table and must be no duplicate.

4

30 sec

Q.

Your project manager wants the relationship between your tables must be the parent table will refuse record deletion or update if there are records in the child table. What foreign key option will be used?

5

30 sec

Q.

(Primary) key is used to connect two tables, the secondary table to the PRIMARY table.

6

30 sec

Q.

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

7

30 sec

Q.

Your lead is asking you to change the connection option of the table to, if the parent table will be updated or deleted, same should be in the child table. What foreign key option will you used?

8

30 sec

Q.

When linking two tables in MySQL designer, the foreign key is pertaining to what?

9

30 sec

Q.

If you will be setting a one-to-one relationship in two tables, the child table attribute for foreign key must have (index) key.

10

30 sec

Q.

Your manager wants you to make the attribute name in the customer table to have "No name" as value if a user didn't put any name on it. What type of constraint will you use?

11

30 sec

Q.

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?

12

30 sec

Q.

In database, it allows you to define rules for the data in your table.

13

30 sec

Q.

equals, less than, greater than, greater than or equal, less than or equal are examples of what operator?

14

30 sec

Q.

Using the SQL statement: Select Firstname From Account Where Barangay='tres' will output the following: Philip

Question Image

15

120 sec

Q.

Supply the missing parts in the JOIN clause to join the two tables Orders and Customers, using the CustomerID field in both tables as the relationship between the two tables. SELECT * FROM Orders LEFT JOIN Customers ___________________ = _____________.

16

45 sec

Q.

Choose the correct JOIN clause to select all records from the two tables where there is a match in both tables. SELECT * FROM Orders ________________ ON Orders.CustomerID=Customers.CustomerID;

17

45 sec

Q.

Choose the correct JOIN clause to select all the records from the Customers table plus all the matches in the Orders table. SELECT * FROM Orders ____________________ ON Orders.CustomerID=Customers.CustomerID;

18

45 sec

Q.

Your manager wants you to return all the records from both tables customers and orders which will return in a very large result-sets of record. What appropriate join is needed in MySQL?

19

30 sec

Q.

As a database designer, you are asked to ensure the uniqueness of values in an attribute as well as that attribute will uniquely identify each row or table record in the table. What constraint is appropriate to use?

20

30 sec