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
Correct Answer :
A. growing phase and shrinking phase
Related Questions
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
The collection of information stored in a database at a particular moment is?
View
Instance
Scheme
None of these
A subschema expresses
the logical view.
the physical view.
the external view.
all of the above.
Usenet is also known as
Newsgroups
10Km to 1Km
10^3Km to 100Km
100M to 10M
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.
In an object oriented model, one object can access data of another object by passing?
Instance variable
Variable
Message
Function
Every Boyce-Codd normal form is in
3NF
2NF
1NF
none of the above
.................. 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 produces the relation that has attributes of R1 and R2
Cartesian product
Difference
Intersection
Product
Which of the following aggregate function doesnt ignore NULLs in its results?
COUNT
COUNT(*)
MAX
none of these
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
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
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
Datalog is
procedural query language
nonprocedural query language
scan(), write()
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
In which of the random-access method, stations do not sense the medium?
ALOHA
ETHERNET
CSMA/CA
CSMA/CD
A transaction which may not complete its execution successfully is termed as
Failed
Aborted
Blocked
Finished
DBMS helps achieve
Data independence
Centralized control of data
Neither A) nor B)
both A) and B)
In an Entity-Relationship Diagram Ellipses represents
Attributes
Weak entity set
Relationship sets
Multi-valued attributes
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
Radio frequencies below ............. are more suitable for omnidirectional applications.
300MHz
1GHz
5GHz
10 GHz
Functional dependencies are generalization of
Relation dependencies
Data dependencies
key dependencies
none of the above
Which of the following layer uses trailer of the frame for error detection?
Transport layer
Network layer
Datalink layer
None of these
Event condition action model is related to
Views
Cursors
Triggers
None of these.
A type of query that is placed within a WHERE or HAVING clause of another query is called
Super query
Sub query
Master query
Multi-query
which of the following is a binary operation?
project
select
rename
none of the above
What is the max data capacity of STP?
1 Gbps
56 Mbps
100 Mbps
256 Mbps
B-Tree is used for
searching data
storing data
both A and B
none of these
Encoding method which does not provide for synchronization
B8ZS
Manchester
RZ
NRZ-L
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