How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2559

who owns the operating system files created by the utl_file package?

1129

how can you create a user-defined lock?

1058

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

2218

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2509

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2458

Explain materialized views and how they are used.

2501

what is a user-defined lock?

1147

what is the diffrence between core dba and apps dba?

2624

What purpose does the model database server? : sql server DBA

1273

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

1063

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?

2862

how can you process messages in order asynchronously?

1037

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2786

what are the types of connection load-balancing?

1048