what are the differences of where and if in SAS?

1906

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

2342

What the different types of replication and why are they used? : sql server DBA

868

how can you implement fine-grained auditing?

843

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1753

internal architecture

1967

What are the operating modes in which database mirroring runs? : sql server DBA

871

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

2203

what is ora 24313?what is the procedure to exclude that error?

2343

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

841

which background process invoke at the time of upgradation tell me???

2476

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.

1937

What is fill factor? : sql server DBA

905

What is the difference between dropping a database and taking a database offline? : sql server DBA

825

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1793