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
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
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
what are the types of connection load-balancing?
What are the steps you will take to improve performance of a poor performing query?
What is replication? : sql server DBA
What are the recovery models for a database? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
how can you find out if a table can be redefined?
What is a correlated sub-query? : sql server DBA
which background process invoke at the time of upgradation tell me???
Which autogrowth database setting is good? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What types of replication are supported in sql server? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
