SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.
4 8046I 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
2050Is it possible to update the multiple field values in a single query? If possible then write the actual query.
1 4388Post New DB Administration Questions
how can you implement fine-grained auditing?
what are the benefits of flashback feature?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What the different types of replication and why are they used? : sql server DBA
Why would you use sql agent? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
what is logical system in sap basis
What is replication? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Why would you call update statistics? : sql server DBA
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
How do you trace the traffic hitting a sql server? : sql server DBA