SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.
4 7472I 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
1881Is it possible to update the multiple field values in a single query? If possible then write the actual query.
1 4103Post New DB Administration Questions
how to restore files with rman?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Why would you call update statistics? : sql server DBA
how can you process messages in order asynchronously?
how can you record information about current session?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : 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.
How would you go about verifying the network name that the local_listener is currently using?
what is asm?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
what are the performance views in an oracle rac environment?
Why would you use sql agent? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?