Technical Interview Questions and Answers :: Sopra Steria
- Select All
- SQL
- Java
- C++
- Informatica
- C
- DBMS
- Data Structure
- HR Question in TR
71 / 138
No Discussion on this question yet!
72 / 138
No Discussion on this question yet!
73 / 138
Yes, Consider a category table in a e-commerce web site.
Category_Id, Category_Name, Parent_Category_ID. In this table all the parent categories are also categories. When we create a self join category id will be treated as foreign key to the same table.
74 / 138
The PRIMARY KEY is the column(s) used to uniquely identify each row of a table.
75 / 138
A FOREIGN KEY is one or more columns whose values are based on the PRIMARY or CANDITATE KEY values from the database.
76 / 138
A UNIQUE KEY is one or more columns that must be unique for each row of the table.
77 / 138
The UNIQUE KEY column restricts entry of duplicate values but entry of NULL value is allowed. In case of PRIMARY KEY columns entry of duplicate as well as
78 / 138
No Discussion on this question yet!
79 / 138
No Discussion on this question yet!
80 / 138
No Discussion on this question yet!