:: Home     :: Add Questions
Register   |   Login
 

DBA Interview Questions & FAQs

 

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
::Top Tags::
 
 
Copyright 2007, Megasolutions Ltd