Database-MySQL [3i Infotech Placement]: Sample Questions 29 - 30 of 162

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 29

Edit

Describe in Detail

Essay▾

What is a Database system?

Explanation

Figure of the Database System

Popular types of DBMS

  • Rational database management system (RDMS) :

    - Aadaptable to most use cases, but RDBMS Tier-1 products can be quite expensive.

  • In-memory database management system (IMDBMS) :

    - Provides faster response times and better performance.

  • Columnar database management system (CDBMS) :

    -Well-suited for data warehouses that have a large number of similar data items.

  • Cloud-based data management system

    - The cloud service provider is responsible for providing and maintaining the DBMS.

Advantages of DBMS

  • Segregation of applicaion program.
  • Minimal data duplicacy.
  • Easy retrieval of data.
  • Reduced development time and maintainance need.
  • Data security
  • A locking mechanism for concurrent access.
  • Robust data integrity capabilities
  • Logging and auditing of activity
  • Data abstraction and independence

Question 30

Edit

Write in Short

Short Answer▾

What is the use of analysing the tables?

Explanation

Use the ANALYZE statement to collect statistic, for example

  • Collect or delete statistics about an index or index partition, table or table partition, index-organized table, cluster, or scalar object attribute.
  • Validate the structure of an index or index partition, table or table partition, index-organized table, cluster, or object reference.
  • Identify migrated and chained rows of a table or cluster.

Developed by: