SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.
4 6689I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
1638Is it possible to update the multiple field values in a single query? If possible then write the actual query.
1 3736Post New DB Administration Questions
What is the default port no on which sql server listens? : sql server DBA
what do you understand by flashback feature of oracle?
What is a correlated sub-query? : 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?
Explain about your sql server dba experience? : sql server DBA
How do you open a cluster administrator? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Why would you use sql agent? : sql server DBA
internal architecture
how can you create a user-defined lock?
how can you schedule a job in database?
What are the different types of indexes available in sql server? : sql server DBA
what are the performance views in an oracle rac environment?
What is dbcc? : sql server DBA
how can you process messages in order asynchronously?