-
Oracle admin Scenario based question
I have applied the following commands:Shutdown abortstartupNow what will happen, will the database will give an error / it will work.
-
Export query question
exp userid=system/manager file=expfile.dmp log=expfile.log full=Y compress=Y buffer=1000000If i do't mention compress & buffer parameter , then this query will run/not.
-
Oracle Snapshot too old error
What is Ora1555 error. Snapshot too Old error. Explain in detail.
-
Oracle Compress Parameter
My database size is 100GB. I am using compress parameter. Will my database size reduce, remain same, Increase. What will Happen.
-
check database state using pfile/spfile.
How to check whether database whether it is opened by pfile/spfile.
-
Difference between 9i OEM & 10G OEM.
Explain the differences between 9i OEM & 10G OEM along with new features that changes the way you do your daily job
-
Unix & Aix
Unix & Aix what's the difference between the two.
-
Db_buffercache tuning
Db_buffercache : How we will tune it.
-
Oracle Table space used and unused space
I have to check used space/unused space in table space. Which view /command will provide me the desired answer.
-
Oracle DB Buffer Cache
How the data is processed in DB Buffer Cache.
-
changes in Database buffer cache
What are the changes that happen in Database buffer cache(List of all changes in DB Buffer Cache)
-
Oracle table space Quota and users
How to create User in Oracle, allocate quota on Oracle table space
-
SARS Command
Explain SARS Command
-
Oracle Backsets created by RMAN
Can you use Backsets created by RMAN with any other utility
-
-
Online backup of a Control File
Can you take online backup of a Control File If yes, How?
-
-
-
Oratab file
What is stored in Oratab file
-
Remove Oracle memory segments
how do you remove memory segments
-
setting kernel parameters
How to set kernel parameters in Red Hat Linux, AIX, & Solaris.
-
Oracle segments
How do you see how many memory segments are acquired by Oracle Instance.
-
Oracle memory segments
How do you see how many memory segments are acquired by Oracle Instance.
-
DISM in Solaris
What is DISM in Solaris
-
Oracle OERR Utility
What is OERR Utility
-
Oracle maximum data files limit
How many max datafiles can there be in an Oracle Database.
-
Oracle Datafiles limit
How do you control No. of Datafiles one can have in an Oracle Database.
-
Export Query
How to write script for export backup in shell.
-
Determine Number of Blocks Corrupted
You have a database. You have a datafile and some blocks are corrupted in the datafile. What statement will you issue to know how many blocks are corrupted?
-
Standby Databases
What is standby databases? Difference between Physical and logical standby databases
-
Flash Back Query
What is a flash back query? This feature is also available in 9i. whats the difference between 9i and 10g (related to flash back query).
-
Instance of Database Problem
Tell me any instance when your database encountered any problem. How you dealt with that problem.
-
Overcome Alert Log Error
Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.
-
Properties of Database Isolation
Describe four properties of database isolation. In which situation lock contention will happen. What is transaction lock?
-
Disk (sort) Ratio
The ratio of disk (sort) is high. Is that good or bad? Why? How will you reduce disk sort?
-
Simple and Advance Replication
What is simple replication and advance replication? What is the difference between simple replication and advance replication? How can we do simple replication?
-
DBMS_meta_data Parameter
DBMS_meta_data. This parameter is very usefull. What you infer from this parameter. What info you will find in that. explain in detail.
-
SGA_target and SGA_maxsize
What is the difference between SGA_target and SGA_maxsize?
-
Failover and Switchover Server
What is the difference between Failover and Switchover Server?
-
Cache Fusion Technology
What is Cache Fusion Technology?
-
Physical and Logical Backup
What kind of backup you take Physical / Logical? Which one is better and Why?
-
Datafile Size
What is your datafile size? How long it can go? What is the max limit to which you can extend?
-
Compression Parameter
You have a database of 2GB. Can you convert the database to 1GB. Which compression parameter will you use?
-
Oracle Reserved Memory and Unreserved Memory
What is Oracle Reserved Memory and Unreserved Memory? What is the size of Oracle Reserved Memory?
-
Link Server
What is a Link Server?
-
Set theory linked to DBMS
How is set theory linked to DBMS (Union, intersection, minus, logical)
-
Limit and Default size of Tablespace
Can we create as many tablespace as we require. What is the limit? What is the default size of tablespace? (System and User tablespace). Mention name of some tablespace.
-
DBMS Relation
In DBMS, What is a relation?
-
Meta Links
What are Meta Links? Describe in detail
-
A day as a DBA
How you spend a day as a DBA. Explain DBA activities in detail.
-
Cost Based Optimizer and Rule Based Optimizer
What is the difference between Cost Based Optimizer and Rule Based Optimizer?(CBO is the default optimizer)
-
Types of Backup
What are different types of backup? (Hot, Cold, logical, Physical) Explain in detail.
-