An advantage of the database management approach is
data redundancy increases
data is dependent on programs
data is integrated and can be accessed by multiple programs
none of the above
Correct Answer :
C. data is integrated and can be accessed by multiple programs
Related Questions
Which normal form is considered adequate for normal relational database design?
2NF
5NF
4NF
3NF
Which of the following is not comparison operator?
<>
<
=<
>=
_____ database is used to provide statistical information or summaries of values based on various criteria.
Statistical
Mathematical
Normalized
Un normalized
______contains information that defines valid values that are stored in a column or data type.
Default
Index
Rule
View
The data in the database at a particular moment of time is called the _______
Snapshot
Dynaset
Stateless
Stateful
A top-to-bottom relationship among the items in a database is established by a
Hierarchical schema
Network schema
Relational Schema
All of the above
The collection of information stored in a database at a particular moment is called as ......
schema
instance of the database
data domain
independence
DFD stands for
Data Flow Document
Data File Diagram
Data Flow Diagram
Non of the above
A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation R can have the same value for super key.
Sub
Parent
Candidate
Super
What is a disjoint less constraint?
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.
The size of a data item is called its _______, which can be a field of some record or may be a larger unit such as a record.
Similarity
Granularity
Dimensionality
Arity
Data independence means
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
operator is used to compare a value to a list of literals values that have been specified.
Like
COMPARE
BETWEEN
IN
In an E-R diagram double lines indicate
Total participation.
Multiple participation.
Cardinality N.
None of the above.
When an E-R diagram is mapped to tables, the representation is redundant for
weak entity sets
weak relationship sets
strong entity sets
strong relationship sets
Which of the following is not a recovery technique?
Deferred update
Immediate update
Two-phase commit
Shadow paging
A _____ is a logical unit of database processing that includes one or more data access operations that can include insertion, deletion, modification or retrieval operations.
Database
Data
Transaction
Record
An advantage of the database management approach is
data redundancy increases
data is dependent on programs
data is integrated and can be accessed by multiple programs
none of the above
Immediate database modification technique uses
Both undo and redo.
Undo but no redo.
Redo but no undo.
Neither undo nor redo.
A ______ module is typically designed so that it will run on a user workstation or personal computer.
Software
Server
Program
Client
Protection of data from unauthorized Disclosure results in loss of _______
Integrity
Availability
Confidentiality
Discretionary Security
Which of the following is true for network structure?
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.
A table can have only one
Secondary key
Alternate key
Unique key
Primary key
Which of the following relational algebra operations do not require the participating tables to be union-compatible?
Union
Intersection
Difference
Join
The _____ category includes storage media that can be operated on directly by the computers central processing unit.
Primary storage
Secondary Storage
All
Tertiary Storage
Dependency preservation is not guaranteed in
BCNF
3NF
PJNF
DKNF
The normal form that is not necessarily dependency preserving is
2NF
3NF
BCNF
4NF
_____ First proposed the process of normalization.
Edgar. W
Edward Stephen
Edgar F. Codd
Edward Codd
For correct behaviour during recovery, undo and redo operation must be
Commutative
Associative
idempotent
distributive
Which of the following concurrency control schemes is not based on the serializability property?
Two - phase locking
Graph-based locking
Time-stamp based locking
None of these .