Answer / guest

alter databse datafile 'location of datafile' resize 2000M



Regards
Abhinav Phadnis

Answer / monal

in SQL Server 2005:

ALTER DATABASE <Database Name> MODIFY FILE
(NAME =<File Name>, MAXSIZE = <Size>)

What is blocking and how would you troubleshoot it?

1 Answers  

---

Explain about your sql server dba experience? : sql server DBA

0 Answers  

---

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

3 Answers  

---

what is incremental checkpoint?

1 Answers   CTS,

---

I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers  

---

I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1 Answers  

---

What is checkpoint?

3 Answers   Accenture,

---

How to make a replica of existing oracle server to another server?

3 Answers  

---

How many packages we have in db

1 Answers   Tesco,

---

What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

3 Answers  

---

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---