Answer Posted / chandra sekhar

select min(salary) from emp where salary in (select top n salary from emp order by salary desc)

What are the various editions of sql server 2017 that are available in the market?

503

---

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

612

---

Which are the two editions in which SQL Azure database available?

99

---

What is standby servers? Explain types of standby servers.

514

---

What do you mean by data integrity?

597

---

---

State a few properties of relational databases?

664

---

What are different types of data sources?

494

---

Name the different type of indexes in sql?

531

---

What do you mean by table and field in sql?

556

---

How the authentication mode can be changed?

607

---

Explain what are the restrictions while creating batches in sql server?

587

---

How to compare the top two records using sql?

766

---

What do you mean by stored techniques? How would we use it?

584

---

What is difference between materialized view and view?

488

---

What is database dimension? : sql server analysis services, ssas

622

---