How do I setup a database connection?

1005

Display the employees whose salary is less than average salary.

1064

What is global database name?

999

What are the types of indexes that are present inside a database?

1126

what is transaction state, buffer management, shadow paging

3454

Explain database partitioning.

1074

what is data access layer?

2398

What is dialect in database?

971

Is storing images in a database a good idea?

996

Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.

1133

What do you mean by cluster and non cluster index?

1076

Is redis in memory database?

995

What are the concurrency problems a database faces?

1034

I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage

1550

Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.

1893