Quizalize logo
placeholder image to represent content

Database Management System - ACT 201 - Final Examination

Quiz by Bits SQUAD

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
  • automatically assign follow-up activities based on students’ scores
  • assign as homework
  • share a link with colleagues
  • print as a bubble sheet

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

Correct quiz answers unlock more play!

New Quizalize solo game modes
20 questions
Show answers
  • Q1
    What type of relationship would be suited for relation's Client info and Account? Refer to Figure A.
    Many-to-Many
    One-to-Many
    One-to-One
    No Connection
    60s
  • Q2
    What type of relationship would be suited for relation's Role and Account? Refer to Figure A.
    Many-to-Many
    One-to-One
    No Connection
    One-to-Many
    60s
  • Q3
    What type of relationship would be suited for relation's Logs and Account? Refer to Figure A.
    Many-to-Many
    Many-to-One
    No Connection
    One-to-One
    60s
  • Q4
    What type of relationship would be suited for relation's Sent and Inbox? Refer to Figure A.
    One-to-One
    One-to-Many
    Many-to-Many
    No Connection
    60s
  • Q5
    What type of relationship would be suited for relation's Sent and Client Info? Refer to Figure A.
    Many-to-One
    One-to-One
    Many-to-Many
    No Connection
    60s
  • Q6
    What type of relationship would be suited for relation's Client Info and Inbox? Refer to Figure A.
    One-to-Many
    No Connection
    One-to-One
    Many-to-Many
    60s
  • Q7
    What type of relationship would be suited for relation's Role and Inbox? Refer to Figure A.
    Many-to-Many
    No Connection
    One-to-Many
    One-to-One
    60s
  • Q8
    What will be the ouput of the following query (Refer to figure B): SELECT PersonalInfo.Fullname, Logs.Remarks FROM PersonalInfo INNER JOIN Logs ON PersonalInfo.Student_ID = Accounts.Student_ID WHERE PersonalInfo.Student_ID = 1
    Ben T. Lador, Log In, Ben T. Lador, Log Out
    Error/No Output
    Ben T. Lador, Login
    Ben T. Lador, Login, Log out
    300s
  • Q9
    What will be the ouput of the following query (Refer to figure B): SELECT PersonalInfo.Fullname, Accounts.Username FROM PersonalInfo LEFT JOIN Accounts ON PersonalInfo.Student_ID = Accounts.Student_ID WHERE PersonalInfo.Student_ID = 7
    Dina L. Igo, Null
    Dina L. Igo
    Error/No output
    Dina L. Igo, Log Out
    300s
  • Q10
    What will be the ouput of the following query (Refer to figure B): SELECT PersonalInfo.Fullname, Accounts.Username, Logs.remarks FROM PersonalInfo Inner JOIN Accounts ON PersonalInfo.Student_ID = Accounts.Student_ID Inner Join Logs ON Accounts.Account_ID = Logs.Account_ID Where PersonalInfo.Student_ID = 5
    Error/No Output
    Gaspar D. Magiba, strong, Null
    Gaspar D. Magiba, mshaket, Log In
    Gaspar D. Magiba, strong, Log In
    300s
  • Q11
    A type of join which returns all records from the right table, and the matched records from the left table.
    Right Join
    Left Join
    Cross Join
    Inner Join
    30s
  • Q12
    A type of join which returns records that have matching values in both tables
    Cross Join
    Right Join
    Left Join
    Inner Join
    30s
  • Q13
    What SQL Statement would output the following record(Refer to Figure B): Fullname: Gaspar D. Magiba, Password: Strong
    SELECT PersonalInfo.Fullname, Accounts.Username FROM PersonalInfo Left JOIN Logs ON PersonalInfo.Student_ID = Logs.Account_ID Where PersonalInfo.Student_ID = 5
    SELECT PersonalInfo.Fullname, Accounts.Password FROM PersonalInfo Left JOIN Accounts ON PersonalInfo.Student_ID = Accounts.Student_ID Where PersonalInfo.Student_ID = 5
    SELECT PersonalInfo.Fullname, Accounts.Password FROM PersonalInfo Left JOIN Accounts ON PersonalInfo.Student_ID = Accounts.Student_ID
    SELECT PersonalInfo.Fullname, Accounts.Password FROM PersonalInfo Left JOIN Accounts ON PersonalInfo.Student_ID = Logs.Account_ID Where Accounts.Student_ID = 5
    300s
  • Q14
    What SQL Statement would output the following record(Refer to Figure B): Fullname: Dina L. Igo, Password: Null, Remarks: Null
    SELECT PersonalInfo.Fullname, Accounts.Password FROM PersonalInfo Left JOIN Accounts ON PersonalInfo.Student_ID = Accounts.Student_ID Where PersonalInfo.Student_ID = 7
    SELECT PersonalInfo.Fullname, Accounts.Password, Logs.Remarks FROM PersonalInfo Left JOIN Accounts ON PersonalInfo.Student_ID = Accounts.Student_ID Where PersonalInfo.Student_ID = 7
    SELECT PersonalInfo.Fullname, Accounts.Password, Logs.Remarks FROM PersonalInfo Left JOIN Accounts ON PersonalInfo.Student_ID = Accounts.Student_ID Left JOIN Logs ON Accounts.Account_ID = Logs.Account_ID Where PersonalInfo.Student_ID = 7
    300s
  • Q15
    With MySQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?
    SELECT * FROM Persons WHERE FirstName = 'Peter' AND LastName = 'Jackson'
    No such SQL exist
    SELECT * FROM Persons WHERE FirstName <> 'Peter' AND LastName <> 'Jackson'
    SELECT FirstName='Peter', LastName='Jackson' FROM Persons
    30s

Teachers give this quiz to your class