The mode in which data item may be locked
Partner
Mutual
Exclusive
Atomic
Correct Answer :
C. Exclusive
Related Questions
Unwanted energy from source other than the transmitter.
Attenuation
Distortion
Delay
Noise
Select the correct statement
i) Aggregate functions work on a group of data and return a single value.
ii) ODBC connects the frontend with the database without considering its compatibility
iii) View definition cant be used at multiple places through with clause .
i and ii only
ii and iii only
i and iii only
i only
The class based addressing is known as
Classless addressing
Classful addressing
Classified addressing
Classical addressing
Database locking concept is used to solve the problem of
Lost Update
Uncommitted Dependency
Inconsistent Data
All of the above
The access protocol used by traditional Ethernet
CSMA/CA
CSMA/CD
CSMA
Token ring
A fragmentation is categorized in
1 part
2 part
3 part
4 part
Volatile storage
loses its contents when power is switched off.
doesnt loses its contents when power is switched off.
creates backup when power is switched off.
none
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
Which of the following is not a database object?
index
sequence
cursor
trigger
The mode in which data item may be locked
Partner
Mutual
Exclusive
Atomic
When all attributes in a relation tuple are not functionally dependent only on the key attribute. Which of the following normalization is needed?
first
second
third
fourth
Extended Entity Relationship model consists of which of the following
i) Specialization
ii) Generalization
iii) Categorization
i and ii only
ii and iii only
i and iii only
All i, ii iii
Usenet is also known as
Newsgroups
10Km to 1Km
10^3Km to 100Km
100M to 10M
Size of source and destination address in IP header
4 bits
8 bits
12 bits
32 bits
.................. occurs due to velocity of propagation the frequency varies. Thus various frequency components of a signal arrive at the receiver at different times.
Noise
Delay distortion
Attenuation distortion
Dispersion
The control of concurrent execution is left with the
operating system
controller unit of the kernel
concurrency control component of the database system
none
If the .................... is too much, the receiver may not be able to detect the signal at all or the signal may fall below the noise level.
Noise
Delay
Dispersion
Attenuation
Cross Product is a:
Unary Operator
Binary Operator
Ternary Operator
none of the above
Three SQL, DDL, CREATE commands are
Schema, Base and Table
Schema, Table and View
Base, Table and Schema
Key, Base and Table
Which of the following is logical topology?
Bus
Ring
Star
None of these
Object based data models are used in describing the abstraction of the following levels?
Conceptual and view
Only physical
Physical and conceptual
Only conceptual
Transaction access data using two operations
read(), print()
read(), write()
scan(), write()
none of the above
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
Which of the following Key is used to represent relationship between the tables?
Primary key
Secondary Key
Foreign Key
None of these
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above
A DBMS query language is designed to
support end users who use English-like commands.
support in the development of complex applications software.
specify the structure of a database.
all of the above.
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
View never contains derived columns.
True
False
Cant say
none
What is ACID properties of Transactions?
Atomicity, Consistency, Isolation, Database
Atomicity, Consistency, Isolation, Durability
Atomicity, Consistency, Inconsistent, Durability
Automatically, Concurrency, Isolation, Durability