DBMS utility which allows to reconstruct the correct state of database from the backup and history of transactions

Question

DBMS utility which allows to reconstruct the correct state of database from the backup and history of transactions

A. Backup

B. Recovery

C. Grant

D. Troubleshooting

Share this question with your friends

Show all Advance DBMS MCQ

Comment

A transaction has following states
i) Active
ii) Fail
iii) Abort
iv) Commit

A. i and ii only

B. ii and iii only

C. i and iii only

D. iii and iv only

Discuss this answer

Select the incorrect statement

A. BCNF is stronger than 3NF

B. Relational algebra is a non-procedural language

C. Every conflict serializable schedule is view serializable.

D. none of the above

Discuss this answer

The method by which the structure of the database is modified to eliminate hidden dependencies and replacing groups is

A. Normalization

B. Indexing

C. Enforcing referential integrity

D. Enforcing data integrity

Discuss this answer

A relation that has no partial dependencies is in which normal form

A. First

B. Second

C. Third

D. BCNF

Discuss this answer

Range variables are designed using the

A. TO clause

B. FROM clause

C. RANGE clause

D. none of the above

Discuss this answer

Generalization is a

A. top-down approach.

B. bottom-up approach.

C. left-right approach.

D. none of the above

Discuss this answer

DBMS helps achieve

A. Data independence

B. Centralized control of data

C. Neither A) nor B)

D. both A) and B)

Discuss this answer

Unwanted energy from source other than the transmitter.

A. Attenuation

B. Distortion

C. Delay

D. Noise

Discuss this answer

A composite attribute is converted to individual attributes in which of the following normal form ?

A. first

B. Second

C. third

D. fourth

Discuss this answer

The physical location of a record is determined by a mathematical formula that transforms
a file key into a record location is :

A. B-Tree File

B. Hashed File

C. Indexed File

D. Sequential file.

Discuss this answer

UML is stands for

A. Universal Modeling Language

B. Unified Modeling Language

C. United Modeling Language

D. Uni Modeling Language

Discuss this answer

Size of source and destination address in IP header

A. 4 bits

B. 8 bits

C. 12 bits

D. 32 bits

Discuss this answer

An association of several structure of a data base can be expressed graphically by?

A. Tuple

B. Record

C. Relationship

D. Field

Discuss this answer

.................. occurs due to velocity of propagation the frequency varies. Thus various frequency components of a signal arrive at the receiver at different times.

A. Noise

B. Delay distortion

C. Attenuation distortion

D. Dispersion

Discuss this answer

Natural mask for a Class A network

A. 255.0.0.0

B. 255.255.0.0

C. 255.255.255.0

D. none of these

Discuss this answer

Which of the following produces the relation that has attributes of R1 and R2

A. Cartesian product

B. Difference

C. Intersection

D. Product

Discuss this answer

The ability to modify the conceptual schema without causing any change to the application program is known as

A. Physical data independence

B. Logical data independence

C. External data independence

D. Static data

Discuss this answer

Noisy channel has ……… .. types of protocols

A. two

B. three

C. four

D. none

Discuss this answer

Attenuation can be also expressed in decibel dB) and commonly used because.
i) Signal strengths often fall off logarithmically
ii) Cascade losses and gains can be calculated with simple additions and subtractions

A. i only

B. ii only

C. Both A and B

D. None of the above

Discuss this answer

Consider the join of a relation R with relation S. If R has m tuples and S has n tuples,
then the maximum size of join is:

A. mn

B. m+n

C. m+n)/2

D. 2 m+n)

Discuss this answer

The left outer join takes all tuples

A. in the left relation which didnt match with any tuple in right relation

B. in the left relation which matched with a tuple in right relation

C. in the right relation which didnt match with any tuple in left relation

D. in the right relation which matched with a tuple in left relation

Discuss this answer

The minimal set of super key is called

A. Primary key

B. Secondary key

C. Candidate key

D. Foreign key

Discuss this answer

Every Boyce-Codd normal form is in

A. 3NF

B. 2NF

C. 1NF

D. none of the above

Discuss this answer

Which of the following statement returns data to the host variables one at a time?

A. SELECT

B. RETURN

C. FETCH

D. GET

Discuss this answer

The maximum number of children in a B-tree of order m is

A. m+1

B. m

C. m-1

D. m/2

Discuss this answer

If the .................... is too much, the receiver may not be able to detect the signal at all or the signal may fall below the noise level.

A. Noise

B. Delay

C. Dispersion

D. Attenuation

Discuss this answer

Cross Product is a:

A. Unary Operator

B. Binary Operator

C. Ternary Operator

D. none of the above

Discuss this answer

What does a field or a combination of fields that has a unique value called ?

A. Foreign key

B. Secondary key

