SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.
4 8345I 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
2155Is it possible to update the multiple field values in a single query? If possible then write the actual query.
1 4525Post New DB Administration Questions
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Can you redefine a table online?
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.
what is the diffrence between core dba and apps dba?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
what is a crs resource?
internal architecture
What is transparent data encryption? : sql server DBA
what functionality does oracle provide to secure sensitive information?
how can a session indicate its interest in receiving alerts?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
what is ora 24313?what is the procedure to exclude that error?