Which of the following modifications may not succeed?$? – McqOptions

MCQOPTIONS

1.	Which of the following modifications may not succeed?$?
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
Answer» B. Changing a column data type from numeric to char

Discussion

No Comment Found

Related MCQs

If a database is built correctly the first time, it will not have to be redesigned.%!
Some organizations take the stand that no application should ever employ the true name of a table.%!
The EXISTS keyword will be true if any row in the subquery meets the condition.%!
Typically, there should be at least two different copies of the database schema used in the redesign process.%!
The data model produced from the reverse engineering process does not include intersection table data.%!
Database redesign is especially difficult if the database has no data.%!
Dependency graphs are diagrams that consist of nodes and arcs that show the dependencies of a database.%!
It is not easy to build a database correctly the first time.%!
Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process.%!
Correlated subqueries are similar to a regular subquery.%!