Answer / Jitendra Kumar Ray

A DBMS (Database Management System) typically consists of four main components: Database, Data Dictionary, SQL Interpreter, and Application Program Interface.

What is use of except clause?

1 Answers  

---

What is collation?

1 Answers  

---

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

2 Answers  

---

How to define output parameters in stored procedures?

1 Answers  

---

Is it safe to delete log files?

1 Answers  

---

as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

1 Answers  

---

What is Transaction?

2 Answers  

---

explain declarative management framework (dmf) in sql server 2008?

1 Answers  

---

what is the use of database index(apart from the last searching of records) and what is the use of composite key?

1 Answers  

---

Write a sql query to display the current date?

1 Answers  

---

How to add a new dsn with the odbc driver for sql server?

1 Answers  

---

What are the system database in sql server 2008?

1 Answers  

---