top of page

EXAMEN ORACLE CERTIFIED ASSOCIATE 1Z0-062

PREGUNTA

LAS OPCIONES CORRECTAS SON:

.

.

In your database, USERS is the default permanent tablespace. Examine the commands and their outcome (TABLE-1): 


You plan to execute the commands (TABLE-2): 


Which two statements are true? (Choose two.)

EXAMEN-113

PREGUNTA

LAS OPCIONES CORRECTAS SON:

.

.

You use multiple temporary tables frequently in your database. 


Which two are benefits of configuring temporary undo? (Choose two.)

PREGUNTA

LAS OPCIONES CORRECTAS SON:

.

.

Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?

PREGUNTA

LAS OPCIONES CORRECTAS SON:

.

.

You want to create a role that: 

- is protected from unauthorized usage 


- does not use a password embedded in the application source code or stored in a table 


- is enabled for a user based on security policies defined in a PL/SQL package 


How would you create this role?

PREGUNTA

LAS OPCIONES CORRECTAS SON:

.

.

Your database instance is started by using a server parameter file (SPFILE). 


You execute the following command to change the value of the LOG_BUFFER initialization parameter: 


ALTER SYSTEM SET LOG_BUFFER=32M; What is the outcome of this command?

PREGUNTA

LAS OPCIONES CORRECTAS SON:

.

.

You want to create a database and you have the following: 

- Oracle Grid Infrastructure is installed and configured. 


- Oracle Database Vault is installed in ORACLE_HOME to be used for this database. 


- Oracle Enterprise Manager Cloud Control is available and an agent is deployed on the database server. 


Examine the requirements: 


1. configuring the database instance to support shared server mode 


2. using Automatic Storage Management (ASM) for storing database files. 


3. configuring a naming method to help a remote user connect to a database instance 


4. configuring the Fast Recovery Area 


5. configuring Database Vault 


6. configuring Enterprise Manager (EM) Database Express 7. registering with EM Cloud Control 


8. configuring remote log archive destinations 


9. enabling daily incremental backups 


10. configuring a nondefault block size for nondefault block size tablespaces 


Which of these requirements can be met while creating a database by using the Database Configuration Assistant (DBCA)?

PREGUNTA

LAS OPCIONES CORRECTAS SON:

.

.

Identify two prerequisites for configuring Enterprise Manager Database Express (EM Express). (Choose two.)

PREGUNTA

LAS OPCIONES CORRECTAS SON:

.

.

Your production database PROD uses file system storage. 


You want to migrate storage including the Fast Recovery Area for the PROD database to Oracle Automatic Storage Management (ASM) by using RMAN. 


You back up the entire database. 


What should the next step be in this migration process?

CARGANDO

 

 

.

¿Hay algún error o Mejora?

ENVIAR

por favor, responda a todas las preguntas

RESPUESTAS CORRECTAS

4

RESPUESTAS INCORRECTAS

4

bottom of page