B-Tree
graph
Query Tree
directed graph
C. Query Tree
use database
database name use
Both A & B
None of them
i-only
ii-only
Both of them
None of them
Chain
Network
Tree
Relational
Double lines
Single line
Dashed lines
Triangle
Relations
Queries
Domains
All of the above
Hierarchical schema
Network schema
Relational Schema
All of the above
weak entity sets
weak relationship sets
strong entity sets
strong relationship sets
RAM
Flash
Hard Disk
Secondary
data redundancy increases
data is dependent on programs
data is integrated and can be accessed by multiple programs
none of the above
Relation
Tuple
Database
Domain
First normal form.
Second normal form.
Third normal form.
Fourth normal form.
Government Union Internet
Graphical Unit Interface
Graphical User Interface
Graphical University Interface
authorization and integrity manager
buffer manager
transaction manager
file manager
Total participation.
Multiple participation.
Cardinality N.
None of the above.
Union.
Set difference.
Intersection.
All of the above.
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
<>
<
=<
>=
Default
Index
Rule
View
Predicate calculus
Relational calculus
Relational algebra
SQL
m+n and 0
m+n and |m-n|
mn and 0
mn and m+n
Secondary key
Alternate key
Unique key
Primary key
Software
Server
Program
Client
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.
Statistical
Mathematical
Normalized
Un normalized
building indices
pipelining
join ordering
none of the above
Generalization.
Specialization.
Aggregation.
Inheritance.
repeatable read
read committed
read uncommitted
serializable
B-Tree
graph
Query Tree
directed graph
2NF
3NF
BCNF
4NF
Conceptual level data hiding.
External level data hiding.
Physical level data hiding.
None of these.