1Z0-006 Jeopardy (:D)

Keys and Relationships

100

A UID attribute made only for the purpose of identification.

What is an Artificial UID

200

When an entity contains multiple attributes that could uniquely identify an instance, they are called ___________

What is a Candidate UID

300

A relationship between an entity and its self.

What is a Recursive Relationship.

400

The way to determine what candidate UID to use.

What is The Attribute With Most Control

500

A barred relationship creates this type of UID.

What is a Composed Attribute UID

Tracking Data Changes & Normalization

100

A ________ entity is used to track data changes over time

What is a History Entity

200

A table will contain no repeated groups or redundant data. 

What is First Normal Form

300

If any attributes are not dependent on the entire primary key, they must be moved to a new table with the primary key, also means no transitive dependencies.

What is Third Normal Form

400

 If a table has any multi-value attributes they must be moved to a separate entity.

What is Second Normal Form

500

One of these is not a goal of normalization

• Arrange data in logical groupings that describe part of a whole.
• Minimize the amount of duplicated data.
• Organize data so changes need to happen in one location.
• Design a table that allows data to be easily accessed and manipulated while retaining integrity.
• Ensure that only permitted individuals have access to all data.

What is Ensure that only permitted individuals have access to all data.

Types of Database Models

100

The simplest database model, used commonly but has limitations.

What is a flat-file model?

200

n this model, data is organized into a tree-like structure, and many-to-many relationships aren’t supported.

What is a hierarchical model?

300

 This model does not have structural independence, and relationships in large databases of this model can become very complex.

What is a network model?

400

This model is easy to make, but easier to create a poorly designed database model.

What is a relational model?

500

 This model was commonly used before the relational model was invented.

What is a network model?

Relational Database Concepts

100

A single element of a relation.

What is a tuple?

200

This concept states that the data visible to the users of the database must always be consistent.

What is data consistency?

300

The symbol used for this term in relational algebra is “R”  

What is a relation schema?

400

A logical and atomic unit of work which can contain more than one SQL statement.

 What is a transaction?  

500

This schema object can speed up access while querying a table.

What is an index?

SQL Basics

100

The full name of DDL

What is Data Definition Launguage?

200

Daily Double:

The full syntax for a create statement with at least 2 constraints and 4 columns.

What is 

CREATE table(

id NUMBER(6) PRIMARY KEY,

name VARCHAR2(50),

age NUMBER(3),

address_id NUMBER(8) FOREIGN KEY REFERENCES ADDRESS(id) 

);?

(or something like that)

300

The purpose of DML

What is manipulating data? (or something like that)

400

An Update statement that updates all people with the name John to the name joe

What is 

UPDATE people

SET name = "joe"

WHERE name = "John";

500

A statement that queries first and last name as Name, age/2 and only gets rows that have an age higher than 16

What is

SELECT (first_name + "" + last_name) 'Name', age/2

FROM people

WHERE age > 16; ?