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
  • 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

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
    Edit
    Delete
  • 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
    Edit
    Delete
  • 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
    Edit
    Delete
  • 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
    Edit
    Delete
  • 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
    Edit
    Delete
  • 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
    Edit
    Delete
  • 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
    Edit
    Delete
  • 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
    Edit
    Delete
  • 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
    Edit
    Delete
  • 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
    Edit
    Delete
  • 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
    Edit
    Delete
  • Q12
    A type of join which returns records that have matching values in both tables
    Cross Join
    Right Join
    Left Join
    Inner Join
    30s
    Edit
    Delete
  • 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
    Edit
    Delete
  • 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
    Edit
    Delete
  • 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
    Edit
    Delete
  • Q16
    With MySQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?
    No such SQL Statement exist
    SELECT * FROM Persons WHERE LastName Between 'Hansen' AND 'Pettersen'
    SELECT LastName> 'Hansen' AND LastName < 'Pettersen' FROM Persons
    SELECT * FROM Persons WHERE LastName> 'Hansen' AND LastName < 'Pettersen'
    30s
    Edit
    Delete
  • Q17
    With MySQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?
    No such SQL Statement exist
    INSERT INTO Persons (LastName) VALUES ('Olsen')
    INSERT INTO Persons ('Olsen') INTO (LastName)
    INSERT ('Olsen') INTO Persons (LastName)
    30s
    Edit
    Delete
  • Q18
    How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?
    UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'
    UPDATE Persons SET LastName='Hansen' WHERE LastName='Nilsen'
    MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'
    MODIFY Persons SET LastName='Hansen' WHERE LastName='Nilsen'
    30s
    Edit
    Delete
  • Q19
    With MySQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?
    DELETE FROM Persons WHERE FirstName = 'Peter'
    No such SQL Statement Exist
    DELETE FirstName = 'Peter' FROM Persons
    DELETE ROW FirstName = 'Peter' FROM Persons
    30s
    Edit
    Delete
  • Q20
    What are the supported types of joins in MySQL?
    INNER JOIN, LEFT JOIN, RIGHT JOIN, OUTER JOIN, UNION
    INNER JOIN, LEFT JOIN, RIGHT JOIN, CROSS JOIN, UNION
    INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, SELF JOIN
    INNER JOIN, LEFT JOIN, RIGHT JOIN, CROSS JOIN, SELF JOIN
    30s
    Edit
    Delete

Teachers give this quiz to your class