Technique(s) used for data recovery after any failure
Logging
Recovery manager
Both A and B are true
Both A and B are false
Correct Answer :
C. Both A and B are true
Related Questions
Which of the following is a classical approach to database design?
Left Right approach
Right Left approach
Top Down approach
Bottom Up approach
The minimal set of super key is called
Primary key
Secondary key
Candidate key
Foreign key
Technique(s) used for data recovery after any failure
Logging
Recovery manager
Both A and B are true
Both A and B are false
Related fields in a database are grouped to form a
data file.
data record.
menu.
bank.
The collection of information stored in a database at a particular moment is?
View
Instance
Scheme
None of these
Which of the following aggregate function doesnt ignore NULLs in its results?
COUNT
COUNT(*)
MAX
none of these
The mode in which data item may be locked
Partner
Mutual
Exclusive
Atomic
Which of the following is the unit of signaling speed or modulation rate or the rate of symbol transmission?
Data rate
Bit rate
Signal to Noise Ratio
Baud rate
Count function in SQL returns the number of
values.
distinct values.
groups.
columns.
What are the different types of radio waves that are used for computer network applications?
i) Spread spectrum
ii) High power, single frequency
iii) High power, multiple frequency
iv) Low power, single frequency
v) Low power, multiple frequency
i, ii and iii only
i, ii and iv only
ii, iii and iv only
i, iii and iv only
A relation which is in 3NF is
in 1NF also
in 2NF also
free from transitive dependencies
All of these
Range variables are designed using the
TO clause
FROM clause
RANGE clause
none of the above
Expand the acronym OLAP
Object Linked Access Program
Organizational Architecture Processing
Online Analytical Processing
none of these
What is the max data capacity of STP?
1 Gbps
56 Mbps
100 Mbps
256 Mbps
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
Which of the following layer uses trailer of the frame for error detection?
Transport layer
Network layer
Datalink layer
None of these
Which of the following is logical topology?
Bus
Ring
Star
None of these
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
Select the correct
i) A timestamp-based scheduler cant produce live lock
ii) Aggregate functions cant appear with HAVING clause.
iii) Isolation is a property of database transaction.
i and ii only
ii and iii only
i and iii only
i only
In an E-R diagram attributes are represented by
rectangle.
square.
ellipse.
triangle.
A …………… is a memory area where data are processed.
view
trigger
cursor
none of the above
Primary storage
magnetic disk
magnetic tape
juke box
cache
Data fragmentation is performed by the …… and each fragment is stored at…………..
DBMS, same site
OS ,same site
DBMS ,different site
OS ,different site
Which topology requires a central controller or hub?
Ring
Tree
Switch
Graph
UML is stands for
Universal Modeling Language
Unified Modeling Language
United Modeling Language
Uni Modeling Language
............... noise is caused by the random motion of the electrons in a wire and is avoidable.
Thermal
Intermodulation
Cross talk
Impulse
Cross Product is a:
Unary Operator
Binary Operator
Ternary Operator
none of the above
Which of the following produces the relation that has attributes of R1 and R2
Cartesian product
Difference
Intersection
Product
Which of the following operator preserves unmatched rows of the relations being joined?
Inner join
Outer join
union
Intersect
Tertiary storage
magnetic tape
juke box
optical disk
All of the above