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
D. All of the above
Primary Key
Local Key
Foreign Key
Composite Key
record
string
title
list
primary key
secondary key
foreign key
none of the above
left outer join
right outer join
full outer join
inner join
Recovery measures.
Security measures.
Concurrency measures.
uthorization measures.
IX
IS
S
SIX
Vulcanizing
Galvanizing
Magnetizing
Passing UV rays
2NF
3NF
BCNF
4NF
Commutative
Associative
idempotent
distributive
the pin code
the last name
the compound key first name and last name
Tr from next page
DBMS
System
Program
Software
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.
Snapshot
Dynaset
Stateless
Stateful
Secondary key
Alternate key
Unique key
Primary key
No functional dependencies (FDs) exist.
No multivalued dependencies (MVDs) exist.
No partial FDs exist.
No partial MVDs exist.
Commit overhead
Data fragmentation
Garbage collection
All of these
Like
COMPARE
BETWEEN
IN
Table
Tree like structure
Complex logical relationship
Records
schema
instance of the database
data domain
independence
i-only
ii-only
Both of them
None of them
read Q
write Q
both read and write Q
write Q but not read Q
Conceptual level data hiding.
External level data hiding.
Physical level data hiding.
None of these.
Constraints
Triggers
Stored procedure
Cursors
Select * from R natural join S.
Select * from R cross join S.
Select * from R union join S.
Select * from R inner join S.
no redo
no undo
redo but no undo
neither redo nor undo
Aggregation
Association
Weak entity sets
Weak relationship sets
Union.
Set difference.
Intersection.
All of the above.
Network model.
Relational model.
Hierarchical model.
File based system.
data redundancy increases
data is dependent on programs
data is integrated and can be accessed by multiple programs
none of the above
Conceptual, physical and internal
Conceptual, view and external
Logical, physical and internal
Logical, physical and view