The physical location of a record is determined by a mathematical formula that transforms
a file key into a record location is :
B-Tree File
Hashed File
Indexed File
Sequential file.
Correct Answer :
B. Hashed File
Related Questions
Attenuation can be also expressed in decibel dB) and commonly used because.
i) Signal strengths often fall off logarithmically
ii) Cascade losses and gains can be calculated with simple additions and subtractions
i only
ii only
Both A and B
None of the above
The statement
Every foreign-key value must match a primary-key value in an associated table
Is related to
View
Cursor defination
Referential intergrity
Trigger
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
Which of the following is not a database object?
index
sequence
cursor
trigger
By default a user who has been granted some form of authorization
is allowed to pass them to others
is not allowed to pass them to others
may be or may not be allowed to pass them to others
none
Which of the following statement returns data to the host variables one at a time?
SELECT
RETURN
FETCH
GET
.................. is the loss of energy as the signal propagates outward, where the amount of energy depends on the frequency.
Noise
Delay distortion
Attenuation distortion
Dispersion
Which of the following aggregate function doesnt ignore NULLs in its results?
COUNT
COUNT(*)
MAX
none of these
A relation which is in 3NF is
in 1NF also
in 2NF also
free from transitive dependencies
All of these
DECLARE is a(an)
executable statement.
declarative statement.
Ordered file
none of the above
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
Datalog is
procedural query language
nonprocedural query language
scan(), write()
none of the above
Data integrity refers to
the uniqueness of the data in a database
the correctness and completeness of the data in a database
the un redundancies of the data in a database
Data independence of the database
Data stored in cursor is called ……………
record
active data set
object
none of the above
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
Which of the following works as a filter?
UPDATE
DROP
ALTER
SELECT
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
In a Hierarchical model records are organized as
Graph.
List.
Links.
Tree.
Data Manipulation Language DML) is not to
Create information table in the Database
Insertion of new information into the Database
Deletion of information in the Database
Modification of information in the Database
Size of source and destination address in IP header
4 bits
8 bits
12 bits
32 bits
Commit operation …………… writes the changes made to the database.
temporarily
permanently
none of these
all of the above
The access protocol used by traditional Ethernet
CSMA/CA
CSMA/CD
CSMA
Token ring
A ………… clause permits a view definition to be used in multiple places within a query.
where
exist
with
select
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above
A fragmentation is categorized in
1 part
2 part
3 part
4 part
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
RAID
Redundant Arrays of Independent Disks
Redundant Arrays of Independent Drives
Redundant Arrays of Interconnected Drives
Redundant Arrays of Interconnected Disks
What are the different types of radio waves that are used for computer network applications?
i) Spread spectrum
ii) High power, single frequency
iii) High power, multiple frequency
iv) Low power, single frequency
v) Low power, multiple frequency
i, ii and iii only
i, ii and iv only
ii, iii and iv only
i, iii and iv only
In an Entity-Relationship Diagram Diamonds represents
Attributes
Multi-valued attributes
Weak entity set
Relationship sets
Which of the following is/are error-free channel(s)
i) Noisy channel
ii) Noiseless channel
i only
ii only
Both
None of these