DBA Interview questions 2
What are the components of physical database structure of Oracle database?
What are the components of logical database structure of Oracle database?
What is a tablespace?
What is SYSTEM tablespace and when is it created?
Explain the relationship among database, tablespace and data file.
What is schema?
What are Schema Objects?
Can objects of the same schema reside in different tablespaces?
Can a tablespace hold objects from different schemes?
What is Oracle table?
What is an Oracle view?
What is Partial Backup ?
What is Mirrored on-line Redo Log ?
What is Full Backup ?
Can a View based on another View ?
Can a Tablespace hold objects from different Schemes ?
Can objects of the same Schema reside in different tablespaces.?
What is the use of Control File ?
Do View contain Data ?
What are the Referential actions supported by FOREIGN KEY integrity constraint ?
What are the type of Synonyms?
What is a Redo Log ?
What is an Index Segment ?
Explain the relationship among Database, Tablespace and Data file.?
What are the different type of Segments ?
What are Clusters ?
What is an Integrity Constrains ?
What is an Index ?
What is an Extent ?
What is a View ?
What is Table ?
Can a view based on another view?
What are the advantages of views?
What is an Oracle sequence?
What is a synonym?
What are the types of synonyms?
What is a private synonym?
What is a public synonym?
What are synonyms used for?
What is an Oracle index?
How are the index updates?
What is a Tablespace?
What is Rollback Segment ?
What are the Characteristics of Data Files ?
How to define Data Block size ?
What does a Control file Contain ?
What is difference between UNIQUE constraint and PRIMARY KEY constraint ?
What is Index Cluster ?
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 ?
How does one create a new database? (for DBA)
What database block size should I use? (for DBA)
What are the different approaches used by Optimizer in choosing an execution plan ?
What does ROLLBACK do ?
How does one coalesce free space?(for DBA)
How does one prevent tablespace fragmentation? (for DBA)
Where can one find the high water mark for a table? (for DBA)
What is COST-based approach to optimization ?
What does COMMIT do ?
How are extents allocated to a segment? (for DBA)
Can one rename a database user (schema)? (for DBA)
Define Transaction ?
What is Read-Only Transaction ?
What is a deadlock ? Explain .
What is a Schema ?
What is a cluster Key ?
What is Parallel Server ?
What are the basic element of Base configuration of an oracle Database ?
What is clusters ?
What is an Index ? How it is implemented in Oracle Database ?
What is a Database instance ? Explain
WWhat is the use of ANALYZE command ?
What is default tablespace ?
What are the system resources that can be controlled through Profile ?
What is Tablespace Quota ?
What are the different Levels of Auditing ?
What is Statement Auditing ?
What are the database administrators utilities avaliable ?
How can you enable automatic archiving ?
What are roles? How can we implement roles ?
What are Roles ?
What are the use of Roles ?
What is Privilege Auditing ?
What is Object Auditing ?
What is Auditing ?
How does one see the uptime for a database? (for DBA
Where are my TEMPFILES, I don't see them in V$DATAFILE or DBA_DATA_FILE? (f