SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.
4 8015I 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
2044Is it possible to update the multiple field values in a single query? If possible then write the actual query.
1 4369Post New DB Administration Questions
What is a correlated sub-query? : sql server DBA
What are the commands used in dcl? : sql server DBA
What authentication modes does sql server support? : sql server DBA
how does an oracle clusterware manage crs resources?
how can you get actual data change values from previous transactions in oracle?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
what is a crs resource?
What is the default port no on which sql server listens? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
How would you extract DDL of a table without using a GUI tool?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
what is grd?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is dbcc? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?