Tertiary storage
magnetic tape
juke box
optical disk
All of the above
Correct Answer :
D. All of the above
Related Questions
Which of the following Key is used to represent relationship between the tables?
Primary key
Secondary Key
Foreign Key
None of these
The physical path over which a message travels
Thermal
Medium
Protocol
Impulse
A fragmentation is categorized in
1 part
2 part
3 part
4 part
A table that displays data redundancies yields ____________ anomalies
Insertion
Deletion
Update
All of the above
In a Hierarchical model records are organized as
Graph.
List.
Links.
Tree.
DBMS helps achieve
Data independence
Centralized control of data
Neither A) nor B)
both A) and B)
Volatile storage
loses its contents when power is switched off.
doesnt loses its contents when power is switched off.
creates backup when power is switched off.
none
A transaction which completes successfully is called
Granted
Committed
Compensated
Accomplished
A …………… is a memory area where data are processed.
view
trigger
cursor
none of the above
Select the correct
i) A timestamp-based scheduler cant produce live lock
ii) Aggregate functions cant appear with HAVING clause.
iii) Isolation is a property of database transaction.
i and ii only
ii and iii only
i and iii only
i only
Which of the following operator preserves unmatched rows of the relations being joined?
Inner join
Outer join
union
Intersect
The exists construct returns the value true, if the argument subquery is
empty
nonempty
contains null values
none of the above
UML is stands for
Universal Modeling Language
Unified Modeling Language
United Modeling Language
Uni Modeling Language
In defining the notion of the tuple variable, which one of the clause is useful?
as
by
from
none of the above
Which of the following file organization provides very fast access to any arbitrary record of a file?
Ordered file
Unordered file
Hashed file
B-tree
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).
An association of several structure of a data base can be expressed graphically by?
Tuple
Record
Relationship
Field
QBE
Query By Execution
Query By Example
Query By Extraction
None of the above.
Which of the following is not proper state of transaction ?
Partially aborted
Partially committed
Aborted
Committed
The class based addressing is known as
Classless addressing
Classful addressing
Classified addressing
Classical addressing
FDDI protocol operates in
i) Transport layer
ii) Network layer
iii) Datalink layer
iv) Physical layer
i and ii only
ii and iii only
i and iii only
iii and iv only
Size of source and destination address in IP header
4 bits
8 bits
12 bits
32 bits
Technique used in log based recovery
Immediate database modification
Graph-based recovery
key dependencies
none of the above
An advantage of the database management approach is
data is dependent on programs.
data redundancy increases.
data is integrated and can be accessed by multiple programs.
none of the above.
A subschema expresses
the logical view.
the physical view.
the external view.
all of the above.
Select the incorrect statement
View is derived from other tables.
Once a transaction has executed commit work its effect cant be undone by rollback work .
The input to the aggregate function avg can be non numeric data types
A primary key can never be null.
Log into a computer across an internet
IMAP
TELNET
POP3
Infrared
Data fragmentation is performed by the …… and each fragment is stored at…………..
DBMS, same site
OS ,same site
DBMS ,different site
OS ,different site
The race condition occurs when
Two concurrent processes attempt to interact with each other.
Two concurrent processes interact with different data files.
Two concurrent processes attempt to hold a data item .
none of the above.
Which of the following works as a filter?
UPDATE
DROP
ALTER
SELECT