A …………… is a memory area where data are processed.
view
trigger
cursor
none of the above
Correct Answer :
C. cursor
Related Questions
In a Hierarchical model records are organized as
Graph.
List.
Links.
Tree.
Thermal noise is often referred to as ............... noise, because it affects uniformly the different frequencies.
Gray
White
Blue
Black
As a side-effect of database update ,the system automatically executes a statement called
a view
a grant permission
a trigger
all of the above
The class based addressing is known as
Classless addressing
Classful addressing
Classified addressing
Classical addressing
By default a user who has been granted some form of authorization
is allowed to pass them to others
is not allowed to pass them to others
may be or may not be allowed to pass them to others
none
For large networks, _______ topology is used
Ring
Bus
Mesh
none of these
Which of the following are the properties of entities?
Groups
Table
Attributes
Switchboards
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
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
An association of several structure of a data base can be expressed graphically by?
Tuple
Record
Relationship
Field
The types of noiseless channels are
i) Selective Reject ARQ
ii) simplest protocol
iii) Go-Back-N ARQ
iv) Stop-and-Wait Protocol
i, ii only
ii and iv only
ii and iv only
i, iv only
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 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.
Which of the following submit and execute query at run time?
Static SQL
Dynamic SQL
both
none of these
Unwanted energy from source other than the transmitter.
Attenuation
Distortion
Delay
Noise
UML is stands for
Universal Modeling Language
Unified Modeling Language
United Modeling Language
Uni Modeling Language
The method by which the structure of the database is modified to eliminate hidden dependencies and replacing groups is
Normalization
Indexing
Enforcing referential integrity
Enforcing data integrity
Natural mask for a Class A network
255.0.0.0
255.255.0.0
255.255.255.0
none of these
A composite attribute is converted to individual attributes in which of the following normal form ?
first
Second
third
fourth
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
The output of the Data Definition Language is stored in the
view table
schema
metadata
all of the above.
…………… is responsible for using that the database remains in a consistent state despite system failure.
Storage manager
Admin
Transaction manager
none of the above
Noisy channel has ……… .. types of protocols
two
three
four
none
Data stored in cursor is called ……………
record
active data set
object
none of the above
What does a field or a combination of fields that has a unique value called ?
Foreign key
Secondary key
Primary key
Alternate key
Which of the following operator preserves unmatched rows of the relations being joined?
Inner join
Outer join
union
Intersect
Which of the following is not an Aggregate function?
Min
Max
Select
Avg
DBMS utility which allows to reconstruct the correct state of database from the backup and history of transactions
Backup
Recovery
Grant
Troubleshooting
.................. 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
Datalog is
procedural query language
nonprocedural query language
scan(), write()
none of the above