Answer Posted / ramya

CREATE TABLE EMPLOYEE(

[EMPLOYEE_ID] INT PRIMARY KEY,

[NAME] NVARCHAR(50),

[MANAGER_ID] INT

)



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.employee_id,e1.name,e1.manager_id,e2.name from
employee e1 join employee e2
on e1.employee_id = e2.manager_id

You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

904

---

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

959

---

What is a database development?

912

---

I have a few records all are same structures data, I want to store data in multiple targets how

2594

---

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

964

---

What are the main phases of database development?

923

---

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?

923

---

explain detail about ftp in datastage?

2190

---

What are the 18 schemas?

1055

---

How you can make a parameterized view?

961

---

Explain the cube operator?

940

---

What is the maximum length of an extended property?

932

---

Which four data types cannot be used as a return type from a user-defined function?

970

---

What are the three basic rules which are to be followed for the relational model of the database?

941

---

I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

2811

---