Oracle General (1803)
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)
What is a subquery in oracle?
Mention in rac what files should be created on shared storage?
Explain rename?
You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?
You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?
What is oracle forms system.currentblock?
Can the query output be sorted by multiple columns in oracle?
Explain integrity constraints?
Mention what are the main components of an oracle rac system?
Oracle
What is db_recovery_file_dest in oracle? When do you need to set this value?
What is connection pooling in oracle?
What is path setting for dll?
What are materialized views & where do we use them? What is a materialized view?
Mention what are the file storage options provided by oracle database for oracle rac?