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.
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
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.
Why does Oracle not permit the use of PCTUSED with indexes?
What would you do with an "in-doubt" distributed transaction?
What are the commands you'd issue to show the explain plan for "select * from dual"?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
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?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
The present state of recession in the IT Industry – as a Human Resource Manager how are you going to undertake Human Resource Planning to Macro level to tide over the crisis
If you are working in a super market, what techniques/ tools you will use in data collection. How are you going to analysis the data and make inferences? How will you finally apply your market research to improve sales and win over customers?
If you are made the compaign leader for a particular political party .How will you use your leader ship skills to motivate your party men to ensure success of the party nominee in the elections? (Focus on the individual motivate and apply leadership style).
Suppose the price elasticity of demand for the textbooks is two and the price of the textbook is increased by 10% By how much does the quantity demand fall? Enter the results and discuss reason for the fall in quantity demand.