[Updated] Goldman Sachs Aptitude Test Questions and Answers
Practice List of TCS Digital Coding Questions !!!
Take 50+ FREE!! Online Data Interpretation Mock test to crack any Exams.

Technical Interview Questions and Answers :: Accenture

260.53K

Tot. Mock Test: 6


Total Qs: 152+

  •  Select All
  •  C
  •  Java
  •  C++
  •  .NET
  •  SQL
  •  Informatica
  •  WebMethod
  •  Soft. Engineering
  •  Data Structure
  •  HR Question in TR
  •  Operating System
  •  DBMS
    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 :

    103 / 152

    What is a Database system?
    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 :

    105 / 152

    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 :

    106 / 152

    Describe the three levels of data abstraction?
    Answer:

    Physical Level - This is the lowest level of data abstraction which describes which describes how the data is to be stored in the database.

    Logical level - The level describes the data in the database as well as relations between these database.

    View Level- This is the highest level of data abstraction , only some part of actual database is viewed to the user.

    Please Login First :

    107 / 152

    Define the "integrity rules"
    Answer:

    There are two Integrity rules.
    > Entity Integrity: States that “Primary key cannot have NULL value”
    > Referential Integrity: States that “Foreign Key can be either a NULL value or should be Primary Key value of other relation.

    Please Login First :

    108 / 152

    What is extension and intension?
    Answer:

    The description of data base is called in tension or database schema,which is specified during database design and is not expected to change frequently.



    The actual data in a database may change quite frequently.The data in a database at a particular moment in time is called a extension or database state or snapshot.



    Source:- Extension and intension

    Please Login First :

    109 / 152

    What is System R? What are its two major subsystems?
    Answer:

    System R was designed and developed over a period of 1974-79 at IBM San Jose Research Center. It is a prototype and its purpose was to demonstrate that it is possible to build a Relational System that can be used in a real life environment to solve real life problems, with the performance at least comparable to that of the existing system.
    Its two subsystems are
    > Research Storage
    > System Relational Data System.

    Please Login First :

    110 / 152

    How is the data structure of System R different from the relational structure?
    Answer:

    Unlike Relational systems in System R
    > Domains are not supported
    > Enforcement of candidate key uniqueness is optional
    > Enforcement of entity integrity is optional
    > Referential integrity is not enforced

    Please Login First :


Most Frequent Qs.