Answer Posted / guest
alter databse datafile 'location of datafile' resize 2000M
Regards
Abhinav Phadnis
| Is This Answer Correct ? | 13 Yes | 3 No |
Post New Answer View All Answers
What types of replication are supported in sql server? : sql server DBA
what do you understand by fine-grained auditing?
how to restore files with rman?
what is asm?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
how can you schedule a job in database?
What is the default port no on which sql server listens? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
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?
How would you extract DDL of a table without using a GUI tool?
Why would you call update statistics? : sql server DBA
when does an alert gets signaled?
how can you generate profile of pl/sql applications to identify performance bottlenecks?