No functional dependencies (FDs) exist.
No multivalued dependencies (MVDs) exist.
No partial FDs exist.
No partial MVDs exist.
C. No partial FDs exist.
Single global database
Multiple databases
Top-down approach
None of the above
Code
Codd
Boyce Codd
Boyce
Sub
Parent
Candidate
Super
use database
database name use
Both A & B
None of them
IX
IS
S
SIX
Select * from R natural join S.
Select * from R cross join S.
Select * from R union join S.
Select * from R inner join S.
programming
navigation
functioning
notification
Vulcanizing
Galvanizing
Magnetizing
Passing UV rays
jamming
password
documentation
record lock
Conceptual level data hiding.
External level data hiding.
Physical level data hiding.
None of these.
Relation
Tuple
Database
Domain
distinct values
cannot have NULL
both (A) & (B)
same as primary key
Clustered
Hashed
Un-clustered
Collision
the pin code
the last name
the compound key first name and last name
Tr from next page
Logical
Physical
None
Theoretical
Unary Operator
Ternary Operator
Binary Operator
Not an operator
Indirect addressing
Indexed addressing
PC relative addressing
Base register addressing
UPDATE S CITY = KANPUR WHERE SNO=S1
UPDATE S SET CITY = KANPUR FOR SNO=S1
UPDATE S SET CITY = KANPUR WHERE SNO=S1
UPDATE S RENAME CITY = KANPUR WHERE SNO=S1
Union
Intersection
Difference
Join
Atomicity
Concurrency
Isolation
Durability
None
Multi
Single
Concurrent
Data Flow Document
Data File Diagram
Data Flow Diagram
Non of the above
detecting view serializability.
detecting conflict serializability.
deadlock prevention
deadlock detection
weak entity sets
weak relationship sets
strong entity sets
strong relationship sets
DML compiler
DML pre-processor
DDL interpreter
Query interpreter
With finer degree of granularity of locking a high degree of concurrency is possible.
Locking prevents non-serializable schedules.
Locking cannot take place at field level.
An exclusive lock on data item X is granted even if a shared lock is already held on X.
Recovery measures.
Security measures.
Concurrency measures.
uthorization measures.
repeatable read
read committed
read uncommitted
serializable
authorization and integrity manager
buffer manager
transaction manager
file manager
Database
Data
Transaction
Record