Oracle 1Z0-051 ExamOracle Database: SQL Fundamentals I

Total Question: 292 Last Updated: November 20,2017
  • Updated 1Z0-051 Dumps
  • Based on Real 1Z0-051 Exams Scenarios
  • Free 1Z0-051 pdf Demo Available
  • Check out our 1Z0-051 Dumps in a new PDF format
  • Instant 1Z0-051 download
  • Guarantee 1Z0-051 success in first attempt

Price: $65.95 $29.99

Buy Now Free Trial

Key benefits of 1z0 051 dumps

Master the 1z0 051 latest dumps free download pdf Oracle Database: SQL Fundamentals I content and be ready for exam day success quickly with this Ucertify 1z0 051 latest dumps free download pdf test question. We guarantee it!We make it a reality and give you real 1z0 051 practice test questions in our Oracle 1z0 051 dumps braindumps.Latest 100% VALID Oracle 1z0 051 dumps Exam Questions Dumps at below page. You can use our Oracle 1z0 051 pdf braindumps and pass your exam.

Q101. - (Topic 2) 

View the Exhibit and examine the data in the PROMO_NAME and PROMO_END_DATE columns of the PROMOTIONS table, and the required output format. 

Which two queries give the correct result? (Choose two.) 

A. SELECT promo_name, TO_CHAR(promo_end_date,'Day') ', ' 

TO_CHAR(promo_end_date,'Month') ' ' 

TO_CHAR(promo_end_date,'DD, YYYY') AS last_day 

FROM promotions; 

B. SELECT promo_name,TO_CHAR (promo_end_date,'fxDay') ', ' 

TO_CHAR(promo_end_date,'fxMonth') ' ' 

TO_CHAR(promo_end_date,'fxDD, YYYY') AS last_day 

FROM promotions; 

C. SELECT promo_name, TRIM(TO_CHAR(promo_end_date,'Day')) ', ' TRIM(TO_CHAR 

(promo_end_date,'Month')) ' ' 

TRIM(TO_CHAR(promo_end_date,'DD, YYYY')) AS last_day 

FROM promotions; 

D. SELECTpromo_name,TO_CHAR(promo_end_date,'fmDay')',' 

TO_CHAR(promo_end_date,'fmMonth') ' ' 

TO_CHAR(promo_end_date,'fmDD, YYYY') AS last_day 

FROM promotions; 

Answer: C,D 


Q102. - (Topic 1) 

View the Exhibit and examine the structure of the PROMOTIONS table. Which SQL statements are valid? (Choose all that apply.) 

A. SELECT promo_id. DECODE(NVL(promo_cost.O).promo_cost * 0.25. 100) "Discount" 

FROM promotions; 

B. SELECT promo id. DECODE(promo_cost. 10000. 

DECODE(promo_category. 'Gl\\ 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; 

Answer: A,B 

Explanation: 

Note: there are some syntax issues in this question. 


Q103. - (Topic 1) 

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:


Q104. - (Topic 2) 

Which object privileges can be granted on a view? 

A. none 

B. DELETE, INSERT,SELECT 

C. ALTER, DELETE, INSERT, SELECT 

D. DELETE, INSERT, SELECT, UPDATE 

Answer:

Explanation: Object privilege on VIEW is DELETE, INSERT, REFERENCES, SELECT and UPDATE. 

Incorrect Answer: AObject privilege on VIEW is DELETE, INSERT, REFERENCES, SELECT and UPDATE BObject privilege on VIEW is DELETE, INSERT, REFERENCES, SELECT and UPDATE CObject privilege on VIEW is DELETE, INSERT, REFERENCES, SELECT and UPDATE 

Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 13-12 


Q105. - (Topic 2) 

Examine the data in the CUST_NAME column of the CUSTOMERS table. CUST_NAME 

Renske Ladwig Jason Mallin Samuel McCain Allan MCEwen Irene Mikkilineni Julia Nayer 

You need to display customers' second names where the second name starts with "Mc" or "MC." 

Which query gives the required output? 

A. SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1) 

FROM customers 

WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ')+1))='Mc' 

B. SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1) 

FROM customers 

WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ')+1)) LIKE 'Mc%' 

C. SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1) 

FROM customers 

WHERE SUBSTR(cust_name, INSTR(cust_name,' ')+1) LIKE INITCAP('MC%'); 

D. SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1) 

FROM customers 

WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ')+1)) = INITCAP('MC%'); 

Answer:


Q106. - (Topic 1) 

Evaluate the SQL statement: 

TRUNCATE TABLE DEPT; 

Which three are true about the SQL statement? (Choose three.) 

A. It releases the storage space used by the table. 

