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.
Correct Answer :
A. the begin transaction and end transaction
Related Questions
Which of the following file organization provides very fast access to any arbitrary record of a file?
Ordered file
Unordered file
Hashed file
B-tree
A transaction which completes successfully is called
Granted
Committed
Compensated
Accomplished
In E-R diagram Generalization is represented by
Circle
Rectangle
Hyperbola
Triangle
A subschema expresses
the logical view.
the physical view.
the external view.
all of the above.
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 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.
…………… is responsible for using that the database remains in a consistent state despite system failure.
Storage manager
Admin
Transaction manager
none of the above
File organization that provides fast access to any arbitrary record
Hashed file
B-tree
Ordered file
Unordered file
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above
Triggers are also called
active rules
passive rules
inferences
none of the above
Data Manipulation Language DML) is not to
Create information table in the Database
Insertion of new information into the Database
Deletion of information in the Database
Modification of information in the Database
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
Database locking concept is used to solve the problem of
Lost Update
Uncommitted Dependency
Inconsistent Data
All of the above
The exists construct returns the value true, if the argument subquery is
empty
nonempty
contains null values
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
Log into a computer across an internet
IMAP
TELNET
POP3
Infrared
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
What does the number of attributes in a relation is called?
Cardinality
Degree
Tuple
Order
In the architecture of a database system external level is the
physical level.
logical level.
conceptual level
view level.
Every Boyce-Codd normal form is in
3NF
2NF
1NF
none of the above
Related fields in a database are grouped to form a
data file.
data record.
menu.
bank.
View never contains derived columns.
True
False
Cant say
none
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 syntax to select all column from the table is
select all from tablename
select * from tablename
select from tablename
none of these
B-Tree is used for
searching data
storing data
both A and B
none of these
A table that displays data redundancies yields ____________ anomalies
Insertion
Deletion
Update
All of the above
The physical path over which a message travels
Thermal
Medium
Protocol
Impulse
Which topology requires a central controller or hub?
Ring
Tree
Switch
Graph
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
Expand the acronym OLAP
Object Linked Access Program
Organizational Architecture Processing
Online Analytical Processing
none of these