Answer Posted / mohanamurali chittim

1.Ans) NO

5.Ans)go to mount state then give

alter database archivelog;

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1166

---

Explain materialized views and how they are used.

2498

---

What are the different types of indexes available in sql server? : sql server DBA

1266

---

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1167

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

2352

---

What is a system database and what is a user database? : sql server DBA

1318

---

what are the performance views in an oracle rac environment?

1125

---

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

1078

---

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

2350

---

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1796

---

Where do you find the default index fill factor and how to change it? : sql server DBA

1123

---

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1184

---

Why would you use sql agent? : sql server DBA

1132

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

2268

---

How would you go about verifying the network name that the local_listener is currently using?

3273

---