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.
2123What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
1 3592What would you use to improve performance on an insert statement that places millions of rows into that table?
1 3719If 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?
2149How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
1916You 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 8968I 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 4018
What is an oracle function?
What operator tests column for the absence of data?
Explain the use of compress option in exp command.
What is meant by a deadlock situation?
Explain integrity constraints?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
Were you involved in any data conversion, which one?
What is the difference between truncate and delete? How would a full table scan behave after?
Explain the various types of oracle report?
What are dml statements in oracle?
How does oracle handle read consistency?
What are the uses of linked server and explain it in detail?
where the dff data will be stored