Technique used in log based recovery
Immediate database modification
Graph-based recovery
key dependencies
none of the above
Correct Answer :
A. Immediate database modification
Related Questions
In defining the notion of the tuple variable, which one of the clause is useful?
as
by
from
none of the above
The transaction consists of all statements executed between
the begin transaction and end transaction
the start transaction and end transaction
the begin transaction and finish transaction
none of the above.
In client/server computing data are
sent only upon the client's request
sent in complete copies for the client to filter and sort
never sent to the client machine
sent in very large sections to save processing time
What does the number of attributes in a relation is called?
Cardinality
Degree
Tuple
Order
Database locking concept is used to solve the problem of
Lost Update
Uncommitted Dependency
Inconsistent Data
All of the above
Datalog is
procedural query language
nonprocedural query language
scan(), write()
none of the above
In RDBMS, Data is presented as a collection of
Relation
Table
Attribute
Entity
Primary storage
magnetic disk
magnetic tape
juke box
cache
An entity set that does not have sufficient attributes to form a primary key is a
strong entity set.
weak entity set.
simple entity set.
primary entity set.
What is the max data capacity of STP?
1 Gbps
56 Mbps
100 Mbps
256 Mbps
Transaction access data using two operations
read(), print()
read(), write()
scan(), write()
none of the above
Extended Entity Relationship model consists of which of the following
i) Specialization
ii) Generalization
iii) Categorization
i and ii only
ii and iii only
i and iii only
All i, ii iii
A lock that allows concurrent transactions to access different rows of the same table is known as a
Field-level lock
Row-level lock
Table-level lock
Database-level lock
Every Boyce-Codd normal form is in
3NF
2NF
1NF
none of the above
Commit operation …………… writes the changes made to the database.
temporarily
permanently
none of these
all of the above
Which of the following is a classical approach to database design?
Left Right approach
Right Left approach
Top Down approach
Bottom Up approach
Expand the acronym OLAP
Object Linked Access Program
Organizational Architecture Processing
Online Analytical Processing
none of these
FDDI protocol operates in
i) Transport layer
ii) Network layer
iii) Datalink layer
iv) Physical layer
i and ii only
ii and iii only
i and iii only
iii and iv only
The physical path over which a message travels
Thermal
Medium
Protocol
Impulse
A functional dependency between two or more non-key attributes is called
Transitive dependency
Partial transitive dependency
Functional dependency
Partial functional dependency
Tape storage is referred to as
sequential access storage
direct access storage
random access storage
none of the above
The privilege lists include
i) select
ii) insert
iii) update
iv) delete
only i)
only i) ii)
only i) ii) iii)
i) ii) iii) iv)
Count function in SQL returns the number of
values.
distinct values.
groups.
columns.
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).
Which of the following are the properties of entities?
Groups
Table
Attributes
Switchboards
In this data model each record can hae more than one parent
Hierarchical model
E-R model
Network based model
none of these
In ………… paging we make copy of the current page table.
physical
logical
shadow
duplicate
Related fields in a database are grouped to form a
data file.
data record.
menu.
bank.
An advantage of the database management approach is
data is dependent on programs.
data redundancy increases.
data is integrated and can be accessed by multiple programs.
none of the above.
In an Entity-Relationship Diagram Ellipses represents
Attributes
Weak entity set
Relationship sets
Multi-valued attributes