Triggers & Views
These are the operations that can be used for Triggers.
What are Updates, Deletes, and Inserts?
These are some of the benefits of SQL Partitions.
What Are?
-Queries are faster because you are only reading part of a table
-Maintenance may be simplified because data is organized
-Flexible Index Placement
The Benefits of Normalization
What are:
- Prevents Data storage redundancy
- Ensures data is logically stored
- Ensures proper relationship between tables
They generally don’t rely on fixed schemas or structured data.
They are typically distributed and horizontally scalable.
They use different data modules that tabular databases.
What are No-SQL Database Management Systems?
A Set Operation where all elements that exist in Both sets only are returned.
What is Intersection?
nn
Primary Key,
Foreign Key,
Unique,
Default,
Check,
Not Null
What are types of constraints?
This is the Level that triggers operate on.
(Levels can include Databases, Tables, Rows, and Columns)
What is a Table?
What are By Range, By List, and By Hash?
2NF and
3NF
Not 4NF or 5NF.
What normal forms are concerned with preserving Functional Dependencies?
Stores data in a graph based model.
Both nodes and edges contain properties.
Edges represent relationships.
What is Neo4j?
A Set Operation where all elements from the first are paired in a tuple with all possible combinations of elements from the second.
What is Cartesian Product?
x
A Domain of a column (or type) where a fixed number of bytes are reserved for storage. No matter how much is stored, the total number of bytes is reserved.
What is char([byte count])?
These are the benefits of using Views, often seen as Virtual Tables.
What are the following?
- Simplicity for queries
- An easy way to join two tables once and reuse that join
- Structural Simplicity
- Helps with Data Integrity
What is the term for the process of Restoring Database to correct state after a failure?
Each table cell should contain a single value
Each record needs to be unique
What is 1st Normal Form?
A document-oriented database that is great at horizontal scaling. It stores all data in a format called BSON which is a superset of JSON.
What is MongoDB?
The number of attributes or columns they contain.
What is the Degree of a Relation?
CREATE DATABASE
CREATE SCHEMA
CREATE TABLE
CREATE INDEX
ALTER TABLE
RENAME TABLE
DROP TABLE
DROP INDEX
TRUNCATE
What are SQL DDL Commands?
What are before the operation executes and after the operation executes?
These are commands that generate a transaction.
What are Update, Insert, Delete?
Depends on lower normal forms
Each non-key value is dependent only on a single column primary key
What is 2nd Normal Form?
Uses a Key-Value model to store data. It is an In-Memory and persistent on-disk database.
What is Redis?
Uses the symbol
sigma
What is the Select Operation?
Converts the Data type of a Select statement.
What is the Convert command?
All columns or a subset of columns
What columns can a view joining two tables include?
Two transactions each wait for a lock held by the other.
What is a Deadlock?
Have no transitive functional dependencies (An attribute is not dependent on another non-key attribute in the table)
What is 3rd Normal Form?
The former is the meaning of the database transaction model acronym used by SQL.
The latter is the meaning of the database transaction model acronym used by most No-SQL Databases.
What are Atomic, Consistent, Isolated and Durable
and
What are Basically Available, Soft State, and Eventually Consistent?
Uses the symbol
Pi
What is the Project operation?
A wildcard *.
What retrieves all columns of data in a select statement?
The SQL syntax for creating a view.
What is?
CREATE VIEW <view_name> AS
SELECT <column_names>,
FROM <table_names>
<conditions>
These are the aspects of Partitions.
What are:
The partition column(s) must be a primary key
Partition ranges must be maintained
Partitions use a column to partition the table
There are no non-trivial functional dependencies of attributes on anything other than a superset of a candidate key.
What is BNF?
Is organized into column families, which group related data together, and stores data in rows, with each row identified by a unique key.
The columns within a row can be dynamically added or deleted, providing great flexibility in data modeling.
What is HBASE?
He started out with a paper in 1874 by proving that the set of real numbers was greater than the set of natural numbers, though both sets are infinite. He also established the 1-to-1 correspondence in set theory.
Who is George Cantor?
Removes a privilege in SQL.
What is the Revoke command?