How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2025

What are the commands you'd issue to show the explain plan for "select * from dual"?

2226

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

2263

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

1010

how can you enable flashback feature?

942

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1970

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

1171

when does an alert gets signaled?

1039

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

1102

Explain about your sql server dba experience? : sql server DBA

1076

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.

1985

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

2402

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

4338

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

2104

what are the types of connection load-balancing?

994