EXAMEN ORACLE CERTIFIED ASSOCIATE 1Z0-071

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Analyze the structure of the MEMBERS table that follows. In order to display the last names and city names only for members from the states MO and MI, which query would you use?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Which from the following statements is true about an inner join specified in the WHERE clause of a query?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

In the sample below, analyze the structure of the BOOKS_TRANSACTIONS table:


Which from the following SQL statements would you execute in order to display the member IDs, due date, and late fee as $2 for all transactions?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Examine this SQL statement: ►SELECT product_name || 'it's not available for order' FROM product_information WHERE product_status = 'obsolete'; While executing the above query, it generates the following error: ►ERROR ORA-01756: quoted string not properly terminated In order to execute the query successfully, what would you do?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

In the sample below, analyze the ORDERS table. Given that the ORDERS table contains data and all orders have been assigned a customer ID, which from the following statements would add a NOT NULL constraint to the CUSTOMER_ID column?

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

Analyze the description of the PRODUCT_INFORMATION table in the sample below. In order to retrieve from the table the number of products having LIST_PRICE as NULL, which SQL statement would you use?
EXAMEN-22

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

When using SQL functions built into Oracle Database, which from the following tasks can be performed? (Select three.)

PREGUNTA

Copia de OK1_edited.png
CANCEL2_edited.png

LAS OPCIONES CORRECTAS SON:

contabilidad-financiera-5.jpg

.

You must design a table’s structure to have the following specifications for two columns: 


►COMPONENT_ID – must be able to incorporate 12 alphanumeric characters at maximum, as well as to uniquely identify the row. 


►EXECUTION_DATETIME – must contain Century, Year, Month, Day, Hour, Minute, Second to the maximum exactitude and is used to calculate and compare components. 


Which from the following options would define the data types that will satisfy these requirements with the most efficiency? (Select two.)

 

 

.

¿Hay algún error o Mejora?

por favor, responda a todas las preguntas

RESPUESTAS CORRECTAS

4

RESPUESTAS INCORRECTAS

4

 

 

 

 

.

CARGANDO