Which of the following is not proper state of transaction ?
Partially aborted
Partially committed
Aborted
Committed
Correct Answer :
A. Partially aborted
Related Questions
Disk storage is referred to as
sequential access storage
direct access storage
random access storage
none of the above
Unwanted energy from source other than the transmitter.
Attenuation
Distortion
Delay
Noise
Size of source and destination address in IP header
4 bits
8 bits
12 bits
32 bits
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
A transaction which may not complete its execution successfully is termed as
Failed
Aborted
Blocked
Finished
Aggregate functions are also called
serial functions
non-serial functions
row functions
column functions
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
EEPROM
Electrically Extractable Programmable Read Only Memory
Electrically Erasable Programmable Read Only Memory
Electronically Erasable Programmable Read Only Memory
Electrically Erasable Programmable Read Only Memory
The statement in SQL which allows to change the definition of a table is
Select
Update
Create
Alter
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
The ability to modify the conceptual schema without causing any change to the application program is known as
Physical data independence
Logical data independence
External data independence
Static data
A data manipulation command the combines the records from one or more tables is called
SELECT
PROJECT
JOIN
PRODUCT
State which of the following statements are True
i) TCP is connection oriented but unreliable
ii) UDP is connection oriented but unreliable
iii) TCP is connectionless but reliable
iv) UDP is connectionless but reliable
i and ii only
ii and iii only
i and iii only
None of these
A table that displays data redundancies yields ____________ anomalies
Insertion
Deletion
Update
All of the above
............... noise is caused by the random motion of the electrons in a wire and is avoidable.
Thermal
Intermodulation
Cross talk
Impulse
Which of the following extracts its data from the result of an SQL SELECT statement.
View
Synonym
Sequence
Transaction
An association of several structure of a data base can be expressed graphically by?
Tuple
Record
Relationship
Field
An operation that will increase the length of a list is
insert
modify
lookup
none of the above
Full form of CIDR
Classful Inter Domain Routing
Classless International Domain Routing
Classless Inter Domain Routing
none of these
DBMS helps achieve
Data independence
Centralized control of data
Neither A) nor B)
both A) and B)
The command used to delete a particular column in a relation
UPDATE
DROP
ALTER
DELETE
In an object oriented model, one object can access data of another object by passing?
Instance variable
Variable
Message
Function
A …………… is a memory area where data are processed.
view
trigger
cursor
none of the above
It is possible to define a schema completely using
VDL and DDL.
DDL and DML.
SDL and DDL.
VDL and DML.
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.
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
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
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
In two-phase locking protocol the two phases are
growing phase and shrinking phase
execution phase and blocking phase.
running phase and sleeping phase.
none of the above
File organization that provides fast access to any arbitrary record
Hashed file
B-tree
Ordered file
Unordered file