Login/RegisterTechnical Interview Questions and Answers :: TCS
- Select All
- SQL
- Java
- C++
- WebMethod
- Informatica
- C
- DBMS
- Operating System
- Soft. Engineering
- Data Structure
- Networking
- Hadoop
- HR Question in TR
- Name of project( also, tell the summary)
- Explain the key words in the name of project
- Why this project
- Your contribution
- Advantages
- Disadvantages
- Explain by drawing a block diagram (if possible)
- Explain the project.( With or without pen
1 / 157
No Discussion on this question yet!
2 / 157
No Discussion on this question yet!
3 / 157
No Discussion on this question yet!
4 / 157
No Discussion on this question yet!
5 / 157
No Discussion on this question yet!
6 / 157
7 / 157
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.
8 / 157
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.
9 / 157
No Discussion on this question yet!
10 / 157
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
