PDF Download Free of 1z1-071 Valid Practice Test Questions [Q28-Q46]

NO.28 View the exhibit and examine the description of the EMPLOYEES table. (Choose two.)

You executed this SQL statement:
SELECT first_name, department_id, salary
FROM employees
ORDER BY department_id, first_name, salary desc;
Which two statements are true regarding the result? (Choose two.)

NO.29 Which statements are true regarding primary and foreign key constraints and the effect they can have on table data?

NO.30 View the Exhibit and examine the structure of the SALEStable.

The following query is written to retrieve all those product IDs from the SALEStable that have more than 55000 sold and have been ordered more than 10 items.

Which statement is true regarding this SQL statement?

NO.31 You execute the SQL statement:

What is the outcome?

NO.32 You execute this query:

What is the result?

NO.33 View the Exhibit and examine the structure of the CUSTOMERS table.

Evaluate the following SQL statement:

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

NO.34 Which three statements are true about the DESCRIBE command? (Choose three.)

NO.35 View the Exhibit and examine the details of the PRODUCT_INFORMATIONtable.
Exhibit

You must display PRODUCT_NAME from the table where the CATEGORY_IDcolumn has values 12or 13, and the SUPPLIER_IDcolumn has the value 102088.
You executed this SQL statement:

Which statement is true regarding the execution?

NO.36 View the Exhibit and examine the details of the PRODUCT_INFORMATION table.

You have the requirement to display PRODUCT_NAME and LIST_PRICE from the table where the CATEGORYJD column has values 12 or 13, and the SUPPLIER_ID column has the value 102088. You executed the following SQL statement:
SELECT product_name, list_price
FROM product_information
WHERE (category_id = 12 AND category_id = 13) AND supplier_id = 102088; Which statement is true regarding the execution of the query?

NO.37 Examine this SQL statement:

Which two are true?

NO.38 Examine the description of the CUSTOMERS table:

Which two statements will do an implicit conversion?

NO.39 Which statements is true about using functions in WHERE and HAVING?

NO.40 Examine the description of the SALES table:

The SALES table has 5,000 rows.
Examine this statement:
CREATE TABLE sales1 (prod id, cust_id, quantity_sold, price)
AS
SELECT product_id, customer_id, quantity_sold, price
FROM sales
WHERE 1=1
Which two statements are true?

NO.41 Which three statements are true about GLOBAL TEMPORARY TABLES?

NO.42 View the exhibit and examine the structure of ORDERSand CUSTOMERStables.

Which INSERT statement should be used to add a row into the ORDERStable for the customer whose CUST_LAST_NAMEis Robertsand CREDIT_LIMITis 600? Assume there exists only one row with CUST_LAST_NAME as Roberts and CREDIT_LIMIT as 600.
INSERT INTO (SELECT o.order_id, o.order_date, o.order_mode, c.customer_id,

NO.43 Which two are the minimal requirements for a self-join? (Choose two.)

NO.44 View the Exhibit and examine the structure in the EMPLOYEES tables.

Evaluate the following SQL statement:
SELECT employee_id, department_id
FROM employees
WHERE department_id= 50 ORDER BY department_id
UNION
SELECT employee_id, department_id
FROM employees
WHERE department_id=90
UNION
SELECT employee_id, department_id
FROM employees
WHERE department_id=10;
What would be the outcome of the above SQL statement?

NO.45 You want to display the date for the first Monday of the next month and issue the following command:

What is the outcome?

NO.46 Which three tasks can be performed using SQL functions built into Oracle Database?