Arquivo da categoria: OCP

Oracle Messages ‘Cause and Action’

Oracle Messages ‘Cause and Action’ Note that only error messages with cause and actions go in .msg/.msb files; other information messages stay in the resources of the components concerned and are displayed with a standard AfxMessageBox call, rather than using … Continuar lendo

Publicado em OCE RAC, OCP, ORACLE 11gR2 | Deixe um comentário

1z0 -007

1z0 -007 QUESTION NO: 1 Examine the data in the EMPLOYEES and DEPARTMENTS tables. EMPLOYEES LAST_NAME DEPARTMENT_ID SALARY Getz 10 3000 Davis 20 1500 King 20 2200 Davis 30 5000 Kochhar 5000 DEPARTMENTS DEPARTMENT_ID DEPARTMENT_NAME 10 Sales 20 Marketing 30 … Continuar lendo

Publicado em OCP | Marcado com | Deixe um comentário

1z0-030

Oracle9i: New Features for Administrators QUESTION NO: 1 Examine the code. CREATE ROLE readonly IDENTIFIED USING app.chk_readwrite ; CREATE ROLE readwrite IDENTIFIED USING app.chk_readwrite ; CREATE OR REPLACE PROCEDURE app.chk_readwrite AUTHID CURRENT_USER IS ipchk STRING(30); BEGIN IF says context (‘USERENV’, … Continuar lendo

Publicado em OCP | Marcado com | Deixe um comentário

1z0-040

Oracle Database 10g: New Features for Administrators   QUESTION NO: 1 Which three methods can you use to run an Automatic Database Diagnostic Monitor (ADDM) analysis over a specific time period? (Choose three.) A. Enterprise Manager GUI B. DBMS_TRACE package … Continuar lendo

Publicado em OCP | Marcado com | Deixe um comentário

Questões para prova 1Z0-050 OCP ORACLE 11g NEW FEATURES FOR ADMINSTRATOR

DUMP da prova 1Z0-050 ORACLE 11g NEW FEATURES FOR ADMINSTRATORS 1Z0-050  – 1 Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.) A. The user has dropped an important table that needs to be … Continuar lendo

Publicado em OCP, ORACLE 11gR2, TUTORIAL | Marcado com , , , , , | Deixe um comentário