File organization that provides fast access to any arbitrary record
Hashed file
B-tree
Ordered file
Unordered file
Correct Answer :
A. Hashed file
Related Questions
Database locking concept is used to solve the problem of
Lost Update
Uncommitted Dependency
Inconsistent Data
All of the above
Relational Algebra is
Data Definition Language.
Data Manipulation Language
Procedural query Language
None of the above
EEPROM
Electrically Extractable Programmable Read Only Memory
Electrically Erasable Programmable Read Only Memory
Electronically Erasable Programmable Read Only Memory
Electrically Erasable Programmable Read Only Memory
An operation that will increase the length of a list is
insert
modify
lookup
none of the above
Which of the following produces the relation that has attributes of R1 and R2
Cartesian product
Difference
Intersection
Product
............... noise is caused by the random motion of the electrons in a wire and is avoidable.
Thermal
Intermodulation
Cross talk
Impulse
Which of the following is not a database object?
index
sequence
cursor
trigger
A transaction has following states
i) Active
ii) Fail
iii) Abort
iv) Commit
i and ii only
ii and iii only
i and iii only
iii and iv only
The ability to modify the conceptual schema without causing any change to the application program is known as
Physical data independence
Logical data independence
External data independence
Static data
The class based addressing is known as
Classless addressing
Classful addressing
Classified addressing
Classical addressing
An association of several structure of a data base can be expressed graphically by?
Tuple
Record
Relationship
Field
Count function in SQL returns the number of
values.
distinct values.
groups.
columns.
Which command is used to cancel privileges granted through the GRANT command ?
CANCEL
OVER
STOP
REVOKE
Which of the following statement returns data to the host variables one at a time?
SELECT
RETURN
FETCH
GET
Natural mask for a Class A network
255.0.0.0
255.255.0.0
255.255.255.0
none of these
In an object oriented model, one object can access data of another object by passing?
Instance variable
Variable
Message
Function
QBE
Query By Execution
Query By Example
Query By Extraction
None of the above.
Which of the following is the unit of signaling speed or modulation rate or the rate of symbol transmission?
Data rate
Bit rate
Signal to Noise Ratio
Baud rate
Select the incorrect statement
BCNF is stronger than 3NF
Relational algebra is a non-procedural language
Every conflict serializable schedule is view serializable.
none of the above
Repeaters operate in
i) Physical layer
ii) Datalink layer
iii) Transport layer
iv) Network layer
i and ii only
ii and iii only
ii only
i only
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.
An entity set that does not have sufficient attributes to form a primary key is a
strong entity set.
weak entity set.
simple entity set.
primary entity set.
A transaction is said to have terminated if it has
either committed or aborted
either partially committed or aborted
either committed or failed
none of these
Multivalued dependency is removed in
4 NF
3 NF
2 NF
1 NF
Consider the join of a relation R with relation S. If R has m tuples and S has n tuples,
then the maximum size of join is:
mn
m+n
m+n)/2
2 m+n)
Which of the following works as a filter?
UPDATE
DROP
ALTER
SELECT
Technique(s) used for data recovery after any failure
Logging
Recovery manager
Both A and B are true
Both A and B are false
Log into a computer across an internet
IMAP
TELNET
POP3
Infrared
Which of the following is not proper state of transaction ?
Partially aborted
Partially committed
Aborted
Committed
Unwanted energy from source other than the transmitter.
Attenuation
Distortion
Delay
Noise