primary key
secondary key
foreign key
none of the above
C. foreign key
Transaction management
Application programmer
Concurrency control
Recovery management
inner join
full outer join
right outer join
all of the above
Aggregation
Association
Weak entity sets
Weak relationship sets
Instance
Program
Schema
Super Key
Commit overhead
Data fragmentation
Garbage collection
All of these
It will result in a deadlock situation.
It will immediately be rejected.
It will immediately be granted.
It will be granted as soon as it is released by A .
2NF
5NF
4NF
3NF
detecting view serializability.
detecting conflict serializability.
deadlock prevention
deadlock detection
Lost update problem.
Update anomaly.
Unrepeatable read.
Dirty read.
Conceptual level data hiding.
External level data hiding.
Physical level data hiding.
None of these.
2NF
3NF
BCNF
1NF
building indices
pipelining
join ordering
none of the above
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
Sub
Parent
Candidate
Super
Query
Embedded SQL
DDL
DCL
No functional dependencies (FDs) exist.
No multivalued dependencies (MVDs) exist.
No partial FDs exist.
No partial MVDs exist.
Data Definition Language .
Meta Language
Procedural query Language
None of the above
backup
assertion
recovery
trigger
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.
(i) and (ii)
(iv) only
(i) and (iv)
(ii) and (iii)
None
Multi
Single
Concurrent
Integrity
Availability
Confidentiality
Discretionary Security
repeatable read
read committed
read uncommitted
serializable
Indirect addressing
Indexed addressing
PC relative addressing
Base register addressing
Entity set
File
Entity instance
Organization
Fields
Records
Relations
Keys
Union
Intersection
Cartesian Product
Select
Deferred update
Immediate update
Two-phase commit
Shadow paging
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));
Primary storage
Secondary Storage
All
Tertiary Storage