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.
2282Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
1976Provide 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.
1994What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
3 6579What would you use to improve performance on an insert statement that places millions of rows into that table?
TCS,
2 6205If 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 3384How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
1 3513Post New DB Administration Questions
how can you find out if a table can be redefined?
What is the importance of a recovery model? : sql server DBA
What is a system database and what is a user database? : sql server DBA
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
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.
What are statistics, under what circumstances they go out of date, how do you update them?
how can you get actual data change values from previous transactions in oracle?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
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 are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
Explain about your sql server dba experience? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA