How do you troubleshoot errors in a sql server agent job? : sql server DBA

1059

what is the last version,the release date of that version and fix pack of ibm db2 udb?

1927

what is the use of recording information about current session?

1007

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

1024

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

2388

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

963

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4392

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1954

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2627

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

1894

Why would you use sql agent? : sql server DBA

1030

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2286

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

2024

how can you initialize log miner?

1091

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?

2753