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 / 157
SELECT min(salary) AS high5 FROM employee WHERE salary IN(SELECT DISTINCT TOP 5 salary FROM orders ORDER BY salary DESC)
62 / 157
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 / 157
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 / 157
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 / 157
No Discussion on this question yet!
66 / 157
SELECT max(salary) AS salary2 FROM orders WHERE salary < (SELECT max(salary) AS salary1 FROM orders)
67 / 157
No Discussion on this question yet!
68 / 157
No Discussion on this question yet!
69 / 157
No Discussion on this question yet!
70 / 157
No Discussion on this question yet!