EXAMEN ORACLE CERTIFIED ASSOCIATE 1Z0-061

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Which of the following statements is true regarding Enterprise Manager (EM) express in Oracle Database 12c?

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 the WHERE and HAVING clauses? (Select two.)

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Examine this statement: “Top N analysis requires _____ and _____.” 


Which phrases would you use to fill in the blanks with? (Select two.)

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Analyze the structure and data of the CUST TRANS table that follows: CUST TRANS CUSTNO NOT NULL CHAR(2) TRANSDATE DATE TRANSAMT NUMBER(6.2) 11 01-JAN-07 1000 22 01-FEB-07 2000 33 01-MAR-07 3000 In the CUST TRANS table, dates are stored in the default date format dd-mon-rr. 


Which of the following SQL statements would be successfully executed? (Select three.)

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Evaluate the structure of the EMP_DEPT_VU view below: 


Which of the following SQL statements would produce an error?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Analyze the following description of an EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) 


Which statement would return the number of different departments that have employees with last name Smith?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

You have to produce a report for mailing labels for all customers. 


The mailing label must include only the customer name and address. 


The CUSTOMERS table has these columns: 


CUST_ID. NUMBER(4). 


NOT NULL CUST_NAME. VARCHAR2(100). 


NOT NULL CUST_ADDRESS. VARCHAR2(150) 


CUST_PHONE. VARCHAR2(20) 


Which SELECT statement would accurately complete the task?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Which of the following statements are true about the USING clause in table joins?(Select two.)

 

 

.

¿Hay algún error o Mejora?

por favor, responda a todas las preguntas

RESPUESTAS CORRECTAS

4

RESPUESTAS INCORRECTAS

4

 

 

 

 

.

CARGANDO