Which of the following is not a property of transactions?
Atomicity
Concurrency
Isolation
Durability
Correct Answer :
B. Concurrency
Related Questions
Wait-for graph is used for
detecting view serializability.
detecting conflict serializability.
deadlock prevention
deadlock detection
What are the desirable properties of a decomposition
Partition constraint.
Dependency preservation.
Redundancy.
Security.
In 2NF
No functional dependencies (FDs) exist.
No multivalued dependencies (MVDs) exist.
No partial FDs exist.
No partial MVDs exist.
In b-tree the number of keys in each node is than the number of its children.
one less
same
one more
half
A relational database developer refers to a record as
an attribute
a tuple
a criteria
a relation
Which of the following concurrency control schemes is not based on the serializability property?
Two - phase locking
Graph-based locking
Time-stamp based locking
None of these .
Which of the following is not a consequence of non-normalized database?
Update Anomaly
Insertion Anomaly
Redundancy
Lost update problem
operator is used to compare a value to a list of literals values that have been specified.
Like
COMPARE
BETWEEN
IN
Relational Algebra does not have
Selection operator.
Projection operator.
Aggregation operators.
Division operator.
For using a specific database …………… command is used.
use database
database name use
Both A & B
None of them
Grant and revoke are _____ statements.
TCL
DCL
DDL
DML
Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum and minimum size of the join respectively are
m+n and 0
m+n and |m-n|
mn and 0
mn and m+n
An outstanding functionality of SQL is its support for automatic_____ to the target data.
programming
navigation
functioning
notification
______is a special type of integrity constraint that relates two relations & maintains consistency across the relations.
Domain Integrity Constraints
Referential Integrity Constraints
Domain Constraints
Entity Integrity Constraints
A list consists of last names, first names, addresses and pin codes. If all people in the list have the same last name and same pin code a useful key would be
the pin code
the last name
the compound key first name and last name
Tr from next page
The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify a given tuple.
Primary
Foreign
Candidate
Alternate
______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
Instance
Program
Schema
Super Key
Precedence graphs help to find a
Serializable schedule.
Recoverable schedule.
Deadlock free schedule.
Cascadeless schedule.
What is data integrity?
It is the data contained in database that is non redundant.
It is the data contained in database that is accurate and consistent.
It is the data contained in database that is secured.
It is the data contained in database that is shared.
Checkpoints are a part of
Recovery measures.
Security measures.
Concurrency measures.
uthorization measures.
A _____ is used to define overall design of the database
code
data definition language
application program
schema
Isolation of the transactions is ensured by
Transaction management
Application programmer
Concurrency control
Recovery management
____ table store information about database or about the system.
SQL
System
Nested
None of these
Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common because it is non volatile.
RAM
Flash
Hard Disk
Secondary
The _______ is a set of programs to use and / or modify this data.
DBMS
System
Program
Software
In a relational schema, each tuple is divided into fields called
Relations
Queries
Domains
All of the above
If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
left outer join
right outer join
full outer join
inner join
If both the functional dependencies : X�Y and Y�X hold for two attributes X and Y then the relationship between X and Y is
M:N
M:1
1:M
What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are Base union compatible and all the rows of a are common to B? Assume A has 4 columns and 10 rows; and B has 4 columns and 15 rows
4,0
0,0
4,5
8,5
DBMS is a collection of _____ that enables user to create and maintain a database.
Keys
Program
Translators
Language Activity