Pass 1Z0-051 Exam Successfully With the Help of CertBus New Oracle 1Z0-051 Exam Materials
Do not worry about your 1Z0-051 exam preparation? Hand over your problems to CertBus in change of the 1Z0-051 Oracle Database: SQL Fundamentals I certifications! CertBus provides the latest Oracle 1Z0-051 exam preparation materials with PDF and VCEs. We CertBus guarantees you passing 1Z0-051 exam for sure.
We CertBus has our own expert team. They selected and published the latest 1Z0-051 preparation materials from Oracle Official Exam-Center: http://www.certbus.com/1Z0-051.html
QUESTION NO:107
You work as a database administrator at ABC.com. You study the exhibit carefully.
Exhibit:
You issue the following SQL statement:
Which statement is true regarding the execution of the above query?
A. It produces an error because the AMT_SPENT column contains a null value.
B. It displays a bonus of 1000 for all customers whose AMT_SPENT is less than CREDIT_LIMIT.
C. It displays a bonus of 1000 for all customers whose AMT_SPENT equals CREDIT_LIMIT, or
AMT_SPENT is null.
D. 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
Explanation/Reference:
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:97
See the Exhibit and examine the structure of the PROMOSTIONS table:
Exhibit:
Which SQL statements are valid? (Choose all that apply.)
A. SELECT promo_id, DECODE(NVL(promo_cost,0), promo_cost,
promo_cost * 0.25, 100) “Discount”
FROM promotions;
B. SELECT promo_id, DECODE(promo_cost, 10000,
DECODE(promo_category, \’G1\’, promo_cost *.25, NULL),
NULL) “Catcost”
FROM promotions;
C. SELECT promo_id, DECODE(NULLIF(promo_cost, 10000),
NULL, promo_cost*.25, \’N/A\’) “Catcost”
FROM promotions;
D. SELECT promo_id, DECODE(promo_cost, >10000, \’High\’,
<10000, \'Low\') "Range"
FROM promotions;
Correct Answer: AB
Explanation
Explanation/Reference:
Explanation:
The DECODE Function
Although its name sounds mysterious, this function is straightforward. The DECODE function implements
ifthen-else conditional logic by testing its first two terms for equality and returns the third if they are equal
and optionally returns another term if they are not. The DECODE function takes at least three mandatory
parameters, but can take many more. The syntax of the function is DECODE(expr1,comp1, iftrue1,
[comp2,iftrue2…[ compN,iftrueN]], [iffalse]).
QUESTION NO:59
Evaluate the following two queries:
Exhibit:
Exhibit:
Which statement is true regarding the above two queries?
A. Performance would improve in query 2 only if there are null values in the CUST_CREDIT_LIMIT
column
B. Performance would degrade in query 2
C. There would be no change in performance
D. Performance would improve in query 2
Correct Answer: C
Explanation
Explanation/Reference:
Explanation:
Note: The IN operator is internally evaluated by the Oracle server as a set of OR conditions, such as
a=value1 or a=value2 or a=value3. Therefore, using the IN operator has no performance benefits and is
used only for logical simplicity.
QUESTION NO:123
View the Exhibit and examine the structure of the CUSTOMERS table .Which statement would display the
highest credit limit available in each income level in each city in the CUSTOMERS table?
A. SELECT cust_city, cust_income_level, MAX(cust_credit_limit ) FROM customers GROUP BY
cust_city, cust_income_level, cust_credit_limit;
B. SELECT cust_city, cust_income_level, MAX(cust_credit_limit) FROM customers GROUP BY cust_city,
cust_income_level;
C. SELECT cust_city, cust_income_level, MAX(cust_credit_limit) FROM customers GROUP BY
cust_credit_limit, cust_income_level, cust_city ;
D. SELECT cust_city, cust_income_level, MAX(cust_credit_limit) FROM customers GROUP BY cust_city,
cust_income_level, MAX(cust_credit_limit);
Correct Answer: B
Explanation
Explanation/Reference:
QUESTION NO:110
View the Exhibit and examine the structure of the CUSTOMERS table. You have been asked to produce a
report on the CUSTOMERS table showing the customers details sorted in descending order of the city and
in the descending order of their income level in each city. Which query would accomplish this task?
A. SELECT cust_city, cust_income_level, cust_last_name
FROM customers
ORDER BY cust_city desc, cust_income_level DESC;
B. SELECT cust_city, cust_income_level, cust_last_name
FROM customers
ORDER BY cust_income_level desc, cust_city DESC;
C. SELECT cust_city, cust_income_level, cust_last_name
FROM customers
ORDER BY (cust_city, cust_income_level) DESC;
D. SELECT cust_city, cust_income_level, cust_last_name
FROM customers
ORDER BY cust_city, cust_income_level DESC;
Correct Answer: A
Explanation
Explanation/Reference:
QUESTION NO:43
Exhibit contains the structure of PRODUCTS table:
Evaluate the following query:
What would be the outcome of executing the above SQL statement?
A. It produces an error
B. It shows the names of products whose list price is the second highest in the table.
C. It shown the names of all products whose list price is less than the maximum list price
D. It shows the names of all products in the table
Correct Answer: B
Explanation
Explanation/Reference:
QUESTION NO:103
See the Exhibit and examine the structure of ORD table:
Exhibit:
Evaluate the following SQL statements that are executed in a user session in the specified order:
CREATE SEQUENCE ord_seq;
SELECT ord_seq.nextval
FROM dual;
INSERT INTO ord
VALUES (ord_seq.CURRVAL, \’25-jan-2007,101);
UPDATE ord
SET ord_no= ord_seq.NEXTVAL
WHERE cust_id =101;
What would be the outcome of the above statements?
A. All the statements would execute successfully and the ORD_NO column would contain the value 2 for
the CUST_ID 101.
B. The CREATE SEQUENCE command would not execute because the minimum value and maximum
value for the sequence have not been specified.
C. The CREATE SEQUENCE command would not execute because the starting value of the sequence
and the increment value have not been specified.
D. All the statements would execute successfully and the ORD_NO column would have the value 20 for
the CUST_ID 101 because the default CACHE value is 20.
Correct Answer: A
Explanation
Explanation/Reference:
QUESTION NO:130
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
Correct Answer: A
Explanation
Explanation/Reference:
Explanation:
The LPAD(string, length after padding, padding string) and RPAD(string, length after padding, padding
string) functions add a padding string of characters to the left or right of a string until it reaches the
specified length after padding.
QUESTION NO:98
Which SQL statement displays the date March 19, 2001 in a format that appears as “Nineteenth of March
2001 12:00:00 AM”?
A. SELECT
TO_CHAR(TO_DATE(\’19-Mar-2001\’, `DD-Mon-YYYY\’), `fmDdspth
“of” Month YYYY fmHH:MI:SS AM\’) NEW_DATE
FROM dual;
B. SELECT
TO_CHAR(TO_DATE(\’19-Mar-2001\’, `DD-Mon-YYYY\’), `Ddspth
“of” Month YYYY fmHH:MI:SS AM\’) NEW_DATE
FROM dual;
C. SELECT
TO_CHAR(TO_DATE(\’19-Mar-2001\’, `DD-Mon-YYYY\’), `fmDdspth “of” Month YYYY
HH:MI:SS AM\’) NEW_DATE FROM dual;
D. SELECT
TO_CHAR(TO_DATE(\’19-Mar-2001\’, `DD-Mon-YYYY), `fmDdspth “of” Month YYYYfmtHH:HI:SS AM\’)
NEW_DATE FROM dual;
Correct Answer: A
Explanation
Explanation/Reference:
QUESTION NO:94
Which three statements/commands would cause a transaction to end? (Choose three.)
A. COMMIT
B. SELECT
C. CREATE
D. ROLLBACK
E. SAVEPOINT
Correct Answer: ACD
Explanation
Explanation/Reference:
CertBus exam braindumps are pass guaranteed. We guarantee your pass for the 1Z0-051 exam successfully with our Oracle materials. CertBus Oracle Database: SQL Fundamentals I exam PDF and VCE are the latest and most accurate. We have the best Oracle in our team to make sure CertBus Oracle Database: SQL Fundamentals I exam questions and answers are the most valid. CertBus exam Oracle Database: SQL Fundamentals I exam dumps will help you to be the Oracle specialist, clear your 1Z0-051 exam and get the final success.
1Z0-051 Latest questions and answers on Google Drive(100% Free Download): https://drive.google.com/file/d/0B_3QX8HGRR1mRUNvZTBmX0hLbDQ/view?usp=sharing
1Z0-051 Oracle exam dumps (100% Pass Guaranteed) from CertBus: http://www.certbus.com/1Z0-051.html [100% Exam Pass Guaranteed]
Why select/choose CertBus?
Millions of interested professionals can touch the destination of success in exams by certbus.com. products which would be available, affordable, updated and of really best quality to overcome the difficulties of any course outlines. Questions and Answers material is updated in highly outclass manner on regular basis and material is released periodically and is available in testing centers with whom we are maintaining our relationship to get latest material.
 |
 |
 |
 |
 |
|
|---|---|---|---|---|---|
 |
 |
|
|
 |
|
| Brand | Certbus | Testking | Pass4sure | Actualtests | Others |
| Price | $45.99 | $124.99 | $125.99 | $189 | $69.99-99.99 |
| Up-to-Date Dumps |  |
 |
|
|
|
| Free 365 Days Update | |
|
|
|
|
| Real Questions | |
|
|
|
|
| Printable PDF | |
|
|
|
|
| Test Engine | |
|
|
|
|
| One Time Purchase | |
|
|
|
|
| Instant Download | |
|
|
|
|
| Unlimited Install | |
|
|
|
|
| 100% Pass Guarantee | |
|
|
|
|
| 100% Money Back | |
|
|
|
|
| Secure Payment | |
|
|
|
|
| Privacy Protection | |
|
|
|
|
