Which one of the following is provided by a data dictionary ?
User data
Database structure data
Sorted data
Functional data
Correct Answer :
B. Database structure data
Related Questions
The degree of the table with 500 rows and 7 columns is
500
7
3500
none of these
Which of the following is a classical approach to database design?
Left Right approach
Right Left approach
Top Down approach
Bottom Up approach
Specialization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above
Database locking concept is used to solve the problem of
Lost Update
Uncommitted Dependency
Inconsistent Data
All of the above
When all attributes in a relation tuple are not functionally dependent only on the key attribute. Which of the following normalization is needed?
first
second
third
fourth
The union of primary keys of a related entity becomes …………. Of a relation.
primarykey
superkey
candidatekey
foreignkey
Encoding method which does not provide for synchronization
B8ZS
Manchester
RZ
NRZ-L
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
If the .................... is too much, the receiver may not be able to detect the signal at all or the signal may fall below the noise level.
Noise
Delay
Dispersion
Attenuation
............... noise is caused by the random motion of the electrons in a wire and is avoidable.
Thermal
Intermodulation
Cross talk
Impulse
QBE
Query By Execution
Query By Example
Query By Extraction
None of the above.
Which of the following layer uses trailer of the frame for error detection?
Transport layer
Network layer
Datalink layer
None of these
An operation that will increase the length of a list is
insert
modify
lookup
none of the above
Which of the following will NOT eliminates the ambiguities of a null value?
Define the attribute as required
Define subtypes
Define each attribute as having an initial value that is recognized as blank
Define supertypes
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
Electromagnetic spectrum included in radiowaves are
i) Super High Frequency (SHF)
ii) Very High Frequency (VHF)
iii) Ultra High Frequency (UHF)
iv) High Frequencies (HF)
i, ii and iii only
i, ii and iv only
ii, iii and iv only
i, iii and iv only
DBMS utility which allows to reconstruct the correct state of database from the backup and history of transactions
Backup
Recovery
Grant
Troubleshooting
Mail services are available to network users through the
Session layer
Presentation layer
Application layer
Transport layer
Which of the following is/are error-free channel(s)
i) Noisy channel
ii) Noiseless channel
i only
ii only
Both
None of these
Which of the following operator preserves unmatched rows of the relations being joined?
Inner join
Outer join
union
Intersect
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.
The index table has …… Columns.
1
2
3
4
In a Hierarchical model records are organized as
Graph.
List.
Links.
Tree.
A table that displays data redundancies yields ____________ anomalies
Insertion
Deletion
Update
All of the above
Which of the following extracts its data from the result of an SQL SELECT statement.
View
Synonym
Sequence
Transaction
Noisy channel has ……… .. types of protocols
two
three
four
none
A relation that has no partial dependencies is in which normal form
First
Second
Third
BCNF
The maximum number of children in a B-tree of order m is
m+1
m
m-1
m/2
A composite attribute is converted to individual attributes in which of the following normal form ?
first
Second
third
fourth