C. Primary key

D. Alternate key

Discuss this answer

The method of access which uses key transformation is known as

A. direct.

B. hash.

C. random.

D. sequential.

Discuss this answer

Extended Entity Relationship model consists of which of the following
i) Specialization
ii) Generalization
iii) Categorization

A. i and ii only

B. ii and iii only

C. i and iii only

D. All i, ii iii

Discuss this answer

Accepted Answer

B. Recovery

DBMS utility which allows to reconstruct the correct state of database from the backup and history of transactions

Correct Answer :

Show all Advance DBMS MCQ

Related Questions

A transaction has following states
i) Active
ii) Fail
iii) Abort
iv) Commit

Select the incorrect statement

The method by which the structure of the database is modified to eliminate hidden dependencies and replacing groups is

A relation that has no partial dependencies is in which normal form

Range variables are designed using the

Generalization is a

DBMS helps achieve

Unwanted energy from source other than the transmitter.

A composite attribute is converted to individual attributes in which of the following normal form ?

The physical location of a record is determined by a mathematical formula that transforms
a file key into a record location is :

UML is stands for

Size of source and destination address in IP header

An association of several structure of a data base can be expressed graphically by?

.................. occurs due to velocity of propagation the frequency varies. Thus various frequency components of a signal arrive at the receiver at different times.

Natural mask for a Class A network

Which of the following produces the relation that has attributes of R1 and R2

The ability to modify the conceptual schema without causing any change to the application program is known as

Noisy channel has ……… .. types of protocols

Attenuation can be also expressed in decibel dB) and commonly used because.
i) Signal strengths often fall off logarithmically
ii) Cascade losses and gains can be calculated with simple additions and subtractions

Consider the join of a relation R with relation S. If R has m tuples and S has n tuples,
then the maximum size of join is:

The left outer join takes all tuples

The minimal set of super key is called

Every Boyce-Codd normal form is in

Which of the following statement returns data to the host variables one at a time?

The maximum number of children in a B-tree of order m is

If the .................... is too much, the receiver may not be able to detect the signal at all or the signal may fall below the noise level.

Cross Product is a:

What does a field or a combination of fields that has a unique value called ?

The method of access which uses key transformation is known as

Extended Entity Relationship model consists of which of the following
i) Specialization
ii) Generalization
iii) Categorization

Also checkout

DBMS utility which allows to reconstruct the correct state of database from the backup and history of transactions

Correct Answer :

Show all Advance DBMS MCQ

Related Questions

A transaction has following statesi) Activeii) Failiii) Abortiv) Commit

Select the incorrect statement

The method by which the structure of the database is modified to eliminate hidden dependencies and replacing groups is

A relation that has no partial dependencies is in which normal form

Range variables are designed using the

Generalization is a

DBMS helps achieve

Unwanted energy from source other than the transmitter.

A composite attribute is converted to individual attributes in which of the following normal form ?

The physical location of a record is determined by a mathematical formula that transformsa file key into a record location is :

UML is stands for

Size of source and destination address in IP header

An association of several structure of a data base can be expressed graphically by?

.................. occurs due to velocity of propagation the frequency varies. Thus various frequency components of a signal arrive at the receiver at different times.

Natural mask for a Class A network

Which of the following produces the relation that has attributes of R1 and R2

The ability to modify the conceptual schema without causing any change to the application program is known as

Noisy channel has ……… .. types of protocols

Attenuation can be also expressed in decibel dB) and commonly used because.i) Signal strengths often fall off logarithmicallyii) Cascade losses and gains can be calculated with simple additions and subtractions

Consider the join of a relation R with relation S. If R has m tuples and S has n tuples,then the maximum size of join is:

The left outer join takes all tuples

The minimal set of super key is called

Every Boyce-Codd normal form is in

Which of the following statement returns data to the host variables one at a time?

The maximum number of children in a B-tree of order m is

If the .................... is too much, the receiver may not be able to detect the signal at all or the signal may fall below the noise level.

Cross Product is a:

What does a field or a combination of fields that has a unique value called ?

The method of access which uses key transformation is known as

Extended Entity Relationship model consists of which of the followingi) Specializationii) Generalizationiii) Categorization

Also checkout

A transaction has following states
i) Active
ii) Fail
iii) Abort
iv) Commit

The physical location of a record is determined by a mathematical formula that transforms
a file key into a record location is :

Attenuation can be also expressed in decibel dB) and commonly used because.
i) Signal strengths often fall off logarithmically
ii) Cascade losses and gains can be calculated with simple additions and subtractions

Consider the join of a relation R with relation S. If R has m tuples and S has n tuples,
then the maximum size of join is:

Extended Entity Relationship model consists of which of the following
i) Specialization
ii) Generalization
iii) Categorization