SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.
4 8179I 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
2112Is it possible to update the multiple field values in a single query? If possible then write the actual query.
1 4459Post New DB Administration Questions
which background process invoke at the time of upgradation tell me???
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
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 would you extract DDL of a table without using a GUI tool?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What are statistics, under what circumstances they go out of date, how do you update them?
Why does Oracle not permit the use of PCTUSED with indexes?
How would you best determine why your MVIEW couldn't FAST REFRESH?
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 the use of recording information about current session?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
how to restore files with rman?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
What is a correlated sub-query? : sql server DBA