Logical schema.
Physical schema.
Subschema.
None of the above.
D. None of the above.
is the entire database
Describes how data is actually stored on disk.
is a standard way of organizing information into accessible parts.
All of the above
TCL
DCL
DDL
DML
add an attribute
delete an attribute
alter the default values of an attribute
all of the above
Sequential
Direct
Index sequential
None of the above
Entity set
File
Entity instance
Organization
Query languages and utilities
DML and query language
Data dictionary and transaction log
Data dictionary and query language
an attribute
a tuple
a criteria
a relation
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;
It is the data contained in database that is non redundant.
It is the data contained in database that is accurate and consistent.
It is the data contained in database that is secured.
It is the data contained in database that is shared.
1:1
1: Many
Many: One
Many : Many
2NF
3NF
BCNF
4NF
Edgar. W
Edward Stephen
Edgar F. Codd
Edward Codd
Network model.
Relational model.
Hierarchical model.
File based system.
Single
Three
Two
None
Primary
Foreign
Candidate
Alternate
one less
same
one more
half
schema
instance of the database
data domain
independence
A database design may be ambiguous.
It should avoid/reduce the redundancy.
Unrelated data should be in the same table so that updating the data will be easy.
An entity should not have attributes.
Operationally, if Y is deleted, so is X
existence is dependent on Y.
Operationally, if X is deleted, so is Y.
Operationally, if X is deleted, & remains the same.
partially committed
active
committed
none of the above
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 .
data is defined separately and not included in programs.
programs are not dependent on the physical attributes of data
programs are not dependent on the logical attributes of data
both B and C
Like
COMPARE
BETWEEN
IN
Hierarchic Standard Access Method
Hierarchic Sequential Access Method
Hierarchic Sequential and Method
Hierarchic Standard and Method
Entity
Attribute
Relationship
Notation
DBMS
System
Program
Software
Query
Embedded SQL
DDL
DCL
Clustered
Hashed
Un-clustered
Collision
Select
Order by
Group-by
Having
None
Multi
Single
Concurrent