From the database level, how can you tell under which time zone a database is operating?
1 Oracle General 2181Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Oracle General 1585You 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?
Oracle General 1462How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
1 Oracle General 2519What are the differences between a sys and system user and what are the extra privileges available to the sys user?
1 Oracle General 4925