EXAMEN ORACLE CERTIFIED ASSOCIATE 1Z0-071
PREGUNTA
LAS OPCIONES CORRECTAS SON:
.
.
Analyze the structure of the CUSTOMERS and CUST_HISTORY tables in the Exhibit:
The current location of all currently active customers is contained in the CUSTOMERS table.
Historical details in regards of any location’s changes of all current and previous customers who are no longer active with the company are stored in the CUST_HISTORY table.
In order to find those customers who have never changed their address,
which SET operator would you use to obtain the required output?
PREGUNTA
LAS OPCIONES CORRECTAS SON:
.
.
Analyze the PRODUCTS and ORDER_ITEMS tables in the Exhibit.
In order to display PRODUCT_NAME and the number of times the product has been ordered, you issued this query:
►SELECT p.product_name, i.item_cnt FROM (SELECT product_id, COUNT (*) item_cnt FROM order_items GROUP BY product_id) i RIGHT OUTER JOIN products p ON i.product_id = p.product_id;
What would be the result from the above query?
PREGUNTA
LAS OPCIONES CORRECTAS SON:
.
.
Which from the following statements is true about the UNION operator?
PREGUNTA
LAS OPCIONES CORRECTAS SON:
.
.
Analyze the following create table statements for the stores and sales tables.
> CREATE TABLE stores(store_id NUMBER(4) CONSTRAINT store_id_pk PRIMARY KEY, store_name VARCHAR2(12), store_address VARCHAR2(20), start_date DATE); > CREATE TABLE sales(sales_id NUMBER(4) CONSTRAINT sales_id_pk PRIMARY KEY, item_id NUMBER(4), quantity NUMBER(10), sales_date DATE, store_id NUMBER(4), CONSTRAINT store_id_fk FOREIGN KEY(store_id) REFERENCES stores(store_id));
You issued this statement:
> DELETE from stores WHERE store_id=900; The statement does not execute successfully due to the following error of integrity constraint:
►ORA-02292: integrity constraint (HR.STORE_ID_FK) violated
Which from the following options ensure success in the execution of the statement? (Select three.)
PREGUNTA
LAS OPCIONES CORRECTAS SON:
.
.
The CUST_CITY column of the customers table holds the value 'Paris' for the CUST_FIRST_NAME 'Abigail'.
Examine this query:
What will be the result?
PREGUNTA
LAS OPCIONES CORRECTAS SON:
.
.
Which from the following statements are true about constraints? (Select two.)
PREGUNTA
LAS OPCIONES CORRECTAS SON:
.
.
Which from the following statements are true about the command? (Select two.)
PREGUNTA
LAS OPCIONES CORRECTAS SON:
.
.
Which from the following statements is true regarding Enterprise Manager (EM) express in Oracle Database 12c?
CARGANDO
.
¿Hay algún error o Mejora?
por favor, responda a todas las preguntas
RESPUESTAS CORRECTAS
4
RESPUESTAS INCORRECTAS
4