Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)
Oracle Security (38)
Oracle Forms Reports (510)
Oracle Data Integrator (ODI) (120)
Oracle ETL (15)
Oracle RAC (93)
Oracle D2K (72)
Oracle AllOther (241) 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.
2119What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
1 3583What would you use to improve performance on an insert statement that places millions of rows into that table?
1 3706If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
2147How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
1913You 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?
1 8956I 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?
1 4014
What is a system tablespace?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
Please explain joins in oracle?
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
How can I create database in oracle?
how to load the data with one flat file and one rdbms table using joins?
What do you understand by the term 'normalization'?
How to convert numbers to characters in oracle?
What is an oracle database schema?
What is memory advisor in Oracle?
What is a static data dictionary in oracle?
explain what is odi?why is it different from the other etl tools.
What are the uses of a database trigger?
How to create a new tablespace in oracle?