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

Physical Database Design

Physical Database Design
The fastest read/write time and most efficient data storage of any disk array type is:

RAID-2
RAID-0
RAID-1
RAID-3

ANSWER DOWNLOAD EXAMIANS APP

Physical Database Design
In general, larger block sizes are used for online transaction processing applications and smaller block sizes are used for databases with a decision support or data warehousing system.

False
True

ANSWER DOWNLOAD EXAMIANS APP

Physical Database Design
A pointer is a detailed coding scheme recognized by system software for representing organizational data.

False
True

ANSWER DOWNLOAD EXAMIANS APP

Physical Database Design
Distributing the columns of a table into several separate physical records is known as horizontal partitioning.

False
True

ANSWER DOWNLOAD EXAMIANS APP

Physical Database Design
Which of the following is not a factor to consider when switching from small to large block size?

The length of all of the fields in a table row
Block contention
The number of columns
Random row access speed

ANSWER DOWNLOAD EXAMIANS APP

Physical Database Design
Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process.

False
True

ANSWER DOWNLOAD EXAMIANS APP
MORE MCQ ON Physical Database Design

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
↑