Answer Posted / monal
in SQL Server 2005:
ALTER DATABASE <Database Name> MODIFY FILE
(NAME =<File Name>, MAXSIZE = <Size>)
| Is This Answer Correct ? | 9 Yes | 8 No |
Post New Answer View All Answers
How would you extract DDL of a table without using a GUI tool?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
what is logical system in sap basis
Where would you look for errors from the database engine?
what is the role of dip user in our database?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
. 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?
what is ora 24313?what is the procedure to exclude that error?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
how can you create a user-defined lock?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
when does an alert gets signaled?