Database Management System II - Final Examination
Quiz by Felipe Sinjetsu
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Measure skills
from any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
With a free account, teachers can
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
20 questions
Show answers
- Q1Your 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.SELECT * FROM employees, departments INNER JOIN ON employees.department_id = departments.department_idSELECT * FROM employees INNER JOIN departments ON employees.department_id = departments.department_idSELECT * FROM employees FULL JOIN departments ON employees.department_id = departments.department_idSELECT employees FROM * LEFT JOIN departments ON employees.department_id = departments.department_id120s
- Q2Your 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?departmentemployeesdepartments.deparment_idemployees.department_id30s
- Q3Your 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?Left joinInner JoinSelf-JoinFull Join30s
- Q4A key constraint that can be inserted once in the table and must be no duplicate.Index KeyUnique KeyForeign KeyPrimary Key30s
- Q5Your 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?
Set Refuse
RestrictSet NullCascade30s - Q6(Primary) key is used to connect two tables, the secondary table to the PRIMARY table.False, ForeignTrueFalse, IndexFalse, Unique30s
- Q7A (view) is populated invoked using SELECT statement. Its data/record can be derive from other tables.False, IndexFalse, tableFalse, SchemaTrue30s
- Q8Your 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?Restrict
Swift
CascadeSet Combine30s - Q9When linking two tables in MySQL designer, the foreign key is pertaining to what?a unique key or index key in child tableforeign key in the child tableprimary key of the parent tableprimary key of the child table30s
- Q10If you will be setting a one-to-one relationship in two tables, the child table attribute for foreign key must have (index) key.False, uniqueFalse, foreignFalse, primaryTrue30s
- Q11
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?
ClusterIndexCheckDefault30s - Q12Between 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?customer.customer_IDaccountaccount.customer_IDcustomer30s
- Q13In database, it allows you to define rules for the data in your table.IndexConstraintsSynonymsCluster30s
- Q14equals, less than, greater than, greater than or equal, less than or equal are examples of what operator?stringarithmeticlogicalrelational30s
- Q15Using the SQL statement: Select Firstname From Account Where Barangay='tres' will output the following: PhilipTrueFalse, statement has an errorFalse, PI4False, will output Ines120s