[Free] 2018(Jan) EnsurePass Dumpsleader Oracle 1z0-061 Dumps with VCE and PDF 1-10

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-061
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-061.html

Oracle Database 12c: SQL Fundamentals

Question No: 1

View the Exhibit and examine the structure of the products table.

Ensurepass 2018 PDF and VCE

Using the products table, you issue the following query to generate the names, current list price, and discounted list price for all those products whose list price falls below $10 after a discount of 25% is applied on it.

Ensurepass 2018 PDF and VCE

The query generates an error. What is the reason for the error?

  1. The parenthesis should be added to enclose the entire expression.

  2. The double quotation marks should be removed from the column alias.

  3. The column alias should be replaced with the expression in the where clause.

  4. The column alias should be put in uppercase and enclosed within double quotation marks in the where clause.

Answer: C

Question No: 2

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

Ensurepass 2018 PDF and VCE

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?

Ensurepass 2018 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Answer: D

Question No: 3

Evaluate the following SQL statement:

Ensurepass 2018 PDF and VCE

Which statement is true regarding the above query if one of the values generated by the subquery is null?

  1. It produces an error.

  2. It executes but returns no rows.

  3. It generates output for null as well as the other values produced by the subquery.

  4. It ignores the null value and generates output for the other values produced by the subquery.

Answer: C

Question No: 4

You need to generate a list of all customer last names with their credit limits from the customers table.

Those customers who do not have a credit limit should appear last in the list. Which two queries would achieve the required result?

Ensurepass 2018 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Answer: B,C Explanation:

If the ORDER BY clause is not used, the sort order is undefined, and the Oracle server may not fetch rows in the same order for the same query twice. Use the ORDER BY clause to display the rows in a specific order.

Note: Use the keywords NULLS FIRST or NULLS LAST to specify whether returned rows containing null values should appear first or last in the ordering sequence. ANSWER C Sorting

The default sort order is ascending:

  • Numeric values are displayed with the lowest values first (for example, 1 to 999).

  • Date values are displayed with the earliest value first (for example, 01-JAN-92 before 01- JAN-95).

  • Character values are displayed in the alphabetical order (for example, “A” first and “Z” last).

  • Null values are displayed last for ascending sequences and first for descending sequences.

    – ANSWER B

  • You can also sort by a column that is not in the SELECT list.

Question No: 5

Examine the structure of the employees table:

Ensurepass 2018 PDF and VCE

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 Manager1 should be displayed in the manager column.

Which SQL query gets the required output?

Ensurepass 2018 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Answer: D

Reference: http://ivrainbow65.blogspot.com/

Question No: 6

In the customers table, the CUST_CITY column contains the value #39;Paris#39; for the CUST_FIRST_NAME #39;Abigail#39;.

Evaluate the following query:

Ensurepass 2018 PDF and VCE

What would be the outcome?

  1. Abigail PA

  2. Abigail Pa

  3. Abigail IS

  4. An error message

Answer: B

Question No: 7

Examine the structure of the orders table:

Ensurepass 2018 PDF and VCE

You want to find the total value of all the orders for each year and issue the following command:

Ensurepass 2018 PDF and VCE

Which statement is true regarding the outcome?

  1. It executes successfully and gives the correct output.

  2. It gives an error because the TO_CHAR function is not valid.

  3. It executes successfully but does not give the correct output.

  4. It gives an error because the data type conversion in the SELECT list does not match the data type conversion in the GROUP BY clause.

Answer: D

Question No: 8

Examine the data in the CUST_NAME column of the customers table.

Ensurepass 2018 PDF and VCE

You need to display customers#39; second names where the second name starts with quot;Mcquot; or quot;MC.quot;

Which query gives the required output?

Ensurepass 2018 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Answer: B

Question No: 9

Evaluate the following SQL commands:

Ensurepass 2018 PDF and VCE

The command to create a table fails. Identify the two reasons for the SQL statement failure?

  1. You cannot use SYSDATE in the condition of a check constraint.

  2. You cannot use the BETWEEN clause in the condition of a check constraint.

  3. You cannot use the NEXTVAL sequence value as a default value for a column.

  4. You cannot use ORD_NO and ITEM_NO columns as a composite primary key because ORD_NO is also the foreign key.

Answer: A,C

Explanation:

CHECK Constraint

The CHECK constraint defines a condition that each row must satisfy. The condition can use the same constructs as the query conditions, with the following exceptions: References to the CURRVAL, NEXTVAL, LEVEL, and ROWNUM pseudocolumns

Calls to SYSDATE, UID, USER, and USERENV functions Queries that refer to other values in other rows

A single column can have multiple CHECK constraints that refer to the column in its definition.

There is no limit to the number of CHECK constraints that you can define on a column. CHECK constraints can be defined at the column level or table level.

CREATE TABLE employees (…

Salary NUMBER(8, 2) CONSTRAINT emp_salary_min CHECK (salary gt; 0),

Question No: 10

Using the customers table, you need to generate a report that shows 50% of each credit amount in each income level. The report should NOT show any repeated credit amounts in each income level.

Which query would give the required result?

Ensurepass 2018 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

    Answer: C

    Explanation: Duplicate Rows

    Unless you indicate otherwise, SQL displays the results of a query without eliminating the duplicate rows.

    To eliminate duplicate rows in the result, include the DISTINCT keyword in the SELECT clause immediately after the SELECT keyword.

    You can specify multiple columns after the DISTINCT qualifier. The DISTINCT qualifier affects all the selected columns, and the result is every distinct combination of the columns.

    100% Ensurepass Free Download!
    Download Free Demo:1z0-061 Demo PDF
    100% Ensurepass Free Guaranteed!
    1z0-061 Dumps

    EnsurePass ExamCollection Testking
    Lowest Price Guarantee Yes No No
    Up-to-Dated Yes No No
    Real Questions Yes No No
    Explanation Yes No No
    PDF VCE Yes No No
    Free VCE Simulator Yes No No
    Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.