Technical Interview Questions and Answers :: TCS

252.83K

Tot. Mock Test: 40


Total Qs: 157+

  •  Select All
  •  SQL
  •  Java
  •  C++
  •  WebMethod
  •  Informatica
  •  C
  •  DBMS
  •  Operating System
  •  Soft. Engineering
  •  Data Structure
  •  Networking
  •  Hadoop
  •  HR Question in TR

    1 / 157

    Give a run through your resume.
    Answer:

    No Discussion on this question yet!

    Please Login First :

    2 / 157

    Explain in detail about your academic project?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    3 / 157

    Your daily activities in the project.
    Answer:

    No Discussion on this question yet!

    Please Login First :

    4 / 157

    What was the objective of your project.?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    5 / 157

    What is the end result in your project?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    6 / 157

    Some question from project specific.
    Answer:

    1. Name of project( also, tell the summary)
    2. Explain the key words in the name of project
    3. Why this project
    4. Your contribution
    5. Advantages
    6. Disadvantages
    7. Explain by drawing a block diagram (if possible)
    8. Explain the project.( With or without pen

    Please Login First :
    Answer:

    A relation schema R is in 3NF if it is in 2NF and for every FD X -> A either of the following is true
    > X is a Super-key of R.
    > A is a prime attribute of R.
    In other words, if every non prime attribute is non-transitively dependent on primary key.

    Please Login First :

    8 / 157

    What are partial, alternate,, artificial, compound and natural key?
    Answer:

    Partial Key:
    It is a set of attributes that can uniquely identify weak entities and that are related to same owner entity. It is sometimes called as Discriminator.

    Alternate Key:
    All Candidate Keys excluding the Primary Key are known as Alternate Keys.

    Artificial Key:
    If no obvious key, either stand alone or compound is available, then the last resort is to simply create a key, by assigning a unique number to each record or occurrence. Then this is known as developing an artificial key.

    Compound Key:
    If no single data element uniquely identifies occurrences within a construct, then combining multiple elements to create a unique identifier for the construct is known as creating a compound key.

    Natural Key:
    When one of the data elements stored within a construct is utilized as the primary key, then it is called the natural key.

    Please Login First :

    9 / 157

    What is join in DBMS and What are the different types of JOIN operations?
    Answer:

    No Discussion on this question yet!

    Please Login First :
    Answer:

    USED TO CONVERT HIERACHICAL STRUCTURE TO THE FLAT STRUCTURE. IT IS USED TO JOIN A TABLE ITSELF AS LIKE IF THAT IS THE SECOND TABLE

    Please Login First :


Most Frequent Qs.