Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
Give this quiz to my class
Q 1/20
Score 0
What type of relationship would be suited for relation's Client info and Account?
Refer to Figure A.
60
Many-to-Many
One-to-Many
One-to-One
No Connection
Q 2/20
Score 0
What type of relationship would be suited for relation's Role and Account?
Refer to Figure A.
60
Many-to-Many
One-to-One
No Connection
One-to-Many
20 questions
Q.
What type of relationship would be suited for relation's Client info and Account?
Refer to Figure A.
1
60 sec
Q.
What type of relationship would be suited for relation's Role and Account?
Refer to Figure A.
2
60 sec
Q.
What type of relationship would be suited for relation's Logs and Account?
Refer to Figure A.
3
60 sec
Q.
What type of relationship would be suited for relation's Sent and Inbox?
Refer to Figure A.
4
60 sec
Q.
What type of relationship would be suited for relation's Sent and Client Info?
Refer to Figure A.
5
60 sec
Q.
What type of relationship would be suited for relation's Client Info and Inbox?
Refer to Figure A.
6
60 sec
Q.
What type of relationship would be suited for relation's Role and Inbox?
Refer to Figure A.
7
60 sec
Q.
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
8
300 sec
Q.
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
9
300 sec
Q.
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
10
300 sec
Q.
A type of join which returns all records from the right table, and the matched records from the left table.
11
30 sec
Q.
A type of join which returns records that have matching values in both tables
12
30 sec
Q.
What SQL Statement would output the following record(Refer to Figure B):
Fullname: Gaspar D. Magiba, Password: Strong
13
300 sec
Q.
What SQL Statement would output the following record(Refer to Figure B):
Fullname: Dina L. Igo, Password: Null, Remarks: Null
14
300 sec
Q.
With MySQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?
15
30 sec
Q.
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"?
16
30 sec
Q.
With MySQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?
17
30 sec
Q.
How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?
18
30 sec
Q.
With MySQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?
