Data Types and Combining tables

Quiz Summary:

0 of 12 questions completed

Questions:

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:

Results

Quiz complete. Results are being recorded.

Results

answered correctly

0 of 12

Your time

You have reached 0 of 0 point(s), (0)

Essay(s) Pending: 0 (Possible Point(s): 0)

Current
Review
Answered
Correct
Incorrect

Question
1 of 12

Question1
Which data type allows only a pre-defined list of values within the field?
- SELECT
- ENUM
- VARCHAR
- LIST
Correct

Incorrect
Question
2 of 12

Question2
Which of the following methods of join will only show the overlapping matches between the two tables that are being combined?
- RIGHT JOIN
- LEFT JOIN
- CROSS JOIN
- INNER JOIN
Correct

Incorrect
Question
3 of 12

Question3
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?
- RIGHT JOIN
- LEFT JOIN
- INNER JOIN
- CROSS JOIN
Correct

Incorrect
Question
4 of 12

Question4
For the data type VARCHAR(number) in MySQL, it takes a number as an a parameter. What does this number mean?
- The maximum length of characters that will be allowed in this field
- The maximum number of records that could be stored in this field
- The number of bytes that will be assigned to store the characters in this field
- The number of different characters that are allowed in this field
Correct

Incorrect
Question
5 of 12

Question5
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?
- FLOAT
- INT
- BOL
- VARCHAR
Correct

Incorrect
Question
6 of 12

Question6
Which of the following is incorrect, in regards of the code below?
- This is MySQL code to import data from a file directly into a table
- As the fields will be terminated by commas, the file is most likely a CSV file
- Each line in the file will be interpreted as a row
- Rows that start with "1" in the first field will be ignored
Correct

Incorrect
Question
7 of 12

Question7
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
FROM teacher
- INNER JOIN student on teacher.teacher_id=student.student_id;
- INNER JOIN student with teacher.teacher_id=student.student_id;
- INNER JOIN student on teacher_id=student_id;
- INNER JOIN student with teacher_id=student_id;
Correct

Incorrect
Question
8 of 12

Question8
Which of the following is incorrect, in regards of the MySQL code below?
- The runner_id will be auto populated with incremental values
- There could be up to 256 characters in the runner_name.
- The runner_name is a required field, so an entry will not be accepted without a runner_name.
- The runner_phonenumber will be stored as a String.
Correct

Incorrect
Question
9 of 12

Question9
Which of the following statements is correct regarding the MySQL code below?
- The output will show runners that don't have any race records.
- The output will show the most recent race results first and the oldest results at the bottom.
- The output will only show overlapping records where a runner_id is matched from both tables.
- The output will show any race records that have a runner_id that doesn't exist in the runner table.
Correct

Incorrect
Question
10 of 12

Question10
Which of the following statements is correct regarding the table description below?
- Values with decimals points are not allowed for course_distance
- The course_location will be stored as a String
- A course_name is not required for a record to be inserted in this table
- The course_id could be a mixture of letters and numbers
Correct

Incorrect
Question
11 of 12

Question11
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?
- INNER JOIN the runner table and race table, then INNER JOIN again with the course table
- CROSS JOIN the runner table and the course table, then CROSS JOIN with the race table
- LEFT JOIN the runner table with the race table, then LEFT JOIN with the course table
- INNER JOIN the runner table and the course table
Correct

Incorrect
Question
12 of 12

Question12
Which of the statements below regarding a database built on the ER Diagram below is correct?
- Runners could be connected to the course name that they raced in by doing a CROSS JOIN between the runner table and the course table
- When you are joining the course table to the race table, an INNER JOIN and LEFT JOIN could be different when matched by course_id
- When you are joining the race table to the runner table, an INNER JOIN and RIGHT JOIN will be the same if matched by runner_id
- When you are joining the race table to the runner table matching with the runner_id, a LEFT JOIN will not show runners that don't have race records
Correct

Incorrect

Data Types and Combining tables

Data Types and Combining tables

Data Types and Combining tables

Quiz Summary:

Information

Results

Results

Categories

Question1

Question2

Question3

Question4

Question5

Question6

Question7

Question8

Question9

Question10

Question11

Question12