The control of concurrent execution is left with the
operating system
controller unit of the kernel
concurrency control component of the database system
none
Correct Answer :
C. concurrency control component of the database system
Related Questions
A table that displays data redundancies yields ____________ anomalies
Insertion
Deletion
Update
All of the above
An association of several structure of a data base can be expressed graphically by?
Tuple
Record
Relationship
Field
In client/server computing data are
sent only upon the client's request
sent in complete copies for the client to filter and sort
never sent to the client machine
sent in very large sections to save processing time
Which of the following is true statement ?
SQL permits attribute names to be repeated in the same relation.
a SQL query automatically eliminates duplicates.
a SQL query will not work if there are no indexes on the relations
None of these
Range variables are designed using the
TO clause
FROM clause
RANGE clause
none of the above
Which of the following is not proper state of transaction ?
Partially aborted
Partially committed
Aborted
Committed
In an object oriented model, one object can access data of another object by passing?
Instance variable
Variable
Message
Function
In case of entity integrity, the primary key may be
not Null
Null
both Null & not Null.
any value.
Which of the following normalization is needed, if an attribute of a composite key is dependent on an attribute of the other composite key?
BCNF
Second
Third
Fourth
Which of the following is the unit of signaling speed or modulation rate or the rate of symbol transmission?
Data rate
Bit rate
Signal to Noise Ratio
Baud rate
The raw facts and figures are:
Data
Data field
DBMS
DBASE
A transaction which completes successfully is called
Granted
Committed
Compensated
Accomplished
Which topology requires a central controller or hub?
Ring
Tree
Switch
Graph
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.
The method of access which uses key transformation is known as
direct.
hash.
random.
sequential.
Size of source and destination address in IP header
4 bits
8 bits
12 bits
32 bits
Commit operation …………… writes the changes made to the database.
temporarily
permanently
none of these
all of the above
Noiseless channel has ……… types of protocols.
2
3
4
5
The collection of information stored in a database at a particular moment is?
View
Instance
Scheme
None of these
The left outer join takes all tuples
in the left relation which didnt match with any tuple in right relation
in the left relation which matched with a tuple in right relation
in the right relation which didnt match with any tuple in left relation
in the right relation which matched with a tuple in left relation
FDDI protocol operates in
i) Transport layer
ii) Network layer
iii) Datalink layer
iv) Physical layer
i and ii only
ii and iii only
i and iii only
iii and iv only
Which of the following is not a constraint on a single relation?
check
unique
not null
is duplicate
Which of the following is not an Aggregate function?
Min
Max
Select
Avg
In defining the notion of the tuple variable, which one of the clause is useful?
as
by
from
none of the above
View never contains derived columns.
True
False
Cant say
none
A fragmentation is categorized in
1 part
2 part
3 part
4 part
Every Boyce-Codd normal form is in
3NF
2NF
1NF
none of the above
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above
Relational Algebra is
Data Definition Language.
Data Manipulation Language
Procedural query Language
None of the above
In which of the following SET concept is used ?
Network Model
Hierarchical Model
Relational Model
None of these