0 of 12 questions completed
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
0 of 12
Time has elapsed
0 of 0 point(s), (0)
0 of 0, (0)
Essay(s) Pending: 0 (Possible Point(s): 0)
Which data type allows only a pre-defined list of values within the field?
Which of the following methods of join will only show the overlapping matches between the two tables that are being combined?
For the tables below, your client asked if you could create a table that lists all the teachers with their corresponding students that they are linked to. But the client also wanted all the teachers that don’t have assigned students to be in the list. If you are using the teacher table as the source table and joining the student table to the teacher table, which method of join should you use?
For the data type VARCHAR(number) in MySQL, it takes a number as an a parameter. What does this number mean?
You are creating a database in MySQL for tire pressure in cars. The client stated that their sensors provides the pressure down to one decimal point and they would like the data that’s given from the sensors to be stored without any loss of information. Tire pressure in cars could be anywhere between zero and 40, but the client doesn’t think it will ever go up more than 60. What data type should you use?
Which of the following is incorrect, in regards of the code below?
You were asked to create a table that lists the teachers with the corresponding student’s name next to the teacher’s name. Here is the ER Diagram for the database that you are working with. You’ve started to write the code in MySQL. What would be the correct syntax to complete this code?
SELECT teacher.teacher_name, student.student_name
Which of the following is incorrect, in regards of the MySQL code below?
Which of the following statements is correct regarding the MySQL code below?
Which of the following statements is correct regarding the table description below?
For the database built on the ER Diagram below, the client is asking for a table that lists the runner’s name, the race that they ran, and the name of the course the race was in. They don’t need blank fields, so for they don’t need rows for runners that don’t have a record for a race. What would be the best approach to achieve this?
Which of the statements below regarding a database built on the ER Diagram below is correct?