[Free] 2018(Jan) Latesttests Dumpsleader Oracle 1z0-051 Dumps with VCE and PDF Download 111-120

Latesttests 2018 Jan Oracle Official New Released 1z0-051
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/1z0-051.html

Oracle Database: SQL Fundamentals I

Question No: 111 – (Topic 1)

Which two statements are true regarding single row functions? (Choose two.)

  1. They can be nested only to two levels

  2. They always return a single result row for every row of a queried table

  3. Arguments can only be column values or constant

  4. They can return a data type value different from the one that is referenced

  5. They accept only a single argument

Answer: B,D Explanation:

A function is a program written to optionally accept input parameters, perform an operation, or return a single value. A function returns only one value per execution.

Three important components form the basis of defining a function. The first is the input parameter list. It specifies zero or more arguments that may be passed to a function as input for processing. These arguments or parameters may be of differing data types, and some are mandatory while others may be optional. The second component is the data type of its resultant value. Upon execution, only one value is returned by the function. The third encapsulates the details of the processing performed by the function and contains the program code that optionally manipulates the input parameters, performs calculations and operations, and generates a return value.

Question No: 112 – (Topic 1)

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

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

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

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

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. INTERVAL YEAR TO MONTH

  2. NUMBER

  3. TIMESTAMP

  4. DATE

  5. INTERVAL DAY TO SECOND

Answer: E

Question No: 113 – (Topic 1)

Latesttests 2018 PDF and VCE

Evaluate the following SQL statements: Exhibit:

Which is the correct output of the above query?

A. 00-300, 54-02, 00 11:12:10.123457

B. 00-300, 00-650, 00 11:12:10.123457

C. 25-00, 54-02, 00 11:12:10.123457

D. 25-00, 00-650, 00 11:12:10.123457

Answer: C

Question No: 114 – (Topic 1)

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

  1. It is executed first in the query execution.

  2. It must be the last clause in the SELECT statement.

  3. It cannot be used in a SELECT statement containing a HAVING clause.

  4. You cannot specify a column name followed by an expression in this clause.

  5. You can specify a combination of numeric positions and column names in this clause.

Answer: B,E

Question No: 115 – (Topic 1)

Latesttests 2018 PDF and VCE

Here is the structure and data of the CUST_TRANS table: Exhibit:

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

  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;

Answer: A,C,D

Question No: 116 – (Topic 1)

You work as a database administrator at ABC.com. You study the exhibit carefully. Exhibit:

Latesttests 2018 PDF and VCE

Which two SQL statements would execute successfully? (Choose two.)

A.

UPDATE promotions

SET promo_cost = promo_cost 100

WHERE TO_CHAR(promo_end_date, #39;yyyy#39;) gt; #39;2000#39;;

B.

SELECT promo_begin_date FROM promotions

WHERE TO_CHAR(promo_begin_date,#39;mon dd yy#39;)=#39;jul 01 98#39;;

C.

UPDATE promotions

SET promo_cost = promo_cost 100

WHERE promo_end_date gt; TO_DATE(SUBSTR(#39;01-JAN-2000#39;,8));

D.

SELECT TO_CHAR(promo_begin_date,#39;dd/month#39;) FROM promotions

WHERE promo_begin_date IN (TO_DATE(#39;JUN 01 98#39;), TO_DATE(#39;JUL 01 98#39;));

Answer: A,B

Question No: 117 – (Topic 1)

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:

Latesttests 2018 PDF and VCE

Which DELETE statement is valid?

  1. DELETE FROM employeesWHERE employee_id = (SELECT employee_id FROM employees);

  2. DELETE * FROM employeesWHERE employee_id=(SELECT employee_id FROM new_employees);

  3. DELETE FROM employeesWHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = ‘Carrey’);

  4. DELETE * FROM employeesWHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = ‘Carrey’);

Answer: C

Question No: 118 – (Topic 1)

View the Exhibit and examine the structure of the PROMOTIONS table. Examine the following two SQL statements:

Latesttests 2018 PDF and VCE

Which statement is true regarding the above two SQL statements?

Latesttests 2018 PDF and VCE

  1. statement 1 gives an error, statement 2 executes successfully

  2. statement 2 gives an error, statement 1 executes successfully

  3. statement 1 and statement 2 execute successfully and give the same output

  4. statement 1 and statement 2 execute successfully and give a different output

Answer: D

Question No: 119 – (Topic 1)

Latesttests 2018 PDF and VCE

The CUSTOMERS table has the following structure: Exhibit:

You need to write a query that does the following task:

  • Display the first name and tax amount of the customers. Tax is 5% of their credit limit

  • Only those customers whose income level has a value should be considered

  • Customers whose tax amount is null should not be considered Which statement accomplishes all the required tasks?

A.

SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND

tax_amount IS NOT NULL;

B.

SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND

cust_credit_limit IS NOT NULL;

C.

SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE cust_income_level lt;gt; NULL AND

tax_amount lt;gt; NULL;

D.

SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE (cust_income_level,tax_amount) IS NOT NULL;

Answer: B

Question No: 120 – (Topic 1)

Which three statements/commands would cause a transaction to end? (Choose three.)

  1. COMMIT

  2. SELECT

  3. CREATE

  4. ROLLBACK

  5. SAVEPOINT

Answer: A,C,D

100% Free Download!
Download Free Demo:1z0-051 Demo PDF
100% Pass Guaranteed!
Download 2018 Latesttests 1z0-051 Full Exam PDF and VCE

Latesttests 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

2018 Latesttests IT Certification PDF and VCE