SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.
4 8156I 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
2104Is it possible to update the multiple field values in a single query? If possible then write the actual query.
1 4448Post New DB Administration Questions
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What authentication modes does sql server support? : sql server DBA
how can you enable flashback feature?
Explain about your sql server dba experience? : sql server DBA
Why would you use sql agent? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
what is a crs resource?
What is a correlated sub-query? : 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 can you communicate with operating system files from oracle?
What types of replication are supported in sql server? : sql server DBA
how can you create a user-defined lock?
What is the default fill factor value? : sql server DBA
What is dcl? : sql server DBA
What the different components in replication and what is their use? : sql server DBA