Question
a.
Changing a column data type from char to date
b.
Changing a column data type from numeric to char
c.
Both of the above actions should succeed.
d.
Neither of the above actions will succeed.
Posted under Recovery System DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. Which of the following modifications may not succeed?
Similar Questions
Discover Related MCQs
Q. Because of the importance of making data model changes correctly, many professionals are ________ about using an automated process for database redesign.
View solution
Q. Which of the following can cause a transaction failure
View solution
Q. If the transaction can no longer continue with its normal execution because of some internal condition, it is called as a _________
View solution
Q. If a system has entered and undesirable state due to which it is unable to continue with normal execution, it is called as _________
View solution
Q. If there is a hardware malfunction or a bug in the database that causes the loss of content of volatile storage, it is called as ________
View solution
Q. The assumption that the hardware errors bring the system to a halt is called as ________
View solution
Q. Which of the following is not a classification of storage
View solution
Q. If a failure has occurred in the midst of a transfer, it is called as _________
View solution
Q. State true or false: The destination block has incorrect information in case of a total failure
View solution
Q. The partitions of the database into fixed length storage units are called as __________
View solution
Q. The blocks residing on the disk are referred to as ___________
View solution
Q. The area of memory where blocks temporarily reside is called as ________
View solution
Q. The most widely used structure for recording database modification is called as _______
View solution
Q. An update log record describes a ________ database write
View solution
Q. Which of the following fields does the update log record have?
View solution
Q. The unique identifier of the transaction that performed the write operation is called as _______
View solution
Q. The value of the data item prior to the write is called as _________
View solution
Q. If a transaction does not modify the database until it has committed it is said to use a _______ modification technique
View solution
Q. We say that a transaction has been ________ when its commit log record has been output to stable storage.
View solution
Q. State true or false: Using checkpoints reduces overhead
View solution
Suggested Topics
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
