Why is a UNION ALL faster than a UNION?
What are some advantages to using Oracle’s CREATE DATABASE statement to create a new database manually?
What are three rules of thumb to create good passwords? How would a DBA enforce those rules in Oracle? What business challenges might you encounter?
Describe the Oracle Wait Interface, how it works, and what it provides. What are some limitations? What do the db_file_sequential_read and db_file_scattered_read events indicate?
How do you return the top-N results of a query in Oracle? Why doesn’t the obvious method work?
Can Oracle’s Data Guard be used on Standard Edition, and if so how? How can you test that the standby database is in sync?
What is a database link? What is the difference between a public and a private database link? What is a fixed user database link?
Explain what are Oracle Catalog and Oracle Archive log?
What is dump destination? What are bdump, cdump and udump? Explain in detail. ?
What are four errors found in an alert (error) log that can ruin a DBA's appetite and how can you avoid them?
What will you do if in any condition you do not know how to troubleshoot the error at all and there are no seniors or your co-workers around?
What are the different scenarios for rebuilding indexes... ?
How to convert local management tablespace to dictionary managed tablespace?
As a Oracle DBA what are all the UNIX file you should be familar with?
When the developer trying to compile the package. But the database gets hanged? What will you check?
When yesterday developer gives the following command: select count(*) from [table name]it gives the output within minutes, today the same command takes hours? What will you check?
How will you rectify if one of the rollback segments gets corrupted ?
When exporting using filesize parameter, if three files is generated. How the Oracle name this three files?
When you execute: alter tablespace begin backup; How can Oracle engine can identify that the corresponding datafiles are in backupmode?
What are the differences between database designing and database modeling?
In which situation whether peak time or off peak time you will execute the ANALYZE TABLE command. Why?
How to check to memory gap once the SGA is started in Restricted mode?
If the SQL * Plus hangs for a long time, what is the reason?
How do you increase the performance of %LIKE operator?
What is mutated trigger?
How to estimate the size of SGA?
What do you do when the server cannot start due to a corrupt master database?
Explain how will you setup Replication Server & sync it?
How to load data into multiple tables at once?
What should you do when you find a stacktrace in the server errorlog?
Is it possible to resize tablespaces and data files? If yes, how?
How does one use the import/export utilities?
What tuning indicators can one use?
Why and how the deadlock situation arises?
Why use materialized view instead of a table?
Difference between 9i OEM & 10G OEM.?
How the data is processed in DB Buffer Cache. ?
What are the changes that happen in Database buffer cache(List of all changes in DB Buffer Cache) ?
Why do you take tablespaces in backup mode.?
What is stored in Oratab file ?
What is OERR Utility ?
How many max datafiles can there be in an Oracle Database. ?
How do you see how many memory segments are acquired by Oracle Instance. ?
How many max datafiles can there be in an Oracle Database.?
How do you control No. of Datafiles one can have in an Oracle Database. ?
How to write script for export backup in shell. ?
What is standby databases? Difference between Physical and logical standby databases ?
Describe four properties of database isolation. In which situation lock contention will happen. What is transaction lock?
What is simple replication and advance replication? What is the difference between simple replication and advance replication? How can we do simple replication?
What is Cache Fusion Technology?
What kind of backup you take Physical / Logical? Which one is better and Why?
What is Oracle Reserved Memory and Unreserved Memory?
How you spend a day as a DBA. Explain DBA activities in detail. ?
While Installing Oracle9i/10g at unix (RedHat) environment , which parameter needs to be set at OS level, to login as a sysdba in Oracle for the first time?
What is the difference between Cloning and Standby databases?
What are the fixed memory structures inside the SGA?
Is VARCHAR2 size optimization worthwhile ?
How to manager Memory in Oracle Database? How to maximize nos. of user in Oracle Database?
How to find which tablespace belongs to which datafile ?
What is difference between base table and data dictionary views?
Explain about Oracle Statistics parameter in export?
What is directory naming in oracle9i ?
What is the difference between Pctused and PctFree?
What is the difference between local managed tablespace & dictionary managed tablespace ?
Database Auto extend question?
How can the problem be resolved if a SYSDBA, forgets his password for logging into enterprise manager?
How to handle data curreption for ASM type files?
When a database is started, Which file is accessed first?
What is difference between latch,locks and enqueue ?
What is the difference between materialized view and snapshots?
What is RAP?
What is RAC? What is Data Migration? What is Data Pumping?
How to estimate size of database?
What is the difference between .ora and net file or .ora and .net or tnsnames.ora sqlnet.ora listener.ora?
How to Estimate the size of Tablespace???
How to query to know the structure of a single Database and from more than one database.?
Where does the SCN resides (system change number)?
How to know which query is taking long time?
How do sql statement processing oracle database?
What is ORA-1555?
What is the database holding Capacity of Oracle ?
What are the diffrent file types that are supported by SQL*Loader?
How to find how many database reside in Oracle server in query?
How many memory layers are in the shared pool?
Where we use bitmap index ?
What is an extent?
What are the components of physical database structure of Oracle database?
What are the components of logical database structure of Oracle database?
Can you name few DBMS packages and their use?
How can be determine the size of the log files.?
How can be determine the size of the database?
How can you check which user has which Role.?
Can you start a database without SPfile in oracle 9i?
What is Oracle table?
What is an Oracle index?
Can we create index on long raw column?
What are the basic element of base configuration of an Oracle database?
What are clusters?
What is the function of redo log?
What are the characteristics of data files?
What is a temporary segment?
What are the uses of rollback segment?
What process writes from data files to buffer cache?
What is a redo log?
Name init.ora parameters which effects system performance.?
What is a database instance and Explain?
What are the Advantages of Using DBCA?
How do you find wheather the instance was started with pfile or spfile ?
What is an index segment?
What is public database link?
What is rollback segment?
What is a data segment?
What is network database link?
What is private database link?
What are the types of database links?
When can hash cluster used?
What is cluster key?
What is a private synonym?
What is a private synonym?
What are the advantages of views?
What is an Oracle view?
What is SYSTEM tablespace and when is it created?
What is a tablespace?
What is database link?
What is a segment?
What is row chaining?
What is an index and How it is implemented in Oracle database?
What is a schema?
What does a control file contains?
How to define data block size?
What is hash cluster?
What is index cluster?
What are clusters?
How are the index updates?
What is a public synonym?
What is a synonym?
What is an Oracle sequence?
What is a latch?
What is difference between Logical Standby Database and Physical Standby database?
Waht is the frequency of log Updated?
How do you pin an object?
How do you rename a database?
What is the use of redo log information?
What is the correct sequence among FETCH, EXECUTE, And PARSE?
Which process writes data from data files to database buffer cache?
What are memory structures in Oracle?
What is a datafile?
What is data block?
What are synonyms used for?
What does database do during mounting process?
What is Parallel Server ?
What is a Schema ?
What is an Index ? How it is implemented in Oracle Database ?
What is clusters ?
What is a cluster Key ?
What are the basic element of Base configuration of an oracle Database ?
What is a deadlock ? Explain ?
What is a deadlock and Explain?
What are some advantages to using Oracle’s CREATE DATABASE statement to create a new database manually?
What are three rules of thumb to create good passwords? How would a DBA enforce those rules in Oracle? What business challenges might you encounter?
Describe the Oracle Wait Interface, how it works, and what it provides. What are some limitations? What do the db_file_sequential_read and db_file_scattered_read events indicate?
How do you return the top-N results of a query in Oracle? Why doesn’t the obvious method work?
Can Oracle’s Data Guard be used on Standard Edition, and if so how? How can you test that the standby database is in sync?
What is a database link? What is the difference between a public and a private database link? What is a fixed user database link?
Explain what are Oracle Catalog and Oracle Archive log?
What is dump destination? What are bdump, cdump and udump? Explain in detail. ?
What are four errors found in an alert (error) log that can ruin a DBA's appetite and how can you avoid them?
What will you do if in any condition you do not know how to troubleshoot the error at all and there are no seniors or your co-workers around?
What are the different scenarios for rebuilding indexes... ?
How to convert local management tablespace to dictionary managed tablespace?
As a Oracle DBA what are all the UNIX file you should be familar with?
When the developer trying to compile the package. But the database gets hanged? What will you check?
When yesterday developer gives the following command: select count(*) from [table name]it gives the output within minutes, today the same command takes hours? What will you check?
How will you rectify if one of the rollback segments gets corrupted ?
When exporting using filesize parameter, if three files is generated. How the Oracle name this three files?
When you execute: alter tablespace begin backup; How can Oracle engine can identify that the corresponding datafiles are in backupmode?
What are the differences between database designing and database modeling?
In which situation whether peak time or off peak time you will execute the ANALYZE TABLE command. Why?
How to check to memory gap once the SGA is started in Restricted mode?
If the SQL * Plus hangs for a long time, what is the reason?
How do you increase the performance of %LIKE operator?
What is mutated trigger?
How to estimate the size of SGA?
What do you do when the server cannot start due to a corrupt master database?
Explain how will you setup Replication Server & sync it?
How to load data into multiple tables at once?
What should you do when you find a stacktrace in the server errorlog?
Is it possible to resize tablespaces and data files? If yes, how?
How does one use the import/export utilities?
What tuning indicators can one use?
Why and how the deadlock situation arises?
Why use materialized view instead of a table?
Difference between 9i OEM & 10G OEM.?
How the data is processed in DB Buffer Cache. ?
What are the changes that happen in Database buffer cache(List of all changes in DB Buffer Cache) ?
Why do you take tablespaces in backup mode.?
What is stored in Oratab file ?
What is OERR Utility ?
How many max datafiles can there be in an Oracle Database. ?
How do you see how many memory segments are acquired by Oracle Instance. ?
How many max datafiles can there be in an Oracle Database.?
How do you control No. of Datafiles one can have in an Oracle Database. ?
How to write script for export backup in shell. ?
What is standby databases? Difference between Physical and logical standby databases ?
Describe four properties of database isolation. In which situation lock contention will happen. What is transaction lock?
What is simple replication and advance replication? What is the difference between simple replication and advance replication? How can we do simple replication?
What is Cache Fusion Technology?
What kind of backup you take Physical / Logical? Which one is better and Why?
What is Oracle Reserved Memory and Unreserved Memory?
How you spend a day as a DBA. Explain DBA activities in detail. ?
While Installing Oracle9i/10g at unix (RedHat) environment , which parameter needs to be set at OS level, to login as a sysdba in Oracle for the first time?
What is the difference between Cloning and Standby databases?
What are the fixed memory structures inside the SGA?
Is VARCHAR2 size optimization worthwhile ?
How to manager Memory in Oracle Database? How to maximize nos. of user in Oracle Database?
How to find which tablespace belongs to which datafile ?
What is difference between base table and data dictionary views?
Explain about Oracle Statistics parameter in export?
What is directory naming in oracle9i ?
What is the difference between Pctused and PctFree?
What is the difference between local managed tablespace & dictionary managed tablespace ?
Database Auto extend question?
How can the problem be resolved if a SYSDBA, forgets his password for logging into enterprise manager?
How to handle data curreption for ASM type files?
When a database is started, Which file is accessed first?
What is difference between latch,locks and enqueue ?
What is the difference between materialized view and snapshots?
What is RAP?
What is RAC? What is Data Migration? What is Data Pumping?
How to estimate size of database?
What is the difference between .ora and net file or .ora and .net or tnsnames.ora sqlnet.ora listener.ora?
How to Estimate the size of Tablespace???
How to query to know the structure of a single Database and from more than one database.?
Where does the SCN resides (system change number)?
How to know which query is taking long time?
How do sql statement processing oracle database?
What is ORA-1555?
What is the database holding Capacity of Oracle ?
What are the diffrent file types that are supported by SQL*Loader?
How to find how many database reside in Oracle server in query?
How many memory layers are in the shared pool?
Where we use bitmap index ?
What is an extent?
What are the components of physical database structure of Oracle database?
What are the components of logical database structure of Oracle database?
Can you name few DBMS packages and their use?
How can be determine the size of the log files.?
How can be determine the size of the database?
How can you check which user has which Role.?
Can you start a database without SPfile in oracle 9i?
What is Oracle table?
What is an Oracle index?
Can we create index on long raw column?
What are the basic element of base configuration of an Oracle database?
What are clusters?
What is the function of redo log?
What are the characteristics of data files?
What is a temporary segment?
What are the uses of rollback segment?
What process writes from data files to buffer cache?
What is a redo log?
Name init.ora parameters which effects system performance.?
What is a database instance and Explain?
What are the Advantages of Using DBCA?
How do you find wheather the instance was started with pfile or spfile ?
What is an index segment?
What is public database link?
What is rollback segment?
What is a data segment?
What is network database link?
What is private database link?
What are the types of database links?
When can hash cluster used?
What is cluster key?
What is a private synonym?
What is a private synonym?
What are the advantages of views?
What is an Oracle view?
What is SYSTEM tablespace and when is it created?
What is a tablespace?
What is database link?
What is a segment?
What is row chaining?
What is an index and How it is implemented in Oracle database?
What is a schema?
What does a control file contains?
How to define data block size?
What is hash cluster?
What is index cluster?
What are clusters?
How are the index updates?
What is a public synonym?
What is a synonym?
What is an Oracle sequence?
What is a latch?
What is difference between Logical Standby Database and Physical Standby database?
Waht is the frequency of log Updated?
How do you pin an object?
How do you rename a database?
What is the use of redo log information?
What is the correct sequence among FETCH, EXECUTE, And PARSE?
Which process writes data from data files to database buffer cache?
What are memory structures in Oracle?
What is a datafile?
What is data block?
What are synonyms used for?
What does database do during mounting process?
What is Parallel Server ?
What is a Schema ?
What is an Index ? How it is implemented in Oracle Database ?
What is clusters ?
What is a cluster Key ?
What are the basic element of Base configuration of an oracle Database ?
What is a deadlock ? Explain ?
What is a deadlock and Explain?
No comments:
Post a Comment