Answer Posted / gaurav.verma4210

SELECT * from
sys.databases
is used for find the id of database.
SELECT create_date
FROM sys.databases
WHERE database_id = 2
Tempdb db is recreated each time SQL Server is restarted so
the created date time of TEMPDB will also give you the date
and time of the last restart of the instance.

What is an index. What are the types?

1011

---

What is the security principal at the database level that represents your session?

895

---

How do database indexes work?

952

---

Explain “@@rowcount” and “@@error” in sql server?

1004

---

What is partitioned view?

853

---

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

911

---

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

854

---

What is correlated subquery in sql server?

1016

---

explain different types of backups avaialabe in sql server? : Sql server database administration

919

---

What is the use of “join” in sql server?

1018

---

Explain syntax for viewing, dropping and disabling triggers?

897

---

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

888

---

Explain the steps to use transact-sql cursor?

957

---

How to loop through result set objects using odbc_fetch_row()?

919

---

What is a dataset and what are the different types of datasets?

125

---