Answer Posted / antony

Explain the DBMS, RDBMS?

DBMS:

DBMS is Data Base Management System. It is a
collection of data in a database. DBMS is just collection
of tables that dont have relations and dependencies.Client
Side processing File Level traffic is High Distributed
Network not supported Nomenclature concept of File. Dbms
won't allow you share the data server to clint.Only one
user can access the database at a time in DBMS.ADBMS is
enabled by vector field and is "one"dimensional.

RDBMS:

RDBMS is Relational Data Base Management System.
RDBMS is a collection of related data in a database.In
RDBMS we have relations of tables say primary key ,foreign
keys relation ,,that involves refrential integrity and
normalication like concepts where as Server Side Processing
Row Level Locking Network traffic is Low Distributed
Network Supported Nomenclature Concept of Table.But in
RDBMS we can share data server to client.But RDBMS allows
simultaneous access of users to the database. RDBMS is
enabled nu static "2"-dimensional tables.

What is a primary key?

996

---

How we create SQL Server 2005 Reporting Services ? Give me Sample

2042

---

What is row_number()?

1047

---

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1894

---

What is a non-clustered index?

1040

---

What is scheduled job and how to create it?

1037

---

What is cursors?

1254

---

How to add additional conditions in SQL?

1063

---

what's new in sql server 2016?

1000

---

Explain syntax for disabling triggers?

1093

---

What is difference between after and before?

1186

---

How to store and query spatial data?

1045

---

Define full outer join in sql server joins?

1047

---

What is bulkcopy in sql?

993

---

What is snapshot parameter in ssrs?

155

---