• HOME
  • QUIZ
  • CONTACT US
EXAMIANS
  • COMPUTER
  • CURRENT AFFAIRS
  • ENGINEERING
    • Chemical Engineering
    • Civil Engineering
    • Computer Engineering
    • Electrical Engineering
    • Mechanical Engineering
  • ENGLISH GRAMMAR
  • GK
  • GUJARATI MCQ

Database Redesign

Database Redesign
How many copies of the database schema are typically used in the redesign process?

Three
Four
One
Two

ANSWER DOWNLOAD EXAMIANS APP

Database Redesign
Which of the following modifications may not succeed?

Both of the above actions should succeed
Changing a column data type from numeric to char
Changing a column data type from char to date
Neither of the above actions will succeed

ANSWER DOWNLOAD EXAMIANS APP

Database Redesign
What SQL command can be used to add columns to a table?

ALTER TABLE TableName ADD ColumnName
ALTER TABLE TableName ADD COLUMN ColumnName
MODIFY TABLE TableName ADD ColumnName
MODIFY TABLE TableName ADD COLUMN ColumnName

ANSWER DOWNLOAD EXAMIANS APP

Database Redesign
Reverse engineering is the process of reading a database schema and producing a data model from that schema.

False
True

ANSWER DOWNLOAD EXAMIANS APP

Database Redesign
A tool that can help designers understand the dependencies of database structures is a:

dependency graph.
graphical display.
None of these
data model.

ANSWER DOWNLOAD EXAMIANS APP

Database Redesign
How can you find rows that do not match some specified condition?

None of these
EXISTS
NOT EXISTS
Double use of NOT EXISTS

ANSWER DOWNLOAD EXAMIANS APP
MORE MCQ ON Database Redesign

DOWNLOAD APP

  • APPLE
    from app store
  • ANDROID
    from play store

SEARCH

LOGIN HERE


  • GOOGLE

FIND US

  • 1.70K
    FOLLOW US
  • EXAMIANSSTUDY FOR YOUR DREAMS.
  • SUPPORT :SUPPORT EMAIL ACCOUNT : examians@yahoo.com

OTHER WEBSITES

  • GUJARATI MCQ
  • ACCOUNTIANS

QUICK LINKS

  • HOME
  • QUIZ
  • PRIVACY POLICY
  • DISCLAIMER
  • TERMS & CONDITIONS
  • CONTACT US
↑