Which of the following is not a recovery technique?
Deferred update
Immediate update
Two-phase commit
Shadow paging
Correct Answer :
C. Two-phase commit
Related Questions
A _____ is used to define overall design of the database
code
data definition language
application program
schema
Which is the best file organization when data is frequently added or deleted from a file?
Sequential
Direct
Index sequential
None of the above
Cascading rollback is avoided in all protocol except
strict two-phase locking protocol.
tree locking protocol
two-phase locking protocol
validation based protocol.
The clause in SQL that specifies that the query result should be sorted in ascending or descending order based on the values of one or more columns is
View
Order by
Group by
Having
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
A data type or format is specified for each _________
Relation
Tuple
Database
Domain
A top-to-bottom relationship among the items in a database is established by a
Hierarchical schema
Network schema
Relational Schema
All of the above
Which of the following is a reason to model data?
Understand each user's perspective of data
Understand the data itself irrespective of the physical representation
Understand the use of data across application areas
All of the above
Which of the following addressing modes permits relocation without any change over in the code?
Indirect addressing
Indexed addressing
PC relative addressing
Base register addressing
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.
Processed data is called _____
Raw data
Source
Information
Useful data
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.
Union operator is a :
Unary Operator
Ternary Operator
Binary Operator
Not an operator
The normalization was first proposed by .
Code
Codd
Boyce Codd
Boyce
Which of the following is not a logical database structure?
Chain
Network
Tree
Relational
SQL server stores index information in the _____system table
system indexes
syst indexes
sys indexes
sysind
The values of the attribute describes a particular
Entity set
File
Entity instance
Organization
Tree structures are used to store data in
Network model.
Relational model.
Hierarchical model.
File based system.
If the closure of an attribute set is the entire relation then the attribute set is a
superkey
candidate key
primary key
not a key
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 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.
Dependency preservation is not guaranteed in
BCNF
3NF
PJNF
DKNF
Checkpoints are a part of
Recovery measures.
Security measures.
Concurrency measures.
uthorization measures.
In b-tree the number of keys in each node is than the number of its children.
one less
same
one more
half
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
The language that requires a user to specify the data to be retrieved without specifying exactly how to get it is
Procedural DML.
Non-Procedural DML.
Procedural DDL.
Non-Procedural DDL.
The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all conditions specified.
OR
AND
NOT
ALL
operator is used to compare a value to a list of literals values that have been specified.
Like
COMPARE
BETWEEN
IN
A logical schema
is the entire database
Describes how data is actually stored on disk.
is a standard way of organizing information into accessible parts.
All of the above
Protection of data from unauthorized Disclosure results in loss of _______
Integrity
Availability
Confidentiality
Discretionary Security