EXAMEN ORACLE CERTIFIED ASSOCIATE 1Z0-071

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Examine the following queries: 


Which statement is true regarding the above two queries?

EXAMEN-9

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Evaluate the business rule:


 ► Each project can have multiple students and each student can work on multiple projects. 


► You have to design an Entity Relationship (ER) model for optimal data storage and allow it to generate reports in the format: 


► STUDENT_ID FIRST_NAME LAST_NAME PROJECT_ID PROJECT_NAME PROJECT_TASK 


Which from the following statements are true? (Select two.)

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

In the sample below, analyze the details of PRODUCT_INFORMATION table. 


You must have displayed PRODUCT_NAME from the table wherein the CATEGORY_ID column has values 12 or 13, and the SUPPLIER_ID column has the value 102088. You issued the SQL statement: 


► SELECT product_name FROM product_information WHERE (category_id = 12 AND category_id = 13) AND supplier_id = 102088; 


Which from the following statements is true in regards of the query’s execution?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

In your database, it exists the BOOKS_TRANSACTIONS table and you execute this SQL statement: 


>SELECT * FROM books_transactions ORDER BY 3; 


What is the result?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Analyze the structure of the EMPLOYEES table in the sample below. 


You must display all employees and their managers having 100 as the MANAGER_ID, and the output should be displayed in two columns: 


the first column would have the LAST_NAME of the managers and the second, would have LAST_NAME of the employees. 


Which from the following SQL statements would you execute?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Which from the following statements are true about multiple-row subqueries? (Select three.)

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Analyze the following SQL statements that were issued in the given order: ► CREATE TABLE emp (emp_no NUMBER(2) CONSTRAINT emp_emp_no_pk PRIMARY KEY, ename VARCHAR2(15), salary NUMBER (8,2), mgr_no NUMBER(2) CONSTRAINT emp_mgr_fk REFERENCES emp(emp_no)); ► ALTER TABLE emp DISABLE CONSTRAINT emp_emp_no_pk CASCADE; ► ALTER TABLE emp ENABLE CONSTRAINT emp_emp_no_pk; Which statement is correct regarding the status of the foreign key EMP_MGR_PK?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Which from the following statements is true in regards of the ORDER BY clause’s default behavior?

 

 

.

¿Hay algún error o Mejora?

por favor, responda a todas las preguntas

RESPUESTAS CORRECTAS

4

RESPUESTAS INCORRECTAS

4

 

 

 

 

.

CARGANDO