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