¡¡ 26. database is hung. old and new user connections alike hang on impact. what do you do£¿ your sys sqlplus session is able to connect.

    27. 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.

    28. illustrate how to determine the amount of physical cpus a unix box possesses £¨LINUX and/or solaris£©¡£

    29. how do you increase the os limitation for open files £¨linux and/or solaris£©£¿

    30. provide 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.

    31. explain how you would restore a database using rman to point in time£¿

    32. how does oracle guarantee data integrity of data changes£¿

    33. which environment variables are absolutely critical in order to run the oui£¿

    34. what sql query from v$session can you run to show how many sessions are logged in as a particular user account£¿

    35. why does oracle not permit the use of pctused with indexes£¿

    36. what would you use to improve performance on an insert statement that places millions of rows into that table£¿

    37. what would you do with an "in-doubt" distributed transaction£¿

    38. what are the commands you¡¯d issue to show the explain plan for "select * from dual"£¿

    39. in what script is "snap$" created£¿ in what script is the "scott/tiger" schema created£¿

    40. if 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£¿

    41. how would you configure your networking files to connect to a database by the name of dss which resides in domain icallinc.com£¿

    42. you create a private database link and upon connection£¬

    fails with£º ora-2085£º connects to .

    what is the problem£¿ how would you go about resolving this error£¿

    43. 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£¿

    44. explain the concept of the dual table.

    45. what are the ways tablespaces can be managed and how do they differ£¿

    46. from the database level£¬ how can you tell under which time zone a database is operating£¿r0t€GMew+cve€kL:Sv[±¾_ÎÄ_À´_Ô´_ÓÚ_ÎÒ_µÄ_ѧ_Ï°_ÍøITÈÏÖ¤ORACLE/CIWÈÏÖ¤ http://Www.GZU521.Com ]r0t€GMew+cve€kL:Sv

    47. what¡¯s the benefit of "dbms_stats" over "analyze"£¿

    48. typically£¬ where is the conventional directory structure chosen for oracle binaries to reside£¿

    49. 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£¿

    50. how do you recover a datafile that has not been physically been backed up since its creation and has been deleted. provide syntax example.