[Free] 2019(Nov) EnsurePass Oracle 1z0-061 Dumps with VCE and PDF 71-80

Get Full Version of the Exam
http://www.EnsurePass.com/1z0-061.html

Question No.71

You need to produce a report where each customer#39;s credit limit has been incremented by $1000. In the output, the customer#39;s last name should have the heading Name and the incremented credit limit should be labeled New Credit Limit. The column headings should have only the first letter of each word in uppercase. Which statement would accomplish this requirement?

image

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Correct Answer: C

Explanation:

A column alias:

Renames a column heading Is useful with calculations

Immediately follows the column name (There can also be the optional AS keyword between the column name and the alias.)

Requires double quotation marks if it contains spaces or special characters, or if it is case sensitive.

Question No.72

View the Exhibit and evaluate the structure and data in the CUST_STATUS table.

image

You issue the following SQL statement:

image

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

  1. It produces an error because the AMT_SPENT column contains a null value.

  2. It displays a bonus of 1000 for all customers whose AMT_SPENT is less than CREDIT_LIMIT.

  3. It displays a bonus of 1000 for all customers whose AMT_SPENT equals CREDIT_LIMIT, or AMT_SPENT is null.

  4. It produces an error because the TO_NUMBER function must be used to convert the result of the NULLIF function before it can be used by the NVL2 function.

Correct Answer: C

Explanation:

The NULLIF Function

The NULLIF function tests two terms for equality. If they are equal the function returns a null, else it returns the first of the two terms tested. The NULLIF function takes two mandatory parameters of any data type. The syntax is NULLIF(ifunequal, comparison_term), where the parameters ifunequal and comparison_term are compared. If they are identical, then NULL is returned. If they differ, the ifunequal parameter is returned.

Question No.73

View the Exhibit and examine the data in the products table.

image

You need to display product names from the products table that belong to the #39;software/other#39; category with minimum prices as either S2000 or S4000 and no unit of measure.

You issue the following query:

image

Which statement is true regarding the above query?

  1. It executes successfully but returns no result.

  2. It executes successfully and returns the required result.

  3. It generates an error because the condition specified for PROD_UNIT_OF_MEASURE is not valid.

  4. It generates an error because the condition specified for the prod category column is not valid.

Correct Answer: A

Question No.74

In which three situations does a transaction complete?

  1. When a DELETE statement is executed

  2. When a ROLLBACK command is executed

  3. When a PL/SQL anonymous block is executed

  4. When a data definition language (DDL) statement is executed

  5. When a TRUNCATE statement is executed after the pending transaction

Correct Answer: BDE

Question No.75

Examine the structure of the employees table:

image

There is a parent/child relationship between EMPLOYEE_ID and MANAGER_ID.

You want to display the name, joining date, and manager for all the employees. Newly hired employees are yet to be assigned a department or a manager. For them, #39;No Manager#39; should be displayed in the manager column.

Which SQL query gets the required output?

image

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Correct Answer: B

Explanation:

We should use LEFT OUTER JOIN as we want to display employees which have no (have NULL values for) managers.

Question No.76

Examine the structure of the transactions table:

image

You want to display the date, time, and transaction amount of transactions that where done before 12 noon. The value zero should be displayed for transactions where the transaction amount has not been entered.

Which query gives the required result?

image

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Correct Answer: B

Question No.77

Examine the types and examples of relationships that follow:

  1. One-to-one a) Teacher to students

  2. One-to-many b) Employees to Manager

  3. Many-to-one c) Person to SSN

  4. Many-to-many d) Customers to products

Which option indicates the correctly matched relationships? A. 1-a, 2-b, 3-c, and 4-d

B. 1-c, 2-d, 3-a, and 4-b

C. 1-c, 2-a, 3-b, and 4-d

D. 1-d, 2-b, 3-a, and 4-c

Correct Answer: C

Question No.78

View the Exhibit and examine the structure of the product, component, and PDT_COMP tables. In product table, PDTNO is the primary key.

In component table, COMPNO is the primary key.

In PDT_COMP table, lt;PDTNO, COMPNO) is the primary key, PDTNO is the foreign key referencing PDTNO in product table and COMPNO is the foreign key referencing the COMPNO in component table.

You want to generate a report listing the product names and their corresponding component names, if the component names and product names exist.

Evaluate the following query:

SQLgt;SELECT pdtno, pdtname, compno, compname FROM product pdt_comp

USING (pdtno) component USING (compno) WHERE compname IS NOT NULL;

Which combination of joins used in the blanks in the above query gives the correct output?

image

  1. JOIN; JOIN

  2. FULL OUTER JOIN; FULL OUTER JOIN

  3. RIGHT OUTER JOIN; LEFT OUTER JOIN

  4. LEFT OUTER JOIN; RIGHT OUTER JOIN

Correct Answer: C

Question No.79

Which two statements are true regarding constraints?

  1. A foreign key cannot contain null values.

  2. A column with the unique constraint can contain null values.

  3. A constraint is enforced only for the insert operation on a table.

  4. A constraint can be disabled even if the constraint column contains data.

  5. All constraints can be defined at the column level as well as the table level.

Correct Answer: BD

Explanation:

B: Any number of rows can include nulls for columns without NOT NULL constraints because nulls are not considered equal to anything.

D: Constraints can be added, dropped, enabled, disabled, or validated. DISABLE allows incoming data, regardless of whether it conforms to the constraint

Incorrect:

Not A: The relational model permits the value of foreign keys either to match the referenced primary or unique key value, or be null.

Question No.80

View the Exhibit and examine the data in the promotions table.

image

PROMO_BEGIN_DATE is stored in the default date format, dd-mon-rr.

You need to produce a report that provides the name, cost, and start date of all promos in the post category that were launched before January 1, 2000.

Which SQL statement would you use?

image

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Correct Answer: D

Get Full Version of the Exam
1z0-061 Dumps
1z0-061 VCE and PDF

You must be logged in to post a comment.

Proudly powered by WordPress   Premium Style Theme by www.gopiplus.com