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.
1971Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
1742Provide 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.
1753What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
3 5889What would you use to improve performance on an insert statement that places millions of rows into that table?
TCS,
2 5630If 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 2960How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
1 3177Post New DB Administration Questions
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What is a system database and what is a user database? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What is the default fill factor value? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
what do you understand by flashback feature of oracle?
What are the different sql server versions you have worked on? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How can you control the amount of free space in your index pages? : sql server DBA
what is the use of ocr?
How do you open a cluster administrator? : sql server DBA
Where would you look for errors from the database engine?
how can you schedule a job in database?