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
Correct Answer :
A. sent only upon the client's request
Related Questions
The output of the Data Definition Language is stored in the
view table
schema
metadata
all 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
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above
For large networks, _______ topology is used
Ring
Bus
Mesh
none of these
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.
Functional dependencies are generalization of
Relation dependencies
Data dependencies
key dependencies
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
Thermal noise is often referred to as ............... noise, because it affects uniformly the different frequencies.
Gray
White
Blue
Black
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
Which of the following is/are error-free channel(s)
i) Noisy channel
ii) Noiseless channel
i only
ii only
Both
None of these
The syntax to select all column from the table is
select all from tablename
select * from tablename
select from tablename
none of these
Natural mask for a Class A network
255.0.0.0
255.255.0.0
255.255.255.0
none of these
What is ACID properties of Transactions?
Atomicity, Consistency, Isolation, Database
Atomicity, Consistency, Isolation, Durability
Atomicity, Consistency, Inconsistent, Durability
Automatically, Concurrency, Isolation, Durability
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
Select the incorrect statement(s)
i) Shared locks are compatible with each other.
ii) A relation which is in 3NF may have redundancy due to composite keys.
iii) A table in a database can have multiple indexes.
i only
ii, only
ii, iii only
none of the above
.................. 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
Disk storage is referred to as
sequential access storage
direct access storage
random access storage
none of the above
Technique(s) used for data recovery after any failure
Logging
Recovery manager
Both A and B are true
Both A and B are false
Only one communication channel is needed rather than n channels to transmit data between two communicating devices
parallel
serial
analog
digital
Database locking concept is used to solve the problem of
Lost Update
Uncommitted Dependency
Inconsistent Data
All of the above
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
In E-R diagram Generalization is represented by
Circle
Rectangle
Hyperbola
Triangle
In this data model each record can hae more than one parent
Hierarchical model
E-R model
Network based model
none of these
File organization that provides fast access to any arbitrary record
Hashed file
B-tree
Ordered file
Unordered file
In which of the following transmissions, we can send data by grouping n bits at a time instead of a single bit?
parallel
serial
analog
digital
A subschema expresses
the logical view.
the physical view.
the external view.
all of the above.
A transaction which completes successfully is called
Granted
Committed
Compensated
Accomplished
Which command is used to cancel privileges granted through the GRANT command ?
CANCEL
OVER
STOP
REVOKE
Which of the following submit and execute query at run time?
Static SQL
Dynamic SQL
both
none of these
The method of access which uses key transformation is known as
direct.
hash.
random.
sequential.