|
Question |
Rating |
View Answer |
|
What is a View ? |
|
View Answer |
|
What is Table ? |
|
View Answer |
|
What are the advantages of views? |
|
View Answer |
|
What is a Tablespace? |
|
View Answer |
|
How to define Data Block size ? |
|
View Answer |
|
What does a Control file Contain ? |
|
View Answer |
|
What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ? |
|
View Answer |
|
How does one create a new database? (for DBA) |
|
View Answer |
|
How does one coalesce free space ? |
|
View Answer |
|
How does one prevent tablespace fragmentation? |
|
View Answer |
|
What is COST-based approach to optimization ? |
|
View Answer |
|
How are extents allocated to a segment? |
|
View Answer |
|
Can one rename a database user (schema)? |
|
View Answer |
|
What is a deadlock ? Explain . |
|
View Answer |
|
What are the basic element of Base configuration of an oracle Database ? |
|
View Answer |
|
What is an Index ? How it is implemented in Oracle Database ? |
|
View Answer |
|
What is a Database instance ? Explain |
|
View Answer |
|
What are the system resources that can be controlled through Profile ? |
|
View Answer |
|
What are the database administrators utilities available ? |
|
View Answer |
|
What are roles? How can we implement roles ? |
|
View Answer |