[Free] 2018(Jan) EnsurePass Passguide Oracle 1z0-061 Dumps with VCE and PDF 11-20

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: 11 CORRECT TEXT

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

You need to generate a report of all promos from the promotions table based on the following conditions:

  1. The promo name should not begin with #39;T#39; or #39;N#39;.

  2. The promo should cost more than $20000.

  3. The promo should have ended after 1st January 2001. Which where clause would give the required result?

    Ensurepass 2018 PDF and VCE

    Answer: WHERE promo_name NOT LIKE ‘T%’ AND promo_name NOT LIKE ‘N%’ AND promo_cost gt; 20000 AND promo_end_date gt; ‘1-JAN-01#39;

    Question No: 12

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

    Ensurepass 2018 PDF and VCE

    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:

    Ensurepass 2018 PDF and VCE

    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.

Answer: A

Question No: 13

Which two statements are true regarding single row functions?

  1. MOD: returns the quotient of a division

  2. TRUNC: can be used with number and date values

  3. CONCAT: can be used to combine any number of values

  4. SYSDATE: returns the database server current date and time

  5. INSTR: can be used to find only the first occurrence of a character in a string

  6. TRIM: can be used to remove all the occurrences of a character from a string

Answer: B,D Explanation:

ROUND: Rounds value to a specified decimal TRUNC: Truncates value to a specified decimal MOD: Returns remainder of division

SYSDATE is a date function that returns the current database server date and time.

Date-Manipulation Functions

Date functions operate on Oracle dates. All date functions return a value of the DATE data type except MONTHS_BETWEEN, which returns a numeric value.

MONTHS_BETWEEN(date1, date2): Finds the number of months between date1 and date2. The result can be positive or negative. If date1 is later than date2, the result is positive; if date1 is earlier than date2, the result is negative. The noninteger part of the result represents a portion of the month.

ADD_MONTHS(date, n): Adds n number of calendar months to date. The value of n must be an integer and can be negative.

NEXT_DAY(date, #39;char#39;): Finds the date of the next specified day of the week (#39;char#39;) following date. The value of char may be a number representing a day or a character string.

LAST_DAY(date): Finds the date of the last day of the month that contains date

The above list is a subset of the available date functions. ROUND and TRUNC number functions can also be used to manipulate the date values as shown below:

ROUND(date[, #39;fmt#39;]): Returns date rounded to the unit that is specified by the format model fmt. If the format model fmt is omitted, date is rounded to the nearest day.

TRUNC(date[, #39;fmt#39;]): Returns date with the time portion of the day truncated to the unit that is specified by the format model fmt. If the format model fmt is omitted, date is truncated to the nearest day.

The CONCAT Function

The CONCAT function joins two character literals, columns, or expressions to yield one larger character expression. Numeric and date literals are implicitly cast as characters when they occur as parameters to the CONCAT function. Numeric or date expressions are

evaluated before being converted to strings ready to be concatenated. The CONCAT function takes two parameters. Its syntax is CONCAT(s1, s2), where s1 and s2 represent string literals, character column values, or expressions resulting in character values.

The INSTR(source string, search item, [start position], [nth occurrence of search item]) function returns a number that represents the position in the source string, beginning from the given start position, where the nth occurrence of the search item begins: instr(#39;http://www.domain.com#39;, #39;.#39;, 1, 2) = 18

The TRIM function literally trims off leading or trailing (or both) character strings from a given source string:

Question No: 14

You want to create a table employees in which the values of columns EMPLOYEES_ID and LOGIN_ID must be unique and not null. Which two SQL statements would create the required table?

Ensurepass 2018 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

  5. Option E

  6. Option F

Answer: D,E

Question No: 15

Which three SQL statements would display the value 1890.55 as $1, 890.55?

Ensurepass 2018 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

  5. Option E

Answer: A,D,E

Question No: 16

You issue the following command to drop the products table: SQLgt; DROP TABLE products;

Which three statements are true about the implication of this command?

  1. All data along with the table structure is deleted.

  2. A pending transaction in the session is committed.

  3. All indexes on the table remain but they are invalidated.

  4. All views and synonyms remain but they are invalidated.

  5. All data in the table is deleted but the table structure remains.

Answer: A,B,D

Question No: 17

View the Exhibit for the structure of the student and faculty tables.

Ensurepass 2018 PDF and VCE

You need to display the faculty name followed by the number of students handled by the faculty at the base location.

Examine the following two SQL statements:

Ensurepass 2018 PDF and VCE

Which statement is true regarding the outcome?

  1. Only statement 1 executes successfully and gives the required result.

  2. Only statement 2 executes successfully and gives the required result.

  3. Both statements 1 and 2 execute successfully and give different results.

  4. Both statements 1 and 2 execute successfully and give the same required result.

Answer: D

Question No: 18

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

Ensurepass 2018 PDF and VCE

All products have a list price.

You issue the following command to display the total price of each product after a discount of 25% and a tax of 15% are applied on it. Freight charges of $100 have to be applied to all the products.

Ensurepass 2018 PDF and VCE

What would be the outcome if all the parentheses are removed from the above statement?

  1. It produces a syntax error.

  2. The result remains unchanged.

  3. The total price value would be lower than the correct value.

  4. The total price value would be higher than the correct value.

Answer: B

Question No: 19

You want to create a sales table with the following column specifications and data types: SALESID: Number

STOREID: Number ITEMID: Number

QTY: Number, should be set to 1 when no value is specified

SLSDATE: Date, should be set to current date when no value is specified

PAYMENT: Characters up to 30 characters, should be set to CASH when no value is specified

Which statement would create the table?

Ensurepass 2018 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Answer: D

Question No: 20

Which normal form is a table in if it has no multi-valued attributes and no partial dependencies?

  1. First normal form

  2. Second normal form

  3. Third normal form

  4. Fourth normal form

Answer: B

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 *