Which of the following is a classical approach to database design?
Left Right approach
Right Left approach
Top Down approach
Bottom Up approach
Correct Answer :
C. Top Down approach
Related Questions
An association of several structure of a data base can be expressed graphically by?
Tuple
Record
Relationship
Field
Related fields in a database are grouped to form a
data file.
data record.
menu.
bank.
For large networks, _______ topology is used
Ring
Bus
Mesh
none of these
Which of the following statement returns data to the host variables one at a time?
SELECT
RETURN
FETCH
GET
The maximum number of children in a B-tree of order m is
m+1
m
m-1
m/2
In RDBMS, Data is presented as a collection of
Relation
Table
Attribute
Entity
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
In client/server computing data are
sent only upon the client's request
sent in complete copies for the client to filter and sort
never sent to the client machine
sent in very large sections to save processing time
In an E-R diagram attributes are represented by
rectangle.
square.
ellipse.
triangle.
The database environment has all of the following components except:
users.
separate files.
database.
database administrator.
Which of the following is not a database object?
index
sequence
cursor
trigger
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.
Which one of the following statements is false?
The data dictionary is normally maintained by the database administrator.
Data elements in the database can be modified by changing the data dictionary.
The data dictionary contains the name and description of each data element.
The data dictionary is a tool used exclusively by the database administrator.
Which of the following concurrency control schemes is not based on serializability property?
Two-phase locking
Timestamped based locking
Graph-based locking
none of the above
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
Which of the following is not a constraint on a single relation?
check
unique
not null
is duplicate
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
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
In mesh topology, if the number of devices is n , then the number of ports present in each device is
n
n+1
n-1
n/2
.................. 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
The ________ states that a foreign key must either match a primary key value in another relation or it must be null.
entity integrity rule
referential integrity constraint
composite attribute
action assertion
What does the number of attributes in a relation is called?
Cardinality
Degree
Tuple
Order
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above
Which of the following Key is used to represent relationship between the tables?
Primary key
Secondary Key
Foreign Key
None of these
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
Commit operation …………… writes the changes made to the database.
temporarily
permanently
none of these
all 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.
In which of the random-access method, stations do not sense the medium?
ALOHA
ETHERNET
CSMA/CA
CSMA/CD
The degree of the table with 500 rows and 7 columns is
500
7
3500
none of these
Which of the following operator preserves unmatched rows of the relations being joined?
Inner join
Outer join
union
Intersect