EXAMEN ORACLE CERTIFIED ASSOCIATE 1Z0-071

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Analyze the description of the SALES1 table that follows SALES2 table has the same description than SALES1. 


In both tables are included some duplicated sales data. 


In order to display the SALES1 table rows which are not included in the SALES2 table, 


which set operator would generate the required output?

EXAMEN-147

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Analyze the description of the BOOKS_TRANSACTIONS table that follows: 


Evaluate the following partial SQL statement: 


►SELECT * FROM books_transactions Which of the following WHERE conditions will produce the same outcome? (Select two.)

EXAMEN-148

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Which from the following statements are true regarding a self join? (Select two.)

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

There must be an index in the join key column.

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Evaluate the following SQL statements knowing they executed successfully: 


Which of the following statements would be correct after execution? (Select two.)

IMAGEN-200

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Evaluate the schema information below: 


1. EMP_VIEW is based on the DEPARTMENTS and EMPLOYEES tables. 


2. EMP_VIEW has columns EMPLOYEE_NAME, EMPLOYEE_ID and DEPARTMENT_NAME. 


3. EMPLOYEES.DEPARTMENT_ID has a foreign key referencing DEPARTMENTS.DEPARTMENT_ID. 


You wanto to add a new column, MANAGER_ID, from the EMPLOYEES table, to the view, showing each employee's manager. 


With which of the following statements the desired result will be obtained?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Evaluate the description of the EMPLOYEES table: A


nalyze these six requirements: 


Sort the results by the HIRE_DATE column. Display the last name, date of hire and the number of years of service for each employee.


 If the employee has been employed 5 or more years but less than 10, display "5+ years of service". 


If the employee has been employed 10 or more years but less than 15, display "10+ years of service".


 If the employee has been employed 15 or more years, display "15+ years of service". 


If none of these conditions matches, display "<5 years of service". 


Which of the following statements will satisfy all the requirements above?

EXAMEN-151

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Choose two of the following statements that are true regarding the usage of constraints.

 

 

.

¿Hay algún error o Mejora?

por favor, responda a todas las preguntas

RESPUESTAS CORRECTAS

4

RESPUESTAS INCORRECTAS

4

 

 

 

 

.

CARGANDO