Test
Database Relationships
Este test tiene tipos de pregunta que se abren en el reproductor de siempre.
Preguntas del test (9)
1The process of splitting our information into separate tables to minimize duplication is known as:
- ASeparation
- BAllocation
- CNormalization
- DLinking
2A good way to tell if you need to normalize your data is by checking to see if you have any duplicate data
- AVerdadero
- BFalso
3To link table values together we define both PRIMARY KEYS and FOREIGN KEYS
- AVerdadero
- BFalso
4FOREIGN KEYS reference a PRIMARY KEY in a different table
- AVerdadero
- BFalso
5FOREIGN KEYS and PRIMARY KEYS are defined when the table is created
- AVerdadero
- BFalso
6To make id a primary key and genre id a foreign key, what syntax is used?
CREATE TABLE genres(
id SERIAL [blank_start]PRIMARY KEY[blank_end],
name VARCHAR(255)
);
CREATE TABLE movies(
id SERIAL PRIMARY KEY,
title VARCHAR(255),
year INT,
actor VARCHAR(255),
character VARCHAR(255),
genre_id INT [blank_start]REFERENCES genres(id)[blank_end]
);- APRIMARY KEY
- BREFERENCES genres(id)
7To reference two different tables in another table, you need to define a:
- Alink table
- Bconnection table
- Cjoin table
- Dreference table
8At a minimum, a join table needs to include a foreign key of both tables it is trying to join.
- AVerdadero
- BFalso
9Join tables are required for only one-to-many relationships
- AVerdadero
- BFalso
Información
- Descripción
- 1 (SQL) Web Development Test sobre Database Relationships, creado por jlangford el 05/06/2016.
- Autor
- jlangford
- Idioma
- English
- Visitas
- 0
- Etiquetas
- Valoración
- Aún sin valoraciones Valora este test
Más sobre Database Keys and Relationships