IndiaBIX

Database - Database Redesign

Exercise : Database Redesign - General Questions
1.
Which of the following SQL statements are helpful in database redesign?
Correlated subqueries only
EXISTS/NOT EXISTS expressions only
Both of the above are helpful
None of the above are helpful.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
2.
What SQL command can be used to delete columns from a table?
MODIFY TABLE TableName DROP COLUMN ColumnName
MODIFY TABLE TableName DROP ColumnName
ALTER TABLE TableName DROP COLUMN ColumnName
ALTER TABLE TableName DROP ColumnName
Answer: Option
Explanation:
No answer description is available. Let's discuss.
3.
Database redesign is not terribly difficult if the:
database is structured.
database is well-designed.
database has no data.
database is relatively small.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
4.
Which SQL-92 standard SQL command can be used to change a table name?
RENAME TABLE
CHANGE TABLE
ALTER TABLE
None of the above is correct.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
5.
The process of reading a database schema and producing a data model from that schema is known as:
data modeling.
database design.
reverse engineering.
None of the above is correct.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers