EXAMEN ORACLE CERTIFIED ASSOCIATE 1Z0-061

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Analyze the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE NEW_EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2(60) 


Which would be the valid MERGE statement?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

What a user who is granted the CREATE VIEW privilege is allowed to do?

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

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Identify the constraint which can be defined only at column level.

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

View the SQL statement that follows: 

► DROP TABLE DEPT; 


Which of the following statements are true about the above statement? (Select four)

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Examine the structure and data in the following PRICE_LIST table: 


► PROD_ID NOT NULL NUMBER(3) PROD_PRICE VARCHAR2(10) PROD_ID PROD PRICE ___________________________ 100 $234.55 101 $6, 509.75 102 $1, 234 


If you want to show the PROD_ID in the same format as the PROD_PRICE, which SQL statement would produce the required outcome? 


SELECT TO_CHAR(prod_price* .25.'$99.999.99') FROM PRICE_LIST:

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Which two statements are true regarding constraints? (Choose two.)

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

You need to create a table named ORDERS that contain four columns: 


1. AN ORDER_ID column of number data type 


2. A CUSTOMER_ID column of number data type 


3. AN ORDER_STATUS column that contains a character data type 


4. A DATE_ORDERED column to contain the date the order was placed.


When a row is inserted into the table, if no value is provided when the order was placed, todays date should be used instead. 


Which statement accomplishes this?

 

 

.

¿Hay algún error o Mejora?

por favor, responda a todas las preguntas

RESPUESTAS CORRECTAS

4

RESPUESTAS INCORRECTAS

4

 

 

 

 

.

CARGANDO