Shadow paging has
no redo
no undo
redo but no undo
neither redo nor undo
Correct Answer :
A. no redo
Related Questions
An advantage of views is
Data security
Derived columns
Hiding of complex queries
All of the above
The normal form that is not necessarily dependency preserving is
2NF
3NF
BCNF
4NF
Which of the following is true for network structure?
It is a physical representation of the data.
It allows many to many relationship.
It is conceptually simple.
It will be the dominant database of the future.
A ______ module is typically designed so that it will run on a user workstation or personal computer.
Software
Server
Program
Client
According to the levels of abstraction, the schema at the intermediate level is called
Logical schema.
Physical schema.
Subschema.
None of the above.
The cost of reading and writing temporary files while evaluating a query can be reduced by
building indices
pipelining
join ordering
none of the above
Which of the following is not a logical database structure?
Chain
Network
Tree
Relational
Relational Algebra does not have
Selection operator.
Projection operator.
Aggregation operators.
Division operator.
In an E-R diagram double lines indicate
Total participation.
Multiple participation.
Cardinality N.
None of the above.
______ keyword is used to find the number of values in a column.
TOTAL
ADD
COUNT
SUM
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
_____ command can be used to modify a column in a table
alter
update
set
create
Dependency preservation is not guaranteed in
BCNF
3NF
PJNF
DKNF
Which of the following is not comparison operator?
<>
<
=<
>=
As per equivalence rules for query transformation, selection operation distributes over
Union.
Set difference.
Intersection.
All of the above.
Wait-for graph is used for
detecting view serializability.
detecting conflict serializability.
deadlock prevention
deadlock detection
The collection of information stored in a database at a particular moment is called as ......
schema
instance of the database
data domain
independence
The full form of GUI is _________
Government Union Internet
Graphical Unit Interface
Graphical User Interface
Graphical University Interface
The set of all values that can be taken by the attribute is called as _______ of the attribute.
Tuple
Cardinality
Degree
Domain
Processed data is called _____
Raw data
Source
Information
Useful data
Given the following relation S(SNO,SNAME,CITY) write a query to update the value of CITY to KANPUR for the supplier S1.
UPDATE S CITY = KANPUR WHERE SNO=S1
UPDATE S SET CITY = KANPUR FOR SNO=S1
UPDATE S SET CITY = KANPUR WHERE SNO=S1
UPDATE S RENAME CITY = KANPUR WHERE SNO=S1
What is a disjoint less constraint?
It requires that an entity belongs to no more than one level entity set.
The same entity may belong to more than one level.
The database must contain an unmatched foreign key value.
An entity can be joined with another entity in the same level entity set.
Which of the following is not a recovery technique?
Deferred update
Immediate update
Two-phase commit
Shadow paging
In SQL the word natural can be used with
inner join
full outer join
right outer join
all of the above
The fact that information in the data warehouse changes far less often and may be regarded as non-real-time with periodic updating; This implies that data warehouses are _______
Volatile
Non - Volatile
Logical
Physical
The keyword to eliminate duplicate rows from the query result in SQL is
DISTINCT
NO DUPLICATE
UNIQUE
None of the above
Which of the following is not a consequence of concurrent operations?
Lost update problem.
Update anomaly.
Unrepeatable read.
Dirty read.
The middleware databases in which the business rules act are applicable to _______ tier architectures
Single
Three
Two
None
Which one is correct statement?
Logical data independence provides following without changing application programs:
(i) Changes in access methods.
(ii) Adding new entities in database
(iii) Splitting an existing record into two or more records
(iv) C
(i) and (ii)
(iv) only
(i) and (iv)
(ii) and (iii)
Manager salary details are hidden from the employee .This is
Conceptual level data hiding.
External level data hiding.
Physical level data hiding.
None of these.