When creating a user, what permissions must you grant to allow them to connect to the database?
3 7589Post New DB Administration Questions
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
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?
How can you control the amount of free space in your index pages? : sql server DBA
what are the types of connection load-balancing?
What is the default fill factor value? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Why would you call update statistics? : sql server DBA
Can you redefine a table online?
how can you find out if a table can be redefined?
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.
how can you implement fine-grained auditing?
Query processing is slow(eg select query)how will u solve that
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
how can you schedule a job in database?