The method of access which uses key transformation is known as
direct.
hash.
random.
sequential.
Correct Answer :
B. hash.
Related Questions
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
Count function in SQL returns the number of
values.
distinct values.
groups.
columns.
A lock that allows concurrent transactions to access different rows of the same table is known as a
Field-level lock
Row-level lock
Table-level lock
Database-level lock
An association of several structure of a data base can be expressed graphically by?
Tuple
Record
Relationship
Field
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
Which of the following submit and execute query at run time?
Static SQL
Dynamic SQL
both
none of these
A transaction which completes successfully is called
Granted
Committed
Compensated
Accomplished
A transaction which may not complete its execution successfully is termed as
Failed
Aborted
Blocked
Finished
A functional dependency between two or more non-key attributes is called
Transitive dependency
Partial transitive dependency
Functional dependency
Partial functional dependency
Technique used in log based recovery
Immediate database modification
Graph-based recovery
key dependencies
none of the above
RAID
Redundant Arrays of Independent Disks
Redundant Arrays of Independent Drives
Redundant Arrays of Interconnected Drives
Redundant Arrays of Interconnected Disks
Which of the following is a classical approach to database design?
Left Right approach
Right Left approach
Top Down approach
Bottom Up approach
Every Boyce-Codd normal form is in
3NF
2NF
1NF
none of the above
Which of the following operator preserves unmatched rows of the relations being joined?
Inner join
Outer join
union
Intersect
In a Hierarchical model records are organized as
Graph.
List.
Links.
Tree.
Datalog is
procedural query language
nonprocedural query language
scan(), write()
none of the above
Secondary storage
magnetic disk
magnetic tape
juke box
cache
Primary storage
magnetic disk
magnetic tape
juke box
cache
In case of entity integrity, the primary key may be
not Null
Null
both Null & not Null.
any value.
Extended Entity Relationship model consists of which of the following
i) Specialization
ii) Generalization
iii) Categorization
i and ii only
ii and iii only
i and iii only
All i, ii iii
Which of the following layer uses trailer of the frame for error detection?
Transport layer
Network layer
Datalink layer
None of these
Disk storage is referred to as
sequential access storage
direct access storage
random access storage
none of the above
What is ACID properties of Transactions?
Atomicity, Consistency, Isolation, Database
Atomicity, Consistency, Isolation, Durability
Atomicity, Consistency, Inconsistent, Durability
Automatically, Concurrency, Isolation, Durability
For large networks, _______ topology is used
Ring
Bus
Mesh
none of these
State which of the following statements are True
i) TCP is connection oriented but unreliable
ii) UDP is connection oriented but unreliable
iii) TCP is connectionless but reliable
iv) UDP is connectionless but reliable
i and ii only
ii and iii only
i and iii only
None of these
A ………… clause permits a view definition to be used in multiple places within a query.
where
exist
with
select
The left outer join takes all tuples
in the left relation which didnt match with any tuple in right relation
in the left relation which matched with a tuple in right relation
in the right relation which didnt match with any tuple in left relation
in the right relation which matched with a tuple in left relation
Which command is used to cancel privileges granted through the GRANT command ?
CANCEL
OVER
STOP
REVOKE
Size of source and destination address in IP header
4 bits
8 bits
12 bits
32 bits
Select the correct statement
i) Aggregate functions work on a group of data and return a single value.
ii) ODBC connects the frontend with the database without considering its compatibility
iii) View definition cant be used at multiple places through with clause .
i and ii only
ii and iii only
i and iii only
i only