Technical 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
61 / 158
SELECT min(salary) AS high5 FROM employee WHERE salary IN(SELECT DISTINCT TOP 5 salary FROM orders ORDER BY salary DESC)
62 / 158
Nnormalization is step by step process of spiliting the bigger table into smaller table without changing any functionality. This wil improve the performance.
There are some way to normalize table
A. 1nf
B.2nf
C.3nf
63 / 158
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.
64 / 158
A data base schema which is specified by a set of definitions expressed by a special language is called DDL. Data Definition Language (DDL) is used to define and manage all the objects in an SQL database.
65 / 158
No Discussion on this question yet!
66 / 158
SELECT max(salary) AS salary2 FROM orders WHERE salary < (SELECT max(salary) AS salary1 FROM orders)
67 / 158
No Discussion on this question yet!
68 / 158
No Discussion on this question yet!
69 / 158
No Discussion on this question yet!
70 / 158
No Discussion on this question yet!