Proper study guides for Renovate Oracle Oracle Database: SQL Fundamentals I certified begins with Oracle 1z0 051 dumps preparation products which designed to deliver the Printable 1z0 051 latest dumps free download pdf questions by making you pass the 1z0 051 pdf test at your first time. Try the free oracle 1z0 051 demo right now.


♥♥ 2018 NEW RECOMMEND ♥♥

Free VCE & PDF File for Oracle 1Z0-051 Real Exam (Full Version!)

★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions

Free Instant Download NEW 1Z0-051 Exam Dumps (PDF & VCE):
Available on: http://www.surepassexam.com/1Z0-051-exam-dumps.html

Q31. - (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 


Q32. - (Topic 1) 

Which view should a user query to display the columns associated with the constraints on a table owned by the user? 

A. USER_CONSTRAINTS 

B. USER_OBJECTS 

C. ALL_CONSTRAINTS 

D. USER_CONS_COLUMNS 

E. USER_COLUMNS 

Answer:

Explanation: view the columns associated with the constraint names in the USER_CONS_COLUMNS view. Incorrect Answer: Atable to view all constraints definition and names Bshow all object name belong to user Cdoes not display column associated Eno such view 

Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 10-25 


Q33. - (Topic 2) 

Examine the structure proposed for the TRANSACTIONS table: 

Which statements are true regarding the creation and storage of data in the above table structure? (Choose all that apply.) 

A. The CUST_STATUS column would give an error. 

B. The TRANS_VALIDITY column would give an error. 

C. The CUST_STATUS column would store exactly one character. 

D. The CUST_CREDIT_LIMIT column would not be able to store decimal values. 

E. The TRANS_VALIDITY column would have a maximum size of one character. 

F. The TRANS_DATE column would be able to store day, month, century, year, hour, minutes, seconds, and fractions of seconds. 

Answer: B,C 

Explanation: 

VARCHAR2(size)Variable-length character data (A maximum size must be specified: 

minimum size is 1; maximum size is 4,000.) 

CHAR [(size)] Fixed-length character data of length size bytes (Default and minimum size 

is 1; maximum size is 2,000.) 

NUMBER [(p,s)] Number having precision p and scale s (Precision is the total number of 

decimal digits and scale is the number of digits to the right of the decimal point; precision 

can range from 1 to 38, and scale can range from –84 to 127.) 

DATE Date and time values to the nearest second between January 1, 4712 B.C., and 

December 31, 9999 A.D. 


Q34. - (Topic 2) 

The CUSTOMERS table has these columns: 

A promotional sale is being advertised to the customers in France. Which WHERE clause identifies customers that are located in France? 

A. WHERE lower(country_address) = "france" 

B. WHERE lower(country_address) = 'france' 

C. WHERE lower(country_address) IS 'france' 

D. WHERE lower(country_address) = '%france%' 

E. WHERE lower(country_address) LIKE %france% 

Answer:

Explanation: 

WHERE lower(country_address)=’france’ 

Incorrect Answer: Ainvalid use of symbol “” Cinvalid use of IS keyword Dinvalid use of % in condition Einvalid use of condition Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 2-12 


Q35. - (Topic 2) 

View the Exhibits and examine the structures of the PRODUCTS and SALES tables. Which two SQL statements would give the same output? (Choose two.) 

A. 

SELECT prod_id FROM products INTERSECT SELECT prod_id FROM sales; 

B. 

SELECT prod_id FROM products MINUS SELECT prod_id FROM sales; 

C. 

SELECT DISTINCT p.prod_id FROM products p JOIN sales s ON p.prod_id=s.prod_id; 

D. 

SELECT DISTINCT p.prod_id FROM products p JOIN sales s ON p.prod_id <> s.prod_id; 

Answer: A,C 


Q36. - (Topic 1) 

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

Which statement is true regarding the above two SQL statements? 

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

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

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

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

Answer:


Q37. - (Topic 1) 

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

A. They can be nested only to two levels 

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

C. Arguments can only be column values or constant 

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

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


Q38. - (Topic 2) 

Evaluate the SQL statement: 

SELECT LPAD (salary,10,’*’) 

FROM EMP 

WHERE EMP_ID = 1001; 

If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed? 

A. 17000.00 

B. 17000***** 

C. ****170.00 

D. **17000.00 

E. an error statement 

Answer:


Q39. - (Topic 2) 

In which four clauses can a sub query be used? (Choose four.) 

A. in the INTO clause of an INSERT statement 

B. in the FROM clause of a SELECT statement 

C. in the GROUP BY clause of a SELECT statement 

D. in the WHERE clause of a SELECT statement 

E. in the SET clause of an UPDATE statement 

F. in the VALUES clause of an INSERT statement 

Answer: A,B,D,E 

Explanation: 

A: a sub query is valid on the INTO clause of an ISERT Statement 

B: a sub query can be used in the FROM clause of a SELECT statement 

D: a sub query can be used in the WHERE clause of a SELECT statement, 

E: a sub query can be used in the SET clauses of an UPDATE statement, 

Incorrect Answer: 

Csub query cannot be used 

F: is incorrect. 

Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 6-5 


Q40. - (Topic 1) 

Which statement is true regarding the INTERSECT operator? 

A. It ignores NULL values 

B. The number of columns and data types must be identical for all SELECT statements in the query 

C. The names of columns in all SELECT statements must be identical 

D. Reversing the order of the intersected tables the result 

Answer:

Explanation: 

INTERSECT Returns only the rows that occur in both queries’ result sets, sorting them and 

removing duplicates. 

The columns in the queries that make up a compound query can have different names, but 

the output result set will use the names of the columns in the first query.