Answer Posted / sanjeev kumar

First Method:

select table_name from information_schema.tables


Second Method:

Select Name from sysobjects where xtype='u'

Note: here 'u' means user created

How many types of triggers are there?

1014

---

Can group by and orderby be used together?

973

---

How to connect a database with sql express.?

1022

---

What is temporal data type?

879

---

What happens if strings are casted into wrong code pages in ms sql server?

1075

---

What is mean by candidate key?

958

---

What is meant by referential integrity?

963

---

1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

2446

---

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1052

---

Explain what are sparse columns?

939

---

Differentiate between a local and a global temporary table?

904

---

List some case manipulation functions in sql?

980

---

What are the differences between web role and worker role?

122

---

What is a print index?

849

---

You want to use a perspective in an mdx query. How do you select the perspective?

235

---