When creating a user, what permissions must you grant to allow them to connect to the database?
3 8265Post New DB Administration Questions
suppose you want to audit specific activities on sensitive data. How can you achieve that?
How would you go about verifying the network name that the local_listener is currently using?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
Explain materialized views and how they are used.
Why would you call update statistics? : sql server DBA
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
what is grd?
What is a correlated sub-query? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
how does an oracle clusterware manage crs resources?
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?
What would you do with an "in-doubt" distributed transaction?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
how can you implement fine-grained auditing?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?