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

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

Question No.51

Evaluate the following query:

SQLgt; SELECT TRUNC(ROUND(156.00, -1), -1) FROM DUAL;

What would be the outcome?

A.

16

B.

100

C.

160

D.

200

E.

150

Correct Answer: C Explanation: Function Purpose

ROUND(column|expression, n) Rounds the column, expression, or value to n decimal places or, if n is omitted, no decimal places (If n is negative, numbers to the left of decimal point are rounded.)

TRUNC(column|expression, n) Truncates the column, expression, or value to n decimal places or, if n is omitted, n defaults to zero

Question No.52

You need to list the employees in DEPARTMENT_ID 30 in a single row, ordered by HIRE_DATE. Examine the sample output:

image

Which query will provide the required output?

image

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Correct Answer: B

Question No.53

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

image

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:

image

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.

Correct Answer: D

Question No.54

Which statement is true regarding the UNION operator?

  1. By default, the output is not sorted.

  2. Null values are not ignored during duplicate checking.

  3. Names of all columns must be identical across all select statements.

  4. The number of columns selected in all select statements need not be the same.

Correct Answer: B

Explanation:

For the UNION operator the nulls values are not ignored during duplicate checking.

Incorrect:

Not A: The UNION operator implicitly sorts the output. Not D: Each SQL SELECT statement within the UNION query must have the same number of fields in the result sets with similar data types.

Question No.55

Which statement is true regarding the default behavior of the order by clause?

  1. In a character sort, the values are case-sensitive.

  2. NULL values are not considered at all by the sort operation.

  3. Only those columns that are specified in the select list can be used in the order by clause.

  4. Numeric values are displayed from the maximum to the minimum value if they have decimal positions.

Correct Answer: A

Explanation:

Character Strings and Dates

Character strings and date values are enclosed with single quotation marks. Character values are case-sensitive and date values are format-sensitive.

The default date display format is DD-MON-RR.

Question No.56

What are distinguishing characteristics of a public synonym rather than a private synonym? (Choose two.)

  1. Public synonyms are always visible to all users.

  2. Public synonyms can be accessed by name without a schema name qualifier.

  3. Public synonyms can be selected from without needing any permissions.

  4. Public synonyms can have the same names as tables or views.

Correct Answer: BD

Explanation:

Public synonyms are not schema objects and so can only be addressed directly. They can have the same names as schema objects.

Question No.57

Examine the structure and data of the CUST_TRANS table:

image

Dates are stored in the default date format dd-mon-rr in the CUST_TRANS table. Which three SQL statements would execute successfully?

  1. SELECT transdate #39;10#39; FROM cust_trans;

  2. SELECT * FROM cust_trans WHERE transdate = #39;01-01-07#39;;

  3. SELECT transamt FROM cust_trans WHERE custno gt; #39;11#39;;

  4. SELECT * FROM cust_trans WHERE transdate=#39;01-JANUARY-07#39;;

  5. SELECT custno #39;A#39; FROM cust_trans WHERE transamt gt; 2000;

Correct Answer: ACD

Question No.58

You need to display the first names of all customers from the customers table that contain the character #39;e#39; and have the character #39;a#39; in the second last position. Which query would give the required output?

image

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Correct Answer: A

Explanation:

The SUBSTR(string, start position, number of characters) function accepts three parameters and returns a string consisting of the number of characters extracted from the source string, beginning at the specified start position:

substr(#39;http://www.domain.com#39;, 12, 6) = domain

The position at which the first character of the returned string begins. When position is 0 (zero), then it is treated as 1. When position is positive, then the function counts from the beginning of string to find the first character.

When position is negative, then the function counts backward from the end of string. substring_length

The length of the returned string. SUBSTR calculates lengths using characters as defined by the input character set. SUBSTRB uses bytes instead of characters. SUBSTRC uses Unicode complete characters.

SUBSTR2 uses UCS2 code points. SUBSTR4 uses UCS4 code points. When you do not specify a value for this argument, then the function

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

Question No.59

You need to create a table for a banking application. One of the columns in the table has the following requirements:

  1. You want a column in the table to store the duration of the credit period.

  2. The data in the column should be stored in a format such that it can be easily added and subtracted with date data type without using conversion functions.

  3. The maximum period of the credit provision in the application is 30 days.

  4. The interest has to be calculated for the number of days an individual has taken a credit for. Which data type would you use for such a column in the table?

  1. DATE

  2. NUMBER

  3. TIMESTAMP

  4. INTERVAL DAY TO SECOND

  5. INTERVAL YEAR TO MONTH

Correct Answer: D

Explanation:

INTERVAL DAY TO SECOND stores a period of time in terms of days, hours, minutes, and seconds. This data type is useful for representing the precise difference between two datetime values.

You can perform a number of arithmetic operations on date (DATE), timestamp (TIMESTAMP, TIMESTAMP WITH TIME ZONE, and TIMESTAMP WITH LOCAL TIME ZONE) and interval (INTERVAL DAY TO SECOND and INTERVAL YEAR TO MONTH) data.

It stores duration of the credit as days

The format stored is numeric format, and you know that numeric values can be easily added and subtracted with date data type without using conversion functions (i.e. SELECT SYSDATE ?1 FROM DUAL;)

The interest has to be calculated for the number of days an individual has taken a credit for, so it will be easy to calculate interest by using the interest rate and duration of the the credit which is numeric format.

Question No.60

View the Exhibits and examine the structures of the products, sales, and customers tables.

image

image

You need to generate a report that gives details of the customer#39;s last name, name of the product, and the quantity sold for a customers in #39;Tokyo#39;.

Which two queries give the required result?

image

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Correct Answer: AC

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

Leave a Reply

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

Proudly powered by WordPress