Cascading rollback is avoided in all protocol except
strict two-phase locking protocol.
tree locking protocol
two-phase locking protocol
validation based protocol.
Correct Answer :
D. validation based protocol.
Related Questions
In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect :
Operationally, if Y is deleted, so is X
existence is dependent on Y.
Operationally, if X is deleted, so is Y.
Operationally, if X is deleted, & remains the same.
Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
Functional dependency
Multi-valued dependency
Transitive dependency
Partial dependency
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
A _____ is used to define overall design of the database
code
data definition language
application program
schema
Which of the following statement on the view concept in SQL is invalid?
All views are not updateable
The views may be referenced in an SQL statement whenever tables are referenced.
The views are instantiated at the time they are referenced and not when they are defined.
The definition of a view should not have GROUP BY clause in it.
Tree structures are used to store data in
Network model.
Relational model.
Hierarchical model.
File based system.
Relations produced from an E-R model will always be
First normal form.
Second normal form.
Third normal form.
Fourth normal form.
The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in tables that already exist.
Data Manipulation
Data Definition
Data Control
None
Cascading rollback is avoided in all protocol except
strict two-phase locking protocol.
tree locking protocol
two-phase locking protocol
validation based protocol.
The middleware databases in which the business rules act are applicable to _______ tier architectures
Single
Three
Two
None
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
According to the levels of abstraction, the schema at the intermediate level is called
Logical schema.
Physical schema.
Subschema.
None of the above.
DBMS helps achieve
Centralized control of data
Data independence
Both A and B
Neither A nor B
Processed data is called _____
Raw data
Source
Information
Useful data
_____ First proposed the process of normalization.
Edgar. W
Edward Stephen
Edgar F. Codd
Edward Codd
______contains information that defines valid values that are stored in a column or data type.
Default
Index
Rule
View
Which one is true statement :
With finer degree of granularity of locking a high degree of concurrency is possible.
Locking prevents non-serializable schedules.
Locking cannot take place at field level.
An exclusive lock on data item X is granted even if a shared lock is already held on X.
The data models defined by ANSI/SPARC architecture are
Conceptual, physical and internal
Conceptual, view and external
Logical, physical and internal
Logical, physical and view
SQL server stores index information in the _____system table
system indexes
syst indexes
sys indexes
sysind
The collection of information stored in a database at a particular moment is called as ......
schema
instance of the database
data domain
independence
Which is the best file organization when data is frequently added or deleted from a file?
Sequential
Direct
Index sequential
None of the above
Key to represent relationship between tables is called
primary key
secondary key
foreign key
none of the above
In an E-R diagram double lines indicate
Total participation.
Multiple participation.
Cardinality N.
None of the above.
The concept of mapping of ______ entity types is the concept in which the for each strong entity type E in the ER schema, create a relation R that includes all the simple attributes of E.
Regular
Irregular
None
Weak
In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
Oval; An oval with an underlined attribute
Circle; A circle with bolded attribute inside it
Diamond; A bolded attribute
Square; An attribute within the square
An advantage of the database management approach is
data redundancy increases
data is dependent on programs
data is integrated and can be accessed by multiple programs
none of the above
A relational database developer refers to a record as
an attribute
a tuple
a criteria
a relation
Which of the following is not a recovery technique?
Deferred update
Immediate update
Two-phase commit
Shadow paging
Employees in a company are each assigned their own office, i.e. for each employee there exists a unique office and for each office there exists a unique employee; This statement is an example of ____ type of relation.
1:1
1: Many
Many: One
Many : Many
_____is a full form of SQL.
Standard query language
Sequential query language
Structured query language
Server side query language