Gestalte GoConqr mit. Was sollen wir als Nächstes hinzufügen?

Quiz

Database Relationships

jlangford 9 Fragen

Quiz starten

Dieses Quiz enthält Fragetypen, die sich im gewohnten Player öffnen.

Fragen in diesem Quiz (9)

  1. 1The process of splitting our information into separate tables to minimize duplication is known as:
    1. ASeparation
    2. BAllocation
    3. CNormalization
    4. DLinking
  2. 2A good way to tell if you need to normalize your data is by checking to see if you have any duplicate data
    1. ARichtig
    2. BFalsch
  3. 3To link table values together we define both PRIMARY KEYS and FOREIGN KEYS
    1. ARichtig
    2. BFalsch
  4. 4FOREIGN KEYS reference a PRIMARY KEY in a different table
    1. ARichtig
    2. BFalsch
  5. 5FOREIGN KEYS and PRIMARY KEYS are defined when the table is created
    1. ARichtig
    2. BFalsch
  6. 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]
    );
    1. APRIMARY KEY
    2. BREFERENCES genres(id)
  7. 7To reference two different tables in another table, you need to define a:
    1. Alink table
    2. Bconnection table
    3. Cjoin table
    4. Dreference table
  8. 8At a minimum, a join table needs to include a foreign key of both tables it is trying to join.
    1. ARichtig
    2. BFalsch
  9. 9Join tables are required for only one-to-many relationships
    1. ARichtig
    2. BFalsch

Informationen

Beschreibung
1 Web Development (SQL) Quiz am Database Relationships, erstellt von jlangford am 05/06/2016.
Sprache
English
Aufrufe
0
Schlagwörter
web developmentsql1
Bewertung
Noch keine Bewertungen
Bewerte dieses Quiz
Bewerte dieses Quiz

Mehr zu Database Keys and Relationships

Feedback

Worum geht es?

Was sollen wir als Nächstes hinzufügen?