Interested to Buy Any Domain ? << Click Here >> for more details...
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
1996What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
2210Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
2095Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
1946Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
2248Provide 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.
2045What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
1 3503Post New Oracle General Questions
What are the differences between interval year to month and interval day to second?
What is sequence?
How do we get field details of a table?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Explain the types of exception?
Explain the use of rows option in imp command.
What is the order of defining local variables and sub procedures/functions?
What are the extensions used by oracle reports?
Can we write dml statement in function in oracle?
defination of bitmap index
Explain cascading triggers.
What are the differences between blob and clob in oracle?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
How to create a stored program unit?
What is blob data type in oracle?
