EXAMEN ORACLE CERTIFIED ASSOCIATE 1Z0-062

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: 

$> sqlldr hr/hr@pdb table=employees 


Which two statements are true regarding the command? (Choose two.)

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows: 



After changing the value, you notice that FULL redaction continues to redact numeric data with zero. 


What must you do to activate the new default value for numeric full redaction?

EXAMEN-18

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

You are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. 


The table does not have a primary key and is used by an OLTP application. 


Which technique will move the table and indexes while maintaining the highest level of availability to the application?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

To implement Automatic Management (AMM), you set the following parameters: 


When you try to start the database instance with these parameter settings, you receive the following error message: 


SQL > startup ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information. 


Identify the reason the instance failed to start.

EXAMEN-20

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

You upgrade your Oracle database in a multiprocessor environment. 


As a recommended you execute the following script: 

SQL > @utlrp.sql 


Which two actions does the script perform? (Choose two.)

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. 


After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed. 


Identify three possible reasons for this. (Choose three.)

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges? (Choose three.)

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

You notice a performance change in your production Oracle 12c database. 


You want to know which change caused this performance difference. 


Which method or feature should you use?

 

 

.

¿Hay algún error o Mejora?

por favor, responda a todas las preguntas

RESPUESTAS CORRECTAS

4

RESPUESTAS INCORRECTAS

4

 

 

 

 

.

CARGANDO