SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.
4 6687I 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
1636Is it possible to update the multiple field values in a single query? If possible then write the actual query.
1 3734Post New DB Administration Questions
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
what is the use of ocr?
what is the role of dip user in our database?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
which background process invoke at the time of upgradation tell me???
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
How do you trace the traffic hitting a sql server? : sql server DBA
how can you process messages in order asynchronously?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What is dcl? : sql server DBA
What is a correlated sub-query? : sql server DBA
who owns the operating system files created by the utl_file package?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?