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 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
- Q1What type of relationship would be suited for relation's Client info and Account? Refer to Figure A.Many-to-ManyOne-to-ManyOne-to-OneNo Connection60s
- Q2What type of relationship would be suited for relation's Role and Account? Refer to Figure A.Many-to-ManyOne-to-OneNo ConnectionOne-to-Many60s
- Q3What type of relationship would be suited for relation's Logs and Account? Refer to Figure A.Many-to-ManyMany-to-OneNo ConnectionOne-to-One60s
- Q4What type of relationship would be suited for relation's Sent and Inbox? Refer to Figure A.One-to-OneOne-to-ManyMany-to-ManyNo Connection60s
- Q5What type of relationship would be suited for relation's Sent and Client Info? Refer to Figure A.Many-to-OneOne-to-OneMany-to-ManyNo Connection60s
- Q6What type of relationship would be suited for relation's Client Info and Inbox? Refer to Figure A.One-to-ManyNo ConnectionOne-to-OneMany-to-Many60s
- Q7What type of relationship would be suited for relation's Role and Inbox? Refer to Figure A.Many-to-ManyNo ConnectionOne-to-ManyOne-to-One60s
- Q8What 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 = 1Ben T. Lador, Log In, Ben T. Lador, Log OutError/No OutputBen T. Lador, LoginBen T. Lador, Login, Log out300s
- Q9What 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 = 7Dina L. Igo, NullDina L. IgoError/No outputDina L. Igo, Log Out300s
- Q10What 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 = 5Error/No OutputGaspar D. Magiba, strong, NullGaspar D. Magiba, mshaket, Log InGaspar D. Magiba, strong, Log In300s
- Q11A type of join which returns all records from the right table, and the matched records from the left table.Right JoinLeft JoinCross JoinInner Join30s
- Q12A type of join which returns records that have matching values in both tablesCross JoinRight JoinLeft JoinInner Join30s
- Q13What SQL Statement would output the following record(Refer to Figure B): Fullname: Gaspar D. Magiba, Password: StrongSELECT PersonalInfo.Fullname, Accounts.Username FROM PersonalInfo Left JOIN Logs ON PersonalInfo.Student_ID = Logs.Account_ID Where PersonalInfo.Student_ID = 5SELECT PersonalInfo.Fullname, Accounts.Password FROM PersonalInfo Left JOIN Accounts ON PersonalInfo.Student_ID = Accounts.Student_ID Where PersonalInfo.Student_ID = 5SELECT PersonalInfo.Fullname, Accounts.Password FROM PersonalInfo Left JOIN Accounts ON PersonalInfo.Student_ID = Accounts.Student_IDSELECT PersonalInfo.Fullname, Accounts.Password FROM PersonalInfo Left JOIN Accounts ON PersonalInfo.Student_ID = Logs.Account_ID Where Accounts.Student_ID = 5300s
- Q14What SQL Statement would output the following record(Refer to Figure B): Fullname: Dina L. Igo, Password: Null, Remarks: NullSELECT PersonalInfo.Fullname, Accounts.Password FROM PersonalInfo Left JOIN Accounts ON PersonalInfo.Student_ID = Accounts.Student_ID Where PersonalInfo.Student_ID = 7SELECT PersonalInfo.Fullname, Accounts.Password, Logs.Remarks FROM PersonalInfo Left JOIN Accounts ON PersonalInfo.Student_ID = Accounts.Student_ID Where PersonalInfo.Student_ID = 7SELECT 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 = 7300s
- Q15With 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 existSELECT * FROM Persons WHERE FirstName <> 'Peter' AND LastName <> 'Jackson'SELECT FirstName='Peter', LastName='Jackson' FROM Persons30s