B. It does not release the storage space used by the table. 

C. You can roll back the deletion of rows after the statement executes. 

D. You can NOT roll back the deletion of rows after the statement executes. 

E. An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error. 

F. You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table 

Answer: A,D,F 

Explanation: 

A: The TRUNCATE TABLE Statement releases storage space used by the table, 

D: Can not rollback the deletion of rows after the statement executes, 

F: You must be the owner of the table or have DELETE ANY TABLE system privilege to truncate the DEPT table. 

Incorrect Answer: Cis not true Dis not true Eis not true 

Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 8-18 


Q107. - (Topic 1) 

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.) 

A. SELECT transdate + '10' FROM cust_trans; 

B. SELECT * FROM cust_trans WHERE transdate = '01-01-07' 

C. SELECT transamt FROM cust_trans WHERE custno > '11' 

D. SELECT * FROM cust_trans WHERE transdate='01-JANUARY-07' 

E. SELECT custno + 'A' FROM cust_trans WHERE transamt > 2000; 

Answer: A,C,D 


Q108. - (Topic 2) 

Which statement describes the ROWID data type? 

A. Binary data up to 4 gigabytes. 

B. Character data up to 4 gigabytes. 

C. Raw binary data of variable length up to 2 gigabytes. 

D. Binary data stored in an external file, up to 4 gigabytes. 

E. A hexadecimal string representing the unique address of a row in its table. 

Answer:

Explanation: 

The ROWID datatype stores information related to the disk location of table rows. They 

also uniquely identify the rows in your table. The ROWID datatype is stored as a 

hexadecimal string. 

Incorrect Answers 

A:It is not a binary data. The ROWID datatype is a hexadecimal string. 

B:It is not a character data. The ROWID datatype is a hexadecimal string. 

C:It is not a raw binary data. The ROWID datatype is a hexadecimal string. 

D:It is not binary data stored in an external file. The ROWID datatype is a hexadecimal 

string. 

OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 216 

Chapter 5: Creating Oracle Database Objects 


Q109. - (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? 

A. INTERVAL YEAR TO MONTH 

B. NUMBER 

C. TIMESTAMP 

D. DATE 

E. INTERVAL DAY TO SECOND 

Answer:


Q110. - (Topic 1) 

Which three SQL statements would display the value 1890.55 as $1,890.55? (Choose three.) 

A. 

SELECT TO_CHAR(1890.55,'$99G999D00') FROM DUAL; 

B. 

SELECT TO_CHAR(1890.55,'$9,999V99') FROM DUAL; 

C. 

SELECT TO_CHAR(1890.55,'$0G000D00') FROM DUAL; 

D. 

SELECT TO_CHAR(1890.55,'$99G999D99') 

FROM DUAL; 

E. 

SELECT TO_CHAR(1890.55,'$9,999D99') FROM DUAL; 

Answer: A,C,D 


Related 1Z0-051 Articles

best-it-exam-    | for-our-work-    | hottst-on-sale-    | it-sale-    | tast-dumps-us-    | test-king-number-    | pass-do-it-    | just-do-it-    | pass-with-us-    | passresults-everything-    | passtutor-our-dumps-    | realtests-us-exam-    | latest-update-source-for-    | cbtnuggets-sale-exam    | experts-revised-exam    | certguide-sale-exam    | test4actual-sale-exam    | get-well-prepared-    | certkiller-sale-exam    | buy-discount-dumps    | how-to-get-prepared-for-the    | in-an-easy-way    | brain-dumps-sale    | with-pass-exam-guarantee    | accurate-study-material    | at-first-try    | 100%-successful-rate    | get-certification-easily    | material-provider-exam    | real-exam-practice    | with-pass-score-guarantee    | certification-material-provider    | for-certification-professionals    | get-your-certification-successfully    | 100%-Pass-Rate    | in-pdf-file    | practice-exam-for    | it-study-guides    | study-material-sku    | study-guide-pdf    | prep-guide-demo    | certification-material-id    | actual-tests-demo    | brain-demos-test    | best-pdf-download    | our-certification-material    | best-practice-test    | leading-provider-on    | this-course-is-about    | the-most-reliable    | high-pass-rate-of    | money-back-guarantee    | high-pass-rate-demo    | recenty-updated-key    | only-for-students-free-download    | courseware-plus-kit-for    | accurate-answers-of    | the-most-reliable-id    | provide-training-for    | welcome-to-buy    | material-for-success-pass    | provide-free-support    | best-book-for-pass    | accuracy-of-the-answers    | pass-guarantee-id    |
http://forensics.sch.ac.kr/    | http://forensics.sch.ac.kr/    |