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.
2205Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
1929Provide 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.
1948What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
3 6430What would you use to improve performance on an insert statement that places millions of rows into that table?
TCS,
2 6075If 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 3294How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
1 3433Post New DB Administration Questions
when does an alert gets signaled?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What are the commands you'd issue to show the explain plan for "select * from dual"?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What are statistics, under what circumstances they go out of date, how do you update them?
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
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What the different types of replication and why are they used? : sql server DBA
How do you open a cluster administrator? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
how can you create a user-defined lock?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).