Answer / chowdary

Buffer Cache Advice, Segment Level Statistics and Timed
Statistics

Query processing is slow(eg select query)how will u solve that

3 Answers   TCS,

---

which background process will run @ the time of creation of catalog database

1 Answers   CSC,

---

When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers  

---

What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,

---

A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?

1 Answers   TCS,

---

---

How would you determine the time zone under which a database was operating?

2 Answers  

---

Explain materialized views and how they are used.

0 Answers  

---

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

0 Answers  

---

Explain what partitioning is and what its benefit is.

2 Answers  

---

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 Answers  

---

What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers  

---

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   STC,

---