Posted by admin on July 31, 2009 under Interviews | 
Can a tablespace hold objects from different schemes?
Can a view based on another view?
Can objects of the same schema reside in different tablespaces?
Can one rename a database user (schema)? (for DBA)
Define Transaction ?
Do View contain Data ?
Explain the relationship among database, tablespace and data file ?
Explain the relationship among Database, Tablespace and Data file?
How are extents allocated to a segment? (for DBA)
How are the index updates?
How can you enable automatic archiving ?
How does one coalesce free space ? (for DBA)
How does one create a new database? (for DBA)
How does one prevent tablespace fragmentation? (for DBA)
How to define Data Block size ?
What are Clusters ?
What are roles? How can we implement roles ?
What are Schema Objects?
What are synonyms used for?
What are the advantages of views?
What are the basic element of Base configuration of an oracle Database ?
What are the Characteristics of Data Files ?
What are the components of logical database structure of Oracle database?
What are the components of physical database structure of Oracle database?
What are the database administrators utilities available ?
What are the different approaches used by Optimizer in choosing an execution plan ?
What are the different Levels of Auditing ?
What are the different type of Segments ?
What are the Referential actions supported by FOREIGN KEY integrity constraint ?
What are the system resources that can be controlled through Profile ?
What are the types of synonyms?
What are the use of Roles ?
What database block size should I use? (for DBA)
What does a Control file Contain ?
What does COMMIT do ?
What does ROLLBACK do ?
What is a cluster Key ?
What is a Database instance ? Explain
What is a deadlock ? Explain .
What is a private synonym?
What is a public synonym?
What is a Redo Log ?
What is a Schema ?
What is a synonym?
What is a tablespace?
What is a Tablespace?
What is a View ?
What is an Extent ?
What is an Index ? How it is implemented in Oracle Database ?
What is an Index Segment ?
What is an Integrity Constrains ?
What is an Oracle index?
What is an Oracle sequence?
What is an Oracle view?
What is Auditing ?
What is clusters ?
What is COST-based approach to optimization ?
What is default tablespace ?
What is difference between UNIQUE constraint and PRIMARY KEY constraint ?
What is Full Backup ?
What is Index Cluster ?
What is Mirrored on-line Redo Log ?
What is Object Auditing ?
What is Oracle table?
What is Parallel Server ?
What is Partial Backup ?
What is Privilege Auditing ?
What is Read-Only Transaction ?
What is Rollback Segment ?
What is schema?
What is Statement Auditing ?
What is SYSTEM tablespace and when is it created?
What is Table ?
What is Tablespace Quota ?
What is the effect of setting the value “ALL_ROWS” for OPTIMIZER_GOAL parameter of the ALTER SESSION command ? What are the factors that affect OPTIMIZER in choosing an Optimization approach ?
What is the effect of setting the value “CHOOSE” for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
What is the use of ANALYZE command ?
What is the use of Control File ?
When does a Transaction end ?
Where can one find the high water mark for a table? (for DBA)
Add A Comment
You must be logged in to post a comment.