EXAMEN ORACLE CERTIFIED ASSOCIATE 1Z0-061

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Examine the PRODUCTS and SALES tables in the Exhibit. 


You issued the following query in order to display the product name and the number of times the product has been ordered: 


► SELECT P.PROD_NAME, I.ITEM_CNT FROM (SELECT PROD_ID, COUNT(*) ITEM_CNT FROM SALES GROUP BY PROD_ID) I RIGHT OUTER JOIN PRODUCTS P ON I.PORD_ID = P.PROD_ID; 


Which statement is true regarding the execution of the above query?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Examine the structure of the PRODUCTS table in the Exhibit below. 


Using the PRODUCTS table, you issued the following query in order to display names, current list price and list discounted price for all those products whose list price is below $ 10 after applying a 25% discount. 

> SELECT PROD_NAME, PROD_LIST_PRICE, PROD_LIST_PRICE – (PROD_LIST_PRICE * .25) “DISCOUNTED_PRICE” FROM PRODUCTS WHERE DISCOUNTED_PRICE < 10; 


The query produces an error. 


Which from the following statements explains the error?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Examine the structure in the CUSTOMERS table in the Exhibit below. 


In the new table NEW_CUSTOMERS, the CUST_ID, CUST_NAME y CUST_CITY columns have identical data types and size than the corresponding columns in the CUSTOMERS table. 


Evaluate the following INSERT statement: 


INSERT INTO NEW_CUSTOMERS (CUST_ID, CUST_NAME, CUST_CITY) VALUES (SELECT CUST_ID, CUST_FIRST_NAME ||’ ‘|| CUST_LAST_NAME,CUST_CITY FROM CUSTOMERS WHERE CUST_ID > 23004); 


The statement fails at execution. Which could be the reason for the failure?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Analyze the following SQL statement: 


> SELECT PROMO_ID, PROMO_CATEGORY FROM PROMOTIONS WHERE PROMO_CATEGORY = ‘Internet’ ORDER BY 2 DESC UNION SELECT PROMO_ID, PROMO_CATEGORY FROM PROMOTIONS WHERE PROMO_CATEGORY = ‘TV’ UNION SELECT PROMO_ID, PROMO_CATEGORY FROM PROMOTIONS WHERE PROMO_CATEGORY = ‘Radio’; 


Which from the following statements is true about the result of the above query?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

You need to update the EMPLOYEES table with the following requirements: 


─ Update only those employees who work in Boston or Seattle (locations 2900 and 2700). 


─ Set department_id for these employees to the department_id corresponding to London (location_id 2100) 


─ For employees in location_id 2100, set their salary to 1.1 times the average salary of their department. 


─ For employees in location_id 2100, set their commission to 1.5 times the average commission of their department. 


You issue the following command: 

> UPDATE EMPLOYEES SET DEPARTMENT_ID = (SELECT DEPARTMENT_ID FROM DEPARTMENTS WHERE LOCATION_ID = 2100), SALARY, COMISSION) = (SELECT 1.1*AVG(SALARY), 1.5*AVG(COMMISSION) FROM EMPLOYEES, DEPARTMENTS WHERE DEPARTMENTS.LOCATION_ID IN (2900, 2700, 2100)) WHERE DEPARTMENT_ID IN (SELECT DEPARTMENT_ID FROM DEPARTMENTS WHERE LOCATION_ID = 2900 OR LOCATION_ID = 2700); 


Which will be the result of executing the above command?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Examine the structure of the CUSTOMERS table in the Exhibit. 


You want to generate a report from the CUSTOMERS table, which shows an increment of a 15% in the credit limit for all customers. 


Those customers for whom no credit limit has been entered, should display the message "Not available". 


Which from the following SQL statements would produce the required outcome?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

In the Exhibit, view the structure of the STUDENT and FACULTY tables. 


You need to display the faculty name followed by the number of students the faculty manages at the base location. Analyze the following two SQL statements: 


SENTENCIA 1: 

> SELECT FACULTY_NAME, COUNT(STUDENT_ID) FROM STUDENT JOIN FACULTY USING (FACULTY_ID, LOCATION_ID) GROUP BY FACULTY_NAME; 


SENTENCIA 2: 

> SELECT FACULTY_NAME, COUNT(STUDENT_ID) FROM STUDENT NATURAL JOIN FACULTY GROUP BY FACULTY_NAME; 


Which from the following statements is true about the result?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Which of the following SQL statements would display the value 1890.55 as $ 1, 890.55? (Select two.)

 

 

.

¿Hay algún error o Mejora?

por favor, responda a todas las preguntas

RESPUESTAS CORRECTAS

4

RESPUESTAS INCORRECTAS

4

 

 

 

 

.

CARGANDO