top of page

EXAMEN ORACLE CERTIFIED ASSOCIATE 1Z0-062

PREGUNTA

LAS OPCIONES CORRECTAS SON:

.

.

Which Oracle Database component is audited by default if the unified Auditing option is enabled?

PREGUNTA

LAS OPCIONES CORRECTAS SON:

.

.

Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. 


You find that the SYSAUX tablespace is corrupted in the root container. 


The steps to recover the tablespace are as follows: 

1. Mount the CDB. 


2. Close all the PDBs. 


3. Open the database. 


4. Apply the archive redo logs. 


5. Restore the data file. 


6. Take the SYSAUX tablespace offline. 


7. Place the SYSAUX tablespace online. 


8. Open all the PDBs with RESETLOGS. 


9. Open the database with RESETLOGS. 


10. Execute the command SHUTDOWN ABORT. 


X Which option identifies the correct sequence to recover the SYSAUX tablespace?

PREGUNTA

LAS OPCIONES CORRECTAS SON:

.

.

In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database? 


Both local and global partitioned B-tree Indexes are defined on the table. 


A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends.


 Minimal disrupt ion to availability is required. Which three statements are true about this requirement? (Choose three.)

PREGUNTA

LAS OPCIONES CORRECTAS SON:

.

.

The user SCOTT owns the CUST table that is placed in the SALES tablespace. 


The user SCOTT opens a session and executes commands as follows: 

SQL> INSERT INTO cust VALUES(101, 'JACK'); 1 row created. 


SQL> INSERT INTO cust VALUES(102, 'SMITH'); 1 row created. 


As a DBA, you execute the following command from another session: 

ALTER TABLESPACE sales READ ONLY; 



Which statement is true regarding the effect of this command on the transaction in Scott's session?

PREGUNTA

LAS OPCIONES CORRECTAS SON:

.

.

You plan to implement the distributed database system in your company. 


You invoke Database Configuration Assistant (DBCA) to create a database on the server. During the installation, DBCA prompts you to specify the Global Database Name. 


What must this name be made up of?

PREGUNTA

LAS OPCIONES CORRECTAS SON:

.

.

Which two statements are true about standard database auditing? (Choose two.)

PREGUNTA

LAS OPCIONES CORRECTAS SON:

.

.

You executed the following command to create a password file in the database server: $ orapwd file = orapworcl entries = 5 ignorecase=N 


Which statement describes the purpose of the above password file?

PREGUNTA

LAS OPCIONES CORRECTAS SON:

.

.

Which three statements are true about space usage alerts? (Choose three.)

CARGANDO

 

 

.

¿Hay algún error o Mejora?

ENVIAR

por favor, responda a todas las preguntas

RESPUESTAS CORRECTAS

4

RESPUESTAS INCORRECTAS

4

bottom of page