A transaction which may not complete its execution successfully is termed as
Failed
Aborted
Blocked
Finished
Correct Answer :
B. Aborted
Related Questions
Select the incorrect statement
View is derived from other tables.
Once a transaction has executed commit work its effect cant be undone by rollback work .
The input to the aggregate function avg can be non numeric data types
A primary key can never be null.
Which of the following aggregate function doesnt ignore NULLs in its results?
COUNT
COUNT(*)
MAX
none of these
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.
Commit operation …………… writes the changes made to the database.
temporarily
permanently
none of these
all 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
An association of several structure of a data base can be expressed graphically by?
Tuple
Record
Relationship
Field
In the architecture of a database system external level is the
physical level.
logical level.
conceptual level
view level.
A relation which is in 3NF is
in 1NF also
in 2NF also
free from transitive dependencies
All of these
A transaction which completes successfully is called
Granted
Committed
Compensated
Accomplished
.................. 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
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
The degree of the table with 500 rows and 7 columns is
500
7
3500
none of these
.................. means sending a digital signal over a channel without changing the digital signal to an analog signal.
Baseband transmission
Broadband transmission
Digital transmission
Analog transmission
UML is stands for
Universal Modeling Language
Unified Modeling Language
United Modeling Language
Uni Modeling Language
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.
Functional dependencies are generalization of
Relation dependencies
Data dependencies
key dependencies
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 responsible for using that the database remains in a consistent state despite system failure.
Storage manager
Admin
Transaction manager
none of the above
An operation that will increase the length of a list is
insert
modify
lookup
none of the above
In this data model each record can hae more than one parent
Hierarchical model
E-R model
Network based model
none of these
View never contains derived columns.
True
False
Cant say
none
Cross Product is a:
Unary Operator
Binary Operator
Ternary Operator
none of the above
Which topology requires a central controller or hub?
Ring
Tree
Switch
Graph
Select the incorrect statement(s)
i) Foreign key values can be left blank
ii) In SQL duplicates may be present
iii) Theta join operation doesnt remove duplicate columns.
iv) NULL value means string of blank characters.
i ,iii only
ii, iv only
iii, iv only
ii, iii, iv
Symbol to represent weak entity set in ER Model
Dotted rectangle
Square
Doubly outlined rectangle
Diamond
Encoding method which does not provide for synchronization
B8ZS
Manchester
RZ
NRZ-L
In an object oriented model, one object can access data of another object by passing?
Instance variable
Variable
Message
Function
Usenet is also known as
Newsgroups
10Km to 1Km
10^3Km to 100Km
100M to 10M
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above
Benefit of database normalization is
smaller number of tables
higher query processing efficiency
reduced I/O for most queries
reduced data redundancy