When creating a user, what permissions must you grant to allow them to connect to the database?
3 8691Post New DB Administration Questions
What is transparent data encryption? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
how can you schedule a job in database?
Which autogrowth database setting is good? : sql server DBA
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 is the importance of a recovery model? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
what is the use of recording information about current session?
What the different topologies in which replication can be configured? : sql server DBA
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.
how to restore files with rman?
how can you initialize log miner?
What is dbcc? : sql server DBA