All views are not updateable
The views may be referenced in an SQL statement whenever tables are referenced.
The views are instantiated at the time they are referenced and not when they are defined.
The definition of a view should not have GROUP BY clause in it.
D. The definition of a view should not have GROUP BY clause in it.
Tuple
Cardinality
Degree
Domain
Create table Employee(EMPNO int, EMPNAME char(10));
Create table Employee(EMPNO integer, EMPNAME String(10));
Create table Emplo(EMPNO number, EMPNAME string);
Create table Emp(EMPNO int, EMPNAME char(10));
Query languages and utilities
DML and query language
Data dictionary and transaction log
Data dictionary and query language
Data Manipulation
Data Definition
Data Control
None
add an attribute
delete an attribute
alter the default values of an attribute
all of the above
Logical
Physical
None
Theoretical
(i) and (ii)
(iv) only
(i) and (iv)
(ii) and (iii)
Fields
Records
Relations
Keys
Default
Index
Rule
View
system indexes
syst indexes
sys indexes
sysind
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;
Hierarchic Standard Access Method
Hierarchic Sequential Access Method
Hierarchic Sequential and Method
Hierarchic Standard and Method
It requires that an entity belongs to no more than one level entity set.
The same entity may belong to more than one level.
The database must contain an unmatched foreign key value.
An entity can be joined with another entity in the same level entity set.
B-Tree
graph
Query Tree
directed graph
Update Anomaly
Insertion Anomaly
Redundancy
Lost update problem
disjoint
partial
overlapping
single
Atomicity
Concurrency
Isolation
Durability
Snapshot
Dynaset
Stateless
Stateful
DISTINCT
UNIQUE
NULL
EXISTS
one less
same
one more
half
Keys
Program
Translators
Language Activity
Transaction management component of DBMS
Application Programmer
Concurrency control component of DBMS
Recovery management component of DBMS
schema
instance of the database
data domain
independence
Lost update problem.
Update anomaly.
Unrepeatable read.
Dirty read.
First normal form.
Second normal form.
Third normal form.
Fourth normal form.
Single global database
Multiple databases
Top-down approach
None of the above
m - 1
m + 1
m * m
m
Primary Key
Local Key
Foreign Key
Composite Key
BCNF
3NF
PJNF
DKNF
Like
COMPARE
BETWEEN
IN