What is ACID properties of Transactions?
Atomicity, Consistency, Isolation, Database
Atomicity, Consistency, Isolation, Durability
Atomicity, Consistency, Inconsistent, Durability
Automatically, Concurrency, Isolation, Durability
Correct Answer :
B. Atomicity, Consistency, Isolation, Durability
Related Questions
In E-R Diagram weak entity set are represented by
Ellipse
Dashed ellipse
Dashed Rectangle
Doubled Rectangle
The overall design of a database is called
Subschema of the database
Schema of the database
Structure of the database
View of the database
Electromagnetic spectrum included in radiowaves are
i) Super High Frequency (SHF)
ii) Very High Frequency (VHF)
iii) Ultra High Frequency (UHF)
iv) High Frequencies (HF)
i, ii and iii only
i, ii and iv only
ii, iii and iv only
i, iii and iv only
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
A logical schema
is the entire database.
is a standard way of organizing information into accessible parts.
describes how data is actually stored on disk.
both A) and C)
The index table has …… Columns.
1
2
3
4
A …………… is a memory area where data are processed.
view
trigger
cursor
none of the above
Expand the acronym OLAP
Object Linked Access Program
Organizational Architecture Processing
Online Analytical Processing
none of these
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above
Select the incorrect statement(s)
i) Shared locks are compatible with each other.
ii) A relation which is in 3NF may have redundancy due to composite keys.
iii) A table in a database can have multiple indexes.
i only
ii, only
ii, iii only
none of the above
Secondary storage
magnetic disk
magnetic tape
juke box
cache
An entity set which have sufficient attributes to form a primary key
Tree structure
Subtree structure
Strong entity set
Table structure
QBE
Query By Execution
Query By Example
Query By Extraction
None of the above.
Event condition action model is related to
Views
Cursors
Triggers
None of these.
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
Aggregate functions are also called
serial functions
non-serial functions
row functions
column functions
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
.................. 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
Triggers are also called
active rules
passive rules
inferences
none of the above
Generalization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above
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
The exists construct returns the value true, if the argument subquery is
empty
nonempty
contains null values
none of the above
A logical description of some portion of database that is required by a user to perform task is called as
System View
User View
Logical View
Data View
In an object oriented model, one object can access data of another object by passing?
Instance variable
Variable
Message
Function
Benefit of database normalization is
smaller number of tables
higher query processing efficiency
reduced I/O for most queries
reduced data redundancy
The mode in which data item may be locked
Partner
Mutual
Exclusive
Atomic
A fragmentation is categorized in
1 part
2 part
3 part
4 part
The control of concurrent execution is left with the
operating system
controller unit of the kernel
concurrency control component of the database system
none
An advantage of the database management approach is
data is dependent on programs.
data redundancy increases.
data is integrated and can be accessed by multiple programs.
none of the above.
Transaction access data using two operations
read(), print()
read(), write()
scan(), write()
none of the above