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
Correct Answer :
D. iii and iv only
Related Questions
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.
In two-phase locking
the data items are locked in growing phase.
the data items are released in shrinking phase.
Both A and B are true
Both A and B are false
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
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.
A table that displays data redundancies yields ____________ anomalies
Insertion
Deletion
Update
All of the above
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
Which of the following operator preserves unmatched rows of the relations being joined?
Inner join
Outer join
union
Intersect
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.
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
Commit operation …………… writes the changes made to the database.
temporarily
permanently
none of these
all of the above
In case of entity integrity, the primary key may be
not Null
Null
both Null & not Null.
any value.
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
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)
For large networks, _______ topology is used
Ring
Bus
Mesh
none of these
The degree of the table with 500 rows and 7 columns is
500
7
3500
none of these
An entity set which have sufficient attributes to form a primary key
Tree structure
Subtree structure
Strong entity set
Table structure
The host part in a class A type of an IP address has
12 bits
16 bits
24 bits
28 bits
The overall design of a database is called
Subschema of the database
Schema of the database
Structure of the database
View of the database
Benefit of database normalization is
smaller number of tables
higher query processing efficiency
reduced I/O for most queries
reduced data redundancy
Noiseless channel has ……… types of protocols.
2
3
4
5
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
A ………… clause permits a view definition to be used in multiple places within a query.
where
exist
with
select
Which of the following extracts its data from the result of an SQL SELECT statement.
View
Synonym
Sequence
Transaction
Data stored in cursor is called ……………
record
active data set
object
none of the above
The mode in which data item may be locked
Partner
Mutual
Exclusive
Atomic
In an E-R diagram attributes are represented by
rectangle.
square.
ellipse.
triangle.
The union of primary keys of a related entity becomes …………. Of a relation.
primarykey
superkey
candidatekey
foreignkey
Select the incorrect statement
BCNF is stronger than 3NF
Relational algebra is a non-procedural language
Every conflict serializable schedule is view serializable.
none of the above
Functional dependencies are generalization of
Relation dependencies
Data dependencies
key dependencies
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