• 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
A regular subquery can be processed:

None of these
by nesting.
from the bottom up.
from the top down.

ANSWER DOWNLOAD EXAMIANS APP

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

One
Two
Four
Three

ANSWER DOWNLOAD EXAMIANS APP

Database Redesign
The use of the double NOT EXISTS can be used to find rows that do not match some specified condition.

False
True

ANSWER DOWNLOAD EXAMIANS APP

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

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

ANSWER DOWNLOAD EXAMIANS APP

Database Redesign
To drop a column that is used as a foreign key, first:

drop the primary key.
drop the foreign key constraint.
All of these
drop the table containing the foreign key.

ANSWER DOWNLOAD EXAMIANS APP

Database Redesign
The SQL-92 command to change a table name is RENAME TABLE.

False
True

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
↑