B-Tree is used for
searching data
storing data
both A and B
none of these
Correct Answer :
A. searching data
Related Questions
The mode in which data item may be locked
Partner
Mutual
Exclusive
Atomic
A data dictionary contains:
i) The name of all fields in all files.
ii) The data type of all fields in all files.
iii) The width of all fields in all files.
only i)
only i) and ii)
only ii) and iii)
i) ii) iii)
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
In ………… paging we make copy of the current page table.
physical
logical
shadow
duplicate
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
.................. occurs due to velocity of propagation the frequency varies. Thus various frequency components of a signal arrive at the receiver at different times.
Noise
Delay distortion
Attenuation distortion
Dispersion
View never contains derived columns.
True
False
Cant say
none
Transaction access data using two operations
read(), print()
read(), write()
scan(), write()
none of the above
The control of concurrent execution is left with the
operating system
controller unit of the kernel
concurrency control component of the database system
none
A logical schema
is the entire database.
is a standard way of organizing information into accessible parts.
describes how data is actually stored on disk.
both A) and C)
Generalization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above
A composite attribute is converted to individual attributes in which of the following normal form ?
first
Second
third
fourth
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
The access protocol used by traditional Ethernet
CSMA/CA
CSMA/CD
CSMA
Token ring
Which command is used to cancel privileges granted through the GRANT command ?
CANCEL
OVER
STOP
REVOKE
The overall design of a database is called
Subschema of the database
Schema of the database
Structure of the database
View of the database
Secondary storage
magnetic disk
magnetic tape
juke box
cache
The transaction consists of all statements executed between
the begin transaction and end transaction
the start transaction and end transaction
the begin transaction and finish transaction
none of the above.
Referential integrity
controls relationships between operations of an object
controls relationships between instances of a class
controls relationships between attributes in a table
controls relationships between tables in a database
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
A transaction which completes successfully is called
Granted
Committed
Compensated
Accomplished
What is the result of the following SQL statement ?
SELECT A.emp_Name, B.ph_num
FROM emp A LEFT OUTER JOIN phone B
ON A. emp_ID = B.emp_ID
A list of employees phone number
A list of all employees that have spouses, with phone number included in the list
A list of all employees names, including the phone number if they have one
Two lists : One list of employees, the other of phone numbers
The union of primary keys of a related entity becomes …………. Of a relation.
primarykey
superkey
candidatekey
foreignkey
What is ACID properties of Transactions?
Atomicity, Consistency, Isolation, Database
Atomicity, Consistency, Isolation, Durability
Atomicity, Consistency, Inconsistent, Durability
Automatically, Concurrency, Isolation, Durability
Thermal noise is often referred to as ............... noise, because it affects uniformly the different frequencies.
Gray
White
Blue
Black
In E-R diagram Generalization is represented by
Circle
Rectangle
Hyperbola
Triangle
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
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.
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 is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above