oracle

Olá pessoal!

Este é o primeiro post de uma série de várias questões importantes para avaliar seu nível de conhecimento. Muito útil principalmente para quem está iniciando carreira como DBA e pretende se candidatar a vagas de DBA Oracle no mercado.

Se você não tem fluência em inglês, a primeira dica é melhorar seu inglês para conseguir pelo menos ler, entender e responder as questões abaixo. Um profissional que deseja ser DBA e não tem um mínimo de inglês com certeza terá dificuldades enormes tanto pra conseguir um emprego quanto para trabalhar efetivamente. Por isso as questões abaixo estão todas em inglês.

Colocarei as respostas em outro post, para você leitor não “colar”, mesmo que seja sem querer!

  1. Give Methods of transferring a table from one schema to another.
  1. What is the purpose of the IMPORT option IGNORE? What is the default setting?
  1. You have a rollback segment in Oracle8 database that has expanded beyond optimal. How can it be restored to optimal.
  1. If the DEFAULT and TEMPORARY tablespace clauses are left out of the create user statement in Oracle8i what happens? Is this good or bad? Why?
  1. What are the some of the Oracle provided packages that DBA should be aware of?
  1. What happens if constraint name is left out of the constraint clause?
  1. What happens if a tablespace clause is left off a primary key constraint clause?
  1. What is the proper method for disabling and re-enabling a primary key constraint?
  1. What happens if a primary key constraint is disabled and then re-enabled without specifying the index clause?
  1. When should more than one DB writer be used? How many?
  1. You are using a hot backup without being in ARCHIVELOG mode. Can you recover in the event of failure? Why not?
  1. What causes the “Snapshot too old error”? How can this be prevented or mitigated?
  1. How can you tell if a database object is invalid?
  1. If a user gets the ORA-00942 error, yet you know you granted them the privilege, what else should you check?
  1. A developer is trying to create a view but the database will not let him. He has the DEVELOPER role which has the CREATE VIEW system privilege and the selects on the table he is using. What is the problem?
  1. If you are using an example table what is the best way to get sizing data for the production table implementation?
  1. How can you tell how many users are currently logged into the database? How can you find their system ID?
  1. The user selects from a sequence and gets back 2 values, his select is SELECT pk_seq.nextval FROM dual; What is the problem?
  1. How do you determine if an index has to be dropped or rebuilt?

Para conferir as respostas, clique AQUI.

Milton Bastos é DBA Oracle e Desenvolvedor PL/SQL, dividido entre Apucarana/PR e Curitiba/PR. Certificações: OCA (Oracle 11g DBA Certified Associate), Oracle Database 11g Data Warehousing Certified Implementation Specialist, Oracle Database 11g Sales Specialist Assessment, Oracle Database Appliance PreSales Specialist Assessment, Oracle Database Appliance Sales Specialist Assessment