Answer / Prem Prakash Verma

Equi join is a type of SQL JOIN operation that combines rows from two tables based on a matching condition on the equality (=) operator between common columns in both tables. Here's an example: {"create table A (id int, name varchar(50)); create table B (id int, age int); insert into A values (1, 'John'); insert into A values (2, 'Doe'); insert into B values (1, 25); insert into B values (2, 30); select A.name, B.age from A inner join B on A.id = B.id;}

Explain what is analysis service repository?

1 Answers  

---

What are the various Isolation levels?

2 Answers   HP,

---

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 Answers  

---

What are the disadvantages of indexes?

1 Answers  

---

Explain what stored procedure sp_replcounters is used for? : sql server replication

1 Answers  

---

how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.

0 Answers  

---

What is sql server management studio? : sql server management studio

1 Answers  

---

What is auditing in sql server?

1 Answers  

---

Why use sub query in sql server and list out types of sub queries?

1 Answers  

---

What are subquery and its properties?

1 Answers  

---

Can we write a distributed query and get some data which is located on other server and oracle database?

1 Answers  

---

How will you decide the active and passive nodes?

1 Answers  

---