| |
Question :: Give one method for transferring a table from one schema to another.
|
|
|
|
View Answer
|
|
Question :: What is the purpose of the IMPORT option IGNORE? What is it?s default
setting?
|
|
|
|
View Answer
|
|
Question :: 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
|
|
Question :: 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
|
|
Question :: What are some of the Oracle provided packages that DBAs should be aware of?
|
|
|
|
View Answer
|
|
Question :: What happens if the constraint name is left out of a constraint clause?
|
|
|
|
View Answer
|
|
Question :: What happens if a tablespace clause is left off of a primary key constraint
clause?
|
|
|
|
View Answer
|
|
Question :: What is the proper method for disabling and re-enabling a primary key
constraint?
|
|
|
|
View Answer
|
|
Question :: What happens if a primary key constraint is disabled and then enabled
without fully specifying the index clause?
|
|
|
|
View Answer
|
|
Question :: (On UNIX) When should more than one DB writer process be used? How many
should be used?
|
|
|
|
View Answer
|
|
Question :: 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
|
|
Question :: What causes the "snapshot too old" error? How can this be prevented or
mitigated?
|
|
|
|
View Answer
|
|
Question :: How can you tell if a database object is invalid?
|
|
|
|
View Answer
|
|
Question :: 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
|
|
Question :: A developer is trying to create a view and the database won?t let him. He
has the "DEVELOPER" role which has the "CREATE VIEW" system privilege and
SELECT grants on the tables he is using, what is the problem?
|
|
|
|
View Answer
|
|
Question :: If you have an example table, what is the best way to get sizing data for
the production table implementation?
|
|
|
|
View Answer
|
|
Question :: How can you find out how many users are currently logged into the
database? How can you find their operating system id?
|
|
|
|
View Answer
|
|
Question :: A user selects from a sequence and gets back two values, his select is:
SELECT pk_seq.nextval FROM dual; What is the problem?
|
|
|
|
View Answer
|
|