|
Related Questions |
View Answer |
|
What are advantages of using SPFILE over PFILE ?
|
View Answer
|
|
What is System Change Number (SCN)?
|
View Answer
|
|
Difference between SGA and PGA ?
|
View Answer
|
|
What are the components of SGA?
|
View Answer
|
|
How can you determine if an index needs to be dropped and rebuilt?
|
View Answer
|
|
A user selects from a sequence and gets back two values, his select is?
|
View Answer
|
|
How can you find out how many users are currently logged into the database? How can you find their operating system id?
|
View Answer
|
|
If you have an example table, what is the best way to get sizing data for the production table implementation?
|
View Answer
|
|
A user is getting an ORA-00942 error yet you know you have granted them permission on the table, what else should you check?
|
View Answer
|
|
How can you tell if a database object is invalid?
|
View Answer
|
|
What causes the "snapshot too old" error? How can this be prevented or mitigated?
|
View Answer
|
|
You are using hot backup without being in archivelog mode, can you recover in the event of a failure? Why or why not?
|
View Answer
|
|
When should more than one DB writer process be used? How many should be used?
|
View Answer
|
|
What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
|
View Answer
|
|
What is the proper method for disabling and re-enabling a primary key constraint?
|
View Answer
|
|
What happens if a tablespace clause is left off of a primary key constraint clause?
|
View Answer
|
|
What happens if the constraint name is left out of a constraint clause?
|
View Answer
|
|
What are some of the Oracle provided packages that DBAs should be aware of?
|
View Answer
|
|
If the DEFAULT and TEMPORARY tablespace clauses are left out of a CREATE USER command what happens? Is this bad or good? Why?
|
View Answer
|
|
You have a rollback segment in a version 7.2 database that has expanded beyond optimal, how can it be restored to optimal?
|
View Answer
|