Primary storage
Secondary Storage
All
Tertiary Storage
A. Primary storage
Atomicity
Concurrency
Isolation
Durability
Tuple
Cardinality
Degree
Domain
Snapshot
Dynaset
Stateless
Stateful
Statistical
Mathematical
Normalized
Un normalized
Entity set
File
Entity instance
Organization
Understand each user's perspective of data
Understand the data itself irrespective of the physical representation
Understand the use of data across application areas
All of the above
Clustered
Hashed
Un-clustered
Collision
Functional dependency
Multi-valued dependency
Transitive dependency
Partial dependency
Relations
Queries
Domains
All of the above
Query
Embedded SQL
DDL
DCL
Data Manipulation
Data Definition
Data Control
None
Total participation.
Multiple participation.
Cardinality N.
None of the above.
TCL
DCL
DDL
DML
record
string
title
list
View
Order by
Group by
Having
BCNF
3NF
PJNF
DKNF
ALTER TABLE Staff ALTER position DROP DEFAULT;
ALTER TABLE Staff ALTER position DEFAULT;
ALTER TABLE Staff ALTER DROP DEFAULT;
MODIFY Staff ALTER position DROP DEFAULT;
DML compiler
DML pre-processor
DDL interpreter
Query interpreter
the pin code
the last name
the compound key first name and last name
Tr from next page
Serializable schedule.
Recoverable schedule.
Deadlock free schedule.
Cascadeless schedule.
Unary Operator
Ternary Operator
Binary Operator
Not an operator
Selection operator.
Projection operator.
Aggregation operators.
Division operator.
First normal form.
Second normal form.
Third normal form.
Fourth normal form.
<>
<
=<
>=
Network model.
Relational model.
Hierarchical model.
File based system.
It is a physical representation of the data.
It allows many to many relationship.
It is conceptually simple.
It will be the dominant database of the future.
weak entity sets
weak relationship sets
strong entity sets
strong relationship sets
Standard query language
Sequential query language
Structured query language
Server side query language
B-Tree
graph
Query Tree
directed graph
alter
update
set
create