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.
1991Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
1757Provide 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.
1769What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
3 5952What would you use to improve performance on an insert statement that places millions of rows into that table?
TCS,
2 5671If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
1 2985How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
1 3206Post New DB Administration Questions
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
what is asm?
how to restore files with rman?
what are the performance views in an oracle rac environment?
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
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
how can you enable flashback feature?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
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.
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
Can you redefine a table online?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
what are the benefits of flashback feature?
What are the steps you will take to improve performance of a poor performing query?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA