EXAMEN ORACLE CERTIFIED ASSOCIATE 1Z0-061

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

You need to create a table with these column specifications: 


1. One column with the heading’ emp_id’, to store the ID of each employee (number data type). 


2. One column with the heading ‘emp_name’, to store the name of each employee (characters data type). 


3. One column with the heading ‘start_date’, to store the date the employee joined the organization (date data type). 


4. One column with the heading ‘emp_status’ (characters data type), which contains the default value 'active’ if no data is entered. 


5. One column with the heading ‘resume’ (characters large objects data type [CLOB]), 


which contains the curriculum the employee has handed in. 


What syntax would you use to create such table?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Analyze the structure and the data of the following CUST_TRANS table: 


In the CUST_TRANStable, dates are stored by default in the format dd-mon-yy. 


Which of the following SQL statements would execute correctly? (Select three.)

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Analyze the structure of the following products table: 


You want to display the name of those products that have the highest total value for UNIT_PRICE * QTY_IN_HAND. 


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

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Analyze the data in the ORD_ITEMS table that follows: Analyze the following query: 

> SELECT ITEM_NO, AVG(QTY) FROM ORD_ITEMS HAVING AVG(QTY) > MIN(QTY) * 2 GROUP BY ITEM_NO; 


In regards of the result of the above query, which of the following statements is true?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Analyze the following query: 


> SELECT PROMO_NAME || Q’{‘S START DATE WAS \}’ || PROMO_BEGIN_DATE AS “PROMOTION LAUNCHES” FROM PROMOTIONS; 


Which of the following statements is true regarding the result of the above query?

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 subqueries? (Select two.)

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

The CUST_CITY column contains, for CUST_FIRST_NAME 'Abigail', the value 'Paris' in the CUSTOMERS table. Analyze the following query: 


> SELECT INITCAP(CUST_FIRST_NAME || ‘ ‘ || UPPER(SUBSTR(CUST_CITY,-LENGTH(CUST_CITY),2))) FROM CUSTOMERS WHERE CUST_FIRST_NAME = ‘Abigail’; Which from the following options would be the query’s result?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Examine the data in the EMPLOYEES table in the Exhibit below: You want to display all employees’ names and their corresponding manager’s IDs. 


Examine the following query: SELECT E.EMPLOYEE_NAME “EMP NAME”, M.EMPLOYEE_NAME “MGR NAME” FROM EMPLYEES E __________________ EMPLOYEES M ON E.MANAGER_ID = M.EMPLOYEE_ID; 


¿Which join option would you use in the above query to fill in the blank with in order to obtain the required outcome?

 

 

.

¿Hay algún error o Mejora?

por favor, responda a todas las preguntas

RESPUESTAS CORRECTAS

4

RESPUESTAS INCORRECTAS

4

 

 

 

 

.

CARGANDO