Answer Posted / sushant more (sybase dba)

CREATE TABLE EMPLOYEE(

[EMPLOYEE_ID] INT PRIMARY KEY,

[NAME] NVARCHAR(50),

[MANAGER_ID] INT

)

GO

INSERT INTO EMPLOYEE VALUES(101,'Mary',102)

INSERT INTO EMPLOYEE VALUES(102,'Ravi',NULL)

INSERT INTO EMPLOYEE VALUES(103,'Raj',102)

INSERT INTO EMPLOYEE VALUES(104,'Pete',103)

INSERT INTO EMPLOYEE VALUES(105,'Prasad',103)

INSERT INTO EMPLOYEE VALUES(106,'Ben',103)


select e1.NAME from EMPLOYEE e1,EMPLOYEE e2
where e1.EMPLOYEE_ID = e2.MANAGER_ID

How can you fix a poorly performing query?

1254

---

Why does this query return 0?

1054

---

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

1021

---

How to combine two function together?

2202

---

If a column is an image value type, how you can compare column values? How can you use this column in join clause?

1056

---

How would you design a database for an online site, which would average a million hits a day?

1054

---

How to customize error conditions.

2197

---

fact table and dimension table containg one to many relationship or many to one relastionship

2548

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

2470

---

What is database design and development?

1063

---

What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

1073

---

To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

4053

---

How long can an error message be in raiseerror function?

1045

---

Explain about the relational database?

1130

---

Explain the role of indexing in databases?

1187

---