Answer Posted / akoman

D) EXPLAIN

Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?

696

---

Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.

921

---

What does new grouping sets enables you to do?

600

---

What advantages does DBMS have over traditional file systems?

591

---

Difference between sql and mysql?

1624

---

---

What is the Difference Primary key and Unique Key

573

---

What is table scan and index scan?

611

---

Explain about ur projets on teradata???

1357

---

can we delete autodiff back up that we have set through sql server agent.

1737

---

What are the advantages of using database?

548

---

What is a database call?

552

---

Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool

1422

---

define primary key index, bitmap index, hash index,virtual indwx

2844

---

if i want to display the name of students such that to which city they belong must have count greaer than two

1776

---

Differentiate between unique key and foreign key?

583

---