3i Infotech Papers: Sample Questions 243 - 244 of 1245

Examrace Placement Series prepares you for the toughest placement exams to top companies.

Question number: 243

» Database » MySQL

Essay Question▾

Describe in Detail

What is a Database system?

Explanation

Figure of the Database system

Figure of the Database System

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 number: 244

» Basic CS » Operating System

Essay Question▾

Describe in Detail

How VM works?

Explanation

Virtual Machine in figure

Virtual Machine in Figure

Virtual Machine in figure

Virtual Machine:

  • A virtual machine provides idea of a distinct or separate computer system while the real hardware might be shared.

  • Based on architecture of computer- provide functionality of a physical computer.

  • Runs on top of current operating system called the host operating system to provide virtual hardware to guest operating systems.

  • For example Linux can run as guest system on windows host operating system in a VM.

  • Guest operating system runs as if it were running on physical computer.

  • Virtual machine appears to be a real, physical computer.

  • Provided by the virtual functions mapped to real hardware on physical machine- for example, a virtual machine’s virtual hard disk is stored in a file located on our hard drive.