Data security
Derived columns
Hiding of complex queries
All of the above
A. Data security
Commutative
Associative
idempotent
distributive
DFD
Flowcharts
Gantt Charts
E-R
Instance
Program
Schema
Super Key
Clustered
Hashed
Un-clustered
Collision
Two - phase locking
Graph-based locking
Time-stamp based locking
None of these .
Sequential
Direct
Index sequential
None of the above
Both undo and redo.
Undo but no redo.
Redo but no undo.
Neither undo nor redo.
Recovery measures.
Security measures.
Concurrency measures.
uthorization measures.
disjoint
partial
overlapping
single
detecting view serializability.
detecting conflict serializability.
deadlock prevention
deadlock detection
data redundancy increases
data is dependent on programs
data is integrated and can be accessed by multiple programs
none of the above
DML compiler
DML pre-processor
DDL interpreter
Query interpreter
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.
Chain
Network
Tree
Relational
Update Anomaly
Insertion Anomaly
Redundancy
Lost update problem
Generalization.
Specialization.
Aggregation.
Inheritance.
Hierarchic Standard Access Method
Hierarchic Sequential Access Method
Hierarchic Sequential and Method
Hierarchic Standard and Method
theta join
outer join
natural join
composed join
add an attribute
delete an attribute
alter the default values of an attribute
all of the above
RAM
Flash
Hard Disk
Secondary
read Q
write Q
both read and write Q
write Q but not read Q
Lost update problem.
Update anomaly.
Unrepeatable read.
Dirty read.
Atomicity
Concurrency
Isolation
Durability
Indirect addressing
Indexed addressing
PC relative addressing
Base register addressing
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));
Edgar. W
Edward Stephen
Edgar F. Codd
Edward Codd
Procedural DML.
Non-Procedural DML.
Procedural DDL.
Non-Procedural DDL.
<>
<
=<
>=
Logm(n)
(m+n)/2
Logm/2(m+n)
None of these
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.