Free Download Pass4sure and Lead2pass 1Z0-051 Exam Question with PDF & VCE (121-130)

QUESTION 121
Which two statements are true regarding the ORDER BY clause? (Choose two.)

A.    It is executed first in the query execution.
B.    It must be the last clause in the SELECT statement.
C.    It cannot be used in a SELECT statement containin g a HAVING clause.
D.    You cannot specify a column name followed by an expression in this clause.
E.    You can specify a combination of numeric positions and column names in this clause.

Answer: BE

QUESTION 122
Which statement is true regarding the default behavior of the ORDER BY clause?

A.    In a character sort, the values are case- sensitive.
B.    NULL values are not considered at all by the sort operation.
C.    Only those columns that are specified in the SELECT list can be used in the ORDER BY clause.
D.    Numeric values are displayed from the maximum to the minimum value if they have decimal positions.

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 123
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? (Choose two.)

A.    SELECT cust_last_name, cust_credit_limit
FROM customers
ORDER BY cust_credit_limit DESC ;
B.    SELECT cust_last_name, cust_credit_limit
FROM customers
ORDER BY cust_credit_limit;
C.    SELECT cust_last_name, cust_credit_limit
FROM customers
ORDER BY cust_credit_limit NULLS LAST;
D.    SELECT cust_last_name, cust_credit_limit
FROM customers
ORDER BY cust_last_name, cust_credit_limit NULLS LAST;

Answer: BC
QUESTION 124
View the Exhibit and examine the structure of the PRODUCTS table.
You want to display only those product names with their list prices where the list price is at least double the minimum price.
The report should start with the product name having the maximum list price satisfying this condition.
Evaluate the following SQL statement:
SQL>SELECT prod_name,prod_list_price
FROM products
WHERE prod_list_price >= 2 * prod_min_price
Which ORDER BY clauses can be added to the above SQL statement to get the correct output?
(Choose all that apply.)

image

A.    ORDER BY prod_list_price DESC, prod_name;
B.    ORDER BY (2*prod_min_price)DESC, prod_name;
C.    ORDER BY prod_name, (2*prod_min_price)DESC;
D.    ORDER BY prod_name DESC, prod_list_price DESC;
E.    ORDER BY prod_list_price DESC, prod_name DESC;

Answer: AE

QUESTION 125
Which arithmetic operations can be performed on a column by using a SQL function that is built into Oracle database ? (Choose three .)

A.    addition
B.    subtraction
C.    raising to a power
D.    finding the quotient
E.    finding the lowest value

Answer: ACE

QUESTION 126
Which tasks can be performed using SQL functions built into Oracle Database ? (Choose three.)

A.    displaying a date in a nondefault format
B.    finding the number of characters in an expression
C.    substituting a character string in a text expression with a specified string
D.    combining more than two columns or expressions into a single column in the output

Answer: ABC

QUESTION 127
Which tasks can be performed using SQL functions that are built into Oracle database ? (Choose three .)

A.    finding the remainder of a division
B.    adding a number to a date for a resultant date value
C.    comparing two expressions to check whether they are equal
D.    checking whether a specified character exists in a given string
E.    removing trailing, leading, and embedded characters from a character string

Answer: ACD

QUESTION 128
Which statements are true regarding single row functions? (Choose all that apply.)

A.    MOD : returns the quotient of a division
B.    TRUNC : can be used with NUMBER and DATE values
C.    CONCAT : can be used to combine any number of values
D.    SYSDATE : returns the database server current date and time
E.    INSTR : can be used to find only the first occurrence of a character in a string
F.    TRIM : can be used to remove all the occurrences of a character from a string

Answer: BD

QUESTION 129
The following data exists in the PRODUCTS table:
PROD_ID    PROD_LIST_PRICE
——–   ——————————
123456      152525.99
You issue the following query:
SQL> SELECT RPAD(( ROUND(prod_list_price)), 10,’*’)
FROM products
WHERE prod_id = 123456;
What would be the outcome?

A.    152526 ****
B.    **152525.99
C.    152525** **
D.    an error message

Answer: A

QUESTION 130
You need to display the first names of all customers from the CUSTOMERS table that contain the
character ‘e’ and have the character ‘a’ in the second last position.
Which query would give the required output?

A.    SELECT cust_first_name
FROM customers
WHERE INSTR(cust_first_name, ‘e’)<>0 AND
SUBSTR(cust_first_name, -2, 1)=’a’;
B.    SELECT cust_first_name
FROM customers
WHERE INSTR(cust_first_name, ‘e’)<>” AND
SUBSTR(cust_first_name, -2, 1)=’a’;
C.    SELECT cust_first_name
FROM customers
WHERE INSTR(cust_first_name, ‘e’)IS NOT NULL AND
SUBSTR(cust_first_name, 1,-2)=’a’;
D.    SELECT cust_first_name
FROM customers
WHERE INSTR(cust_first_name, ‘e’)<>0 AND
SUBSTR(cust_first_name, LENGTH(cust_first_name),-2)=’a’;

Answer: A

If you want to pass Oracle 1Z0-051 exam successfully, donot missing to read latest lead2pass Oracle 1Z0-051 practice exams.
If you can master all lead2pass questions you will able to pass 100% guaranteed.

http://www.lead2pass.com/1z0-051.html