Transaction processing is associated with everything below except
producing detail, summary, or exception reports.
recording a business activity.
confirming an action or triggering a response.
maintaining data.
Correct Answer :
C. confirming an action or triggering a response.
Related Questions
For large networks, _______ topology is used
Ring
Bus
Mesh
none of these
Data stored in cursor is called ……………
record
active data set
object
none of the above
Tape storage is referred to as
sequential access storage
direct access storage
random access storage
none of the above
The number of cursors depend on the
number of queries
number of attributes
size of memory area
none of these
A transaction has following states
i) Active
ii) Fail
iii) Abort
iv) Commit
i and ii only
ii and iii only
i and iii only
iii and iv only
The maximum number of children in a B-tree of order m is
m+1
m
m-1
m/2
Which of the following are the properties of entities?
Groups
Table
Attributes
Switchboards
The command used to delete a particular column in a relation
UPDATE
DROP
ALTER
DELETE
Full form of CIDR
Classful Inter Domain Routing
Classless International Domain Routing
Classless Inter Domain Routing
none of these
File organization that provides fast access to any arbitrary record
Hashed file
B-tree
Ordered file
Unordered file
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
Tertiary storage
magnetic tape
juke box
optical disk
All of the above
Mail services are available to network users through the
Session layer
Presentation layer
Application layer
Transport layer
Count function in SQL returns the number of
values.
distinct values.
groups.
columns.
RAID
Redundant Arrays of Independent Disks
Redundant Arrays of Independent Drives
Redundant Arrays of Interconnected Drives
Redundant Arrays of Interconnected Disks
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
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)
Authorization command in SQL
Allow
Access
Grant
none of the above
Which of the following normalization is needed, if an attribute of a composite key is dependent on an attribute of the other composite key?
BCNF
Second
Third
Fourth
Triggers are also called
active rules
passive rules
inferences
none of the above
The method of access which uses key transformation is known as
direct.
hash.
random.
sequential.
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 ________ 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
Which one of the following is provided by a data dictionary ?
User data
Database structure data
Sorted data
Functional data
Which of the following is/are error-free channel(s)
i) Noisy channel
ii) Noiseless channel
i only
ii only
Both
None of these
In an Entity-Relationship Diagram Diamonds represents
Attributes
Multi-valued attributes
Weak entity set
Relationship sets
Noiseless channel has ……… types of protocols.
2
3
4
5
Natural mask for a Class A network
255.0.0.0
255.255.0.0
255.255.255.0
none of these
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
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