Interested to Buy Any Domain ? << Click Here >> for more details...
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.
2192Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
1919Provide 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.
1936What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
3 6403What would you use to improve performance on an insert statement that places millions of rows into that table?
TCS,
2 6051If 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 3271How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
1 3415Post New DB Administration Questions
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
how can you implement fine-grained auditing?
What is the default port no on which sql server listens? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
what do you understand by fine-grained auditing?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How would you best determine why your MVIEW couldn't FAST REFRESH?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
what is grd?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
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.
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is the difference between dropping a database and taking a database offline? : sql server DBA
