EXAMEN ORACLE CERTIFIED ASSOCIATE 1Z0-061

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Analyze the structure of the following orders table: In order to obtain the total value of all the orders for each year, you issued the following statement: 

>SELECT TO_CHAR (order_date, ‘rr’), SUM (order_total) FROM orders GROUP BY TO_CHAR (order_date, ‘yyyy’); 


Which of the following statements is true about the outcome?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Examine the structure and data of the CUST_TRANS table that follows: Dates in the CUST_TRANS table are stored by default in the date format dd-mm-rr. 


Which of the following SQL statements will execute successfully? (Select three.)

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Which of the following statements are true regarding constraints? (Select two.)

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

The following Exhibit shows the data in the CUST_NAME column of the customers table. 


Customers' second names need to be displayed if the second name starts with "Mc" or "MC." 


Which of the following queries will produce the required output?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Examine the following SQL statement: 

SQL >TRUNCATE TABLE DEPT; 


Which of the following options are true regarding the above SQL statement? (Select three.)

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

In the following Exhibit, examine the structure of the employees table: Between EMPLOYEE_ID and MANAGER_ID, there is a parent/child relationship. 


For all employees, you have to display the name, joining date, and manager. 


There is no department or manager yet assigned to newly hired employees; for them, the manager column should display the value 'No Manager1. 


Which of the following SQL queries produces the required output?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

In the Exhibit below, examine the structure of the employees table. 


In order to display the minimum and maximum salaries of employees hired 1 year ago, 


which of the following statements would produce the correct output? (Select two.)

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

In order to alter the country column in the departments table, you issued the following command: 

> ALTER TABLE departments MODIFY (country DEFAULT ‘USA’); 


Which of the following statements is true regarding the above command?

 

 

.

¿Hay algún error o Mejora?

por favor, responda a todas las preguntas

RESPUESTAS CORRECTAS

4

RESPUESTAS INCORRECTAS

4

 

 

 

 

.

CARGANDO