A transaction is said to have terminated if it has
either committed or aborted
either partially committed or aborted
either committed or failed
none of these
Correct Answer :
D. none of these
Related Questions
A data dictionary contains:
i) The name of all fields in all files.
ii) The data type of all fields in all files.
iii) The width of all fields in all files.
only i)
only i) and ii)
only ii) and iii)
i) ii) iii)
In the architecture of a database system external level is the
physical level.
logical level.
conceptual level
view level.
Tape storage is referred to as
sequential access storage
direct access storage
random access storage
none of the above
Event condition action model is related to
Views
Cursors
Triggers
None of these.
A transaction is said to have terminated if it has
either committed or aborted
either partially committed or aborted
either committed or failed
none of these
Natural mask for a Class A network
255.0.0.0
255.255.0.0
255.255.255.0
none of these
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
DBMS utility which allows to reconstruct the correct state of database from the backup and history of transactions
Backup
Recovery
Grant
Troubleshooting
.................. 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
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
A data manipulation command the combines the records from one or more tables is called
SELECT
PROJECT
JOIN
PRODUCT
Which of the following operator preserves unmatched rows of the relations being joined?
Inner join
Outer join
union
Intersect
Tertiary storage
magnetic tape
juke box
optical disk
All of the above
UML is stands for
Universal Modeling Language
Unified Modeling Language
United Modeling Language
Uni Modeling Language
Which of the following extracts its data from the result of an SQL SELECT statement.
View
Synonym
Sequence
Transaction
Encoding method which does not provide for synchronization
B8ZS
Manchester
RZ
NRZ-L
A ………… clause permits a view definition to be used in multiple places within a query.
where
exist
with
select
Which of the following is not a database object?
index
sequence
cursor
trigger
Technique used in log based recovery
Immediate database modification
Graph-based recovery
key dependencies
none of the above
In defining the notion of the tuple variable, which one of the clause is useful?
as
by
from
none of the above
The privilege lists include
i) select
ii) insert
iii) update
iv) delete
only i)
only i) ii)
only i) ii) iii)
i) ii) iii) iv)
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
Multivalued dependency is removed in
4 NF
3 NF
2 NF
1 NF
An association of several structure of a data base can be expressed graphically by?
Tuple
Record
Relationship
Field
In which of the following transmissions, we can send data by grouping n bits at a time instead of a single bit?
parallel
serial
analog
digital
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
An operation that will increase the length of a list is
insert
modify
lookup
none of the above
A lock that allows concurrent transactions to access different rows of the same table is known as a
Field-level lock
Row-level lock
Table-level lock
Database-level lock
The language used in application programs to request data from the DBMS is referred to as the
DML
DDL
VDL
SDL
Data stored in cursor is called ……………
record
active data set
object
none of the above