Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
It will result in a deadlock situation.
It will immediately be rejected.
It will immediately be granted.
It will be granted as soon as it is released by A .
Correct Answer :
C. It will immediately be granted.
Related Questions
According to the levels of abstraction, the schema at the intermediate level is called
Logical schema.
Physical schema.
Subschema.
None of the above.
A relational database developer refers to a record as
an attribute
a tuple
a criteria
a relation
A transaction is in state after the final statement has been executed.
partially committed
active
committed
none of the above
The rule that a value of a foreign key must appear as a value of some specific table is called a
Referential constraint.
Index.
Integrity constraint.
Functional dependency.
Which of the following ensures the atomicity of the transaction?
Transaction management component of DBMS
Application Programmer
Concurrency control component of DBMS
Recovery management component of DBMS
In 2NF
No functional dependencies (FDs) exist.
No multivalued dependencies (MVDs) exist.
No partial FDs exist.
No partial MVDs exist.
Which of the syntax is correct for insert statement?
i) insert into values
ii) insert into (column list) values
ii) insert into
i-only
ii-only
Both of them
None of them
………………… approach reduces time and effort required for design and lesser risk in database management.
Single global database
Multiple databases
Top-down approach
None of the above
A _____ is a logical unit of database processing that includes one or more data access operations that can include insertion, deletion, modification or retrieval operations.
Database
Data
Transaction
Record
The default level of consistency in SQL is
repeatable read
read committed
read uncommitted
serializable
By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0) or one (1).
Vulcanizing
Galvanizing
Magnetizing
Passing UV rays
_______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal Server an ORDBMS.
Star
llustar
SQL
Cygnus
Which normal form is considered adequate for normal relational database design?
2NF
5NF
4NF
3NF
Isolation of the transactions is ensured by
Transaction management
Application programmer
Concurrency control
Recovery management
The values of the attribute describes a particular
Entity set
File
Entity instance
Organization
operator is used to compare a value to a list of literals values that have been specified.
Like
COMPARE
BETWEEN
IN
It is an abstraction through which relationships are treated as higher level entities
Generalization.
Specialization.
Aggregation.
Inheritance.
Which of the following is not a recovery technique?
Deferred update
Immediate update
Two-phase commit
Shadow paging
Data independence means
data is defined separately and not included in programs.
programs are not dependent on the physical attributes of data
programs are not dependent on the logical attributes of data
both B and C
Relational Algebra does not have
Selection operator.
Projection operator.
Aggregation operators.
Division operator.
When an E-R diagram is mapped to tables, the representation is redundant for
weak entity sets
weak relationship sets
strong entity sets
strong relationship sets
An advantage of views is
Data security
Derived columns
Hiding of complex queries
All of the above
Drop Table cannot be used to drop a table referenced by a ______ constraint.
Primary Key
Local Key
Foreign Key
Composite Key
The drawback of shadow paging technique are
Commit overhead
Data fragmentation
Garbage collection
All of these
SQL server stores index information in the _____system table
system indexes
syst indexes
sys indexes
sysind
______is a preferred method for enforcing data integrity
Constraints
Triggers
Stored procedure
Cursors
The clause alter table in SQL can be used to
add an attribute
delete an attribute
alter the default values of an attribute
all of the above
____ table store information about database or about the system.
SQL
System
Nested
None of these
______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
Which of the following constitutes a basic set of operations for manipulating relational data?
Predicate calculus
Relational calculus
Relational algebra
SQL