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

Explain about post-relational databases?

1073

---

Explain the rollup operator?

1136

---

Explain about relational database management systems?

1009

---

How to combine two function together?

2196

---

Which data type cannot be used as a parameter in a udf?

1017

---

What is an application role and explain a scenario when you would use one?

1055

---

Write the fastest query to find out how many rows exist in a table?

1167

---

What is the physical representation for a many-to-many relationship?

1133

---

In which database can extended stored procedures be added?

944

---

How to generate OIDS

2328

---

The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

1047

---

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

2546

---

How to replace not in with not exist?

2171

---

What is the database development process?

1264

---

Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?

2467

---