Get Off-Campus Placement Jobs Info !!!
Programs asked in Mettl Coding Round
Click To Practce List of Programs asked in Nagarro !!!

Technical Interview Questions and Answers :: Capgemini

326.01K

Tot. Mock Test: 17


Total Qs: 32+

  •  Select All
  •  C++
  •  Informatica
  •  DBMS
  •  Operating System
  •  Networking
  •  HR Question in TR
  •  C
  •  Soft. Engineering

    11 / 32

    Difference in instance and database.
    Answer:

    No Discussion on this question yet!

    Please Login First :
    Answer:

    A database is a logically coherent collection of data with some inherent meaning, representing some aspect of real world and which is designed, built and populated with data for a specific purpose.

    Please Login First :
    Answer:

    It is a collection of programs that enables the user to create and maintain a database. In other words, it is general-purpose software that provides the users with the processes of defining, constructing and manipulating the database for various applications.

    Please Login First :
    Answer:

    The database and DBMS software together are called as Database system.

    Please Login First :
    Answer:

    1. Reduces Data Redundancy

    2. Maintains Data Consistent

    3.Query to access data

    4. Security

    5. Easier access by tables

    Please Login First :

    16 / 32

    Disadvantage in File Processing System?
    Answer:

    1. Redundant Data

    2. Inconsistency

    3. Not easy to access data.

    4. No security

    5. Concurrent access is not allowed.

    Please Login First :

    17 / 32

    What is the use of ACID property in database management system?
    Answer:

    ACID properties are 4 important properties of a transaction that a DBMS must ensure to maintain data in the case of concurrent access

    Please Login First :

    18 / 32

    Differentiate between compiler and interpreter?
    Answer:




























    Interpreter Compiler
    Translates program one statement at a time. Scans the entire program and translates it as a whole into machine code.
    It takes less amount of time to analyze the source code but the overall execution time is slower. It takes a large amount of time to analyze the source code but the overall execution time is comparatively faster.
    No intermediate object code is generated, hence are memory efficient. Generates intermediate object code which further requires linking, hence requires more memory.
    Continues translating the program until the first error is met, in which case it stops. Hence debugging is easy. It generates the error message only after scanning the whole program. Hence debugging is comparatively hard.
    Programming language like Python, Ruby use interpreters. Programming language like C, C use compilers.


     

    Please Login First :

    19 / 32

    Differentiate between compiler and debugger?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    20 / 32

    What are the types of data models?
    Answer:

    No Discussion on this question yet!

    Please Login First :


Most Frequent Qs.