suppose you want to audit specific activities on sensitive data. How can you achieve that?

792

How would you go about verifying the network name that the local_listener is currently using?

3006

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

1739

Explain materialized views and how they are used.

2175

Why would you call update statistics? : sql server DBA

799

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?

2245

what is grd?

890

What is a correlated sub-query? : sql server DBA

811

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

2072

how does an oracle clusterware manage crs resources?

811

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?

2609

What would you do with an "in-doubt" distributed transaction?

1683

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

2226

how can you implement fine-grained auditing?

860

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2362