Database Management System II - Midterm Examination | Quizalize

placeholder image to represent content

Database Management System II - Midterm Examination

Quiz by Felipe Sinjetsu

Feel free to use or edit a copy

includes Teacher and Student dashboards

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
view complete results in the Gradebook and Mastery Dashboards
automatically assign follow-up activities based on students’ scores
assign as homework
share a link with colleagues
print as a bubble sheet

Q 1/17
Score 0
Your people lead asked you what table will serve as the parent table in the relationship given that customer.customer_ID (reference key) = order.customer_ID (foreign key).
29

order.customer_ID
customer_ID
order
customer

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes

17 questions

Show answers

Q1
Your people lead asked you what table will serve as the parent table in the relationship given that customer.customer_ID (reference key) = order.customer_ID (foreign key).
order.customer_ID
customer_ID
order
customer
30s
Q2
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?
inner join
left join
cross join
right join
30s
Q3
Your project manager asked you to create a one-to-one relationship between two tables, what constraint/key will you put to the attribute in the foreign key/child table?
foreign
index
unique
primary
30s
Q4
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?
null/not null
default
check
primary key
30s
Q5
Your lead wants to make the structure of deleting data in your database tables as, the data be deleted first in the child table before the data in parent table. What foreign key option is appropriate?
set null
strict
cascade
restrict
30s