EXAMEN ORACLE CERTIFIED ASSOCIATE 1Z0-061

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

The STUDENT_GRADES table contains the following columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4, 3) 


The registrar has requested a report that lists the students' grade point averages (GPA) sorted in descending order. 


Which statement would produce a report that satisfy the request?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

The EMPLOYEES table contains the following columns: 


► EMPLOYEE_ID NUMBER(4) ENAME VARCHAR2 (25) JOB_ID VARCHAR2(10) Which of the following SQL statements would return, for those employees whose ENAME ends with a letter "n", their ENAME, length of the ENAME, and numeric position of the letter "a" in the ENAME column?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Examine the SQL statement below: 

► SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; 


Which values would be displayed?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Which statement is true regarding the WITH GRANT OPTION clause?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

You own a table called EMPLOYEES with the following structure: 


► EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE The following statement is issued: 


► DELETE employees; 


What would result from the execution of this DELETE statement?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

The following SQL statement is issued:


 ► SELECT cust_id, cust_last_name "Last Name" FROM customers WHERE country_id = 10 UNION SELECT cust_id CUST_NO, cust_last_name FROM customers WHERE country_id = 30; 


Which ORDER BY clauses would be valid for the issued query? (Select all applicable.)

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Which of the following statemens is true regarding sequences?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Which of the following options is a valid CREATE TABLE statement?

 

 

.

¿Hay algún error o Mejora?

por favor, responda a todas las preguntas

RESPUESTAS CORRECTAS

4

RESPUESTAS INCORRECTAS

4

 

 

 

 

.

CARGANDO