jamming
password
documentation
record lock
D. record lock
Single global database
Multiple databases
Top-down approach
None of the above
alter
update
set
create
system indexes
syst indexes
sys indexes
sysind
Predicate calculus
Relational calculus
Relational algebra
SQL
Vulcanizing
Galvanizing
Magnetizing
Passing UV rays
no redo
no undo
redo but no undo
neither redo nor undo
None
Multi
Single
Concurrent
one less
same
one more
half
Update Anomaly
Insertion Anomaly
Redundancy
Lost update problem
Data Definition Language .
Meta Language
Procedural query Language
None of the above
Data Flow Document
Data File Diagram
Data Flow Diagram
Non of the above
SQL server Profile
SQL server wizard.
SQL server service manager
SQL server setup
Logical schema.
Physical schema.
Subschema.
None of the above.
Commit overhead
Data fragmentation
Garbage collection
All of these
Referential constraint.
Index.
Integrity constraint.
Functional dependency.
code
data definition language
application program
schema
ALTER TABLE Staff ALTER position DROP DEFAULT;
ALTER TABLE Staff ALTER position DEFAULT;
ALTER TABLE Staff ALTER DROP DEFAULT;
MODIFY Staff ALTER position DROP DEFAULT;
schema
instance of the database
data domain
independence
backup
assertion
recovery
trigger
Secondary key
Alternate key
Unique key
Primary key
record
string
title
list
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.
First normal form.
Second normal form.
Third normal form.
Fourth normal form.
Logm(n)
(m+n)/2
Logm/2(m+n)
None of these
Network model.
Relational model.
Hierarchical model.
File based system.
read Q
write Q
both read and write Q
write Q but not read Q
Query languages and utilities
DML and query language
Data dictionary and transaction log
Data dictionary and query language
TCL
DCL
DDL
DML
Conceptual, physical and internal
Conceptual, view and external
Logical, physical and internal
Logical, physical and view
authorization and integrity manager
buffer manager
transaction manager
file manager