• 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 QUIZ

Sequential retrieval on a primary key for sequential file storage has which of the following features?

TRUE ANSWER : ?
YOUR ANSWER : ?

What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary?

TRUE ANSWER : ?
YOUR ANSWER : ?

Some advantages of partitioning include: efficiency, security, and load balancing.

TRUE ANSWER : ?
YOUR ANSWER : ?

The three newest database architectures in use today are relational, multidimensional and hierarchical.

TRUE ANSWER : ?
YOUR ANSWER : ?

When storage space is scarce and physical records cannot span pages, creating multiple physical records from one logical relation will minimize wasted storage space.

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is an advantage of partitioning?

TRUE ANSWER : ?
YOUR ANSWER : ?

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.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

TRUE ANSWER : ?
YOUR ANSWER : ?

Denormalization and clustering can work well to minimize data access time for small records.

TRUE ANSWER : ?
YOUR ANSWER : ?

Hashing algorithm converts a primary key value into a record address.

TRUE ANSWER : ?
YOUR ANSWER : ?
MORE MCQ

QUIZ STATS

  • 0
  • 0

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
↑