Simulation of 1Z0-061 test preparation materials and samples for Oracle certification for client, Real Success Guaranteed with Updated 1Z0-061 pdf dumps vce Materials. 100% PASS Oracle Database 12c SQL Fundamentals exam Today!

2017 Jan 1Z0-061 exam prep

Q1. You want to display the date for the first Monday of the next month and issue the following command: 

What is the outcome? 

A. It executes successfully and returns the correct result. 

B. It executes successfully but does not return the correct result. 

C. It generates an error because TO_CHAR should be replaced with TO_DATE. 

D. It generates an error because rrrr should be replaced by rr in the format string. 

E. It generates an error because fm and double quotation marks should not be used in the format string. 

Answer:


Q2. Examine the structure proposed for the transactions table: 

Which two statements are true regarding the creation and storage of data in the above table structure? 

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. 


Q3. You execute the following commands: 

For which substitution variables are you prompted for the input? 

A. None, because no input required 

B. Both the substitution variables 'hiredate' and 'mgr_id\ 

C. Only 'hiredate' 

D. Only 'mgr_id' 

Answer:


Q4. Evaluate the following SQL statement: 

Which statement is true regarding the above query if one of the values generated by the subquery is null? 

A. It produces an error. 

B. It executes but returns no rows. 

C. It generates output for null as well as the other values produced by the subquery. 

D. It ignores the null value and generates output for the other values produced by the subquery. 

Answer:


Q5. Which statement is true regarding the UNION operator? 

A. By default, the output is not sorted. 

B. Null values are not ignored during duplicate checking. 

C. Names of all columns must be identical across all select statements. 

D. The number of columns selected in all select statements need not be the same. 

Answer:

Explanation: 

The SQL UNION query allows you to combine the result sets of two or more SQL SELECT statements. It removes duplicate rows between the various SELECT statements. Each SQL SELECT statement within the UNION query must have the same number of fields in the result sets with similar data types. 


Abreast of the times 1Z0-061 exam topics:

Q6. You want to display 5 percent of the rows from the sales table for products with the lowest AMOUNT_SOLD and also want to include the rows that have the same AMOUNT_SOLD even if this causes the output to exceed 5 percent of the rows. 

Which query will provide the required result? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer:


Q7. You issue the following command to alter the country column in the departments table: Which statement is true? 

A. It produces an error because column definitions cannot be altered to add default values. 

B. It executes successfully and all the rows that have a null value for the country column will be updated with the value 'USA'. 

C. It executes successfully. The modification to add the default value takes effect only from subsequent insertions to the table. 

D. It produces an error because the data type for the column is not specified. 

Answer:


Q8. Which create table statement is valid? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer:

Explanation: 

PRIMARY KEY Constraint A PRIMARY KEY constraint creates a primary key for the table. Only one primary key can be created for each table. The PRIMARY KEY constraint is a column or a set of columns that uniquely identifies each row in a table. This constraint enforces the uniqueness of the column or column combination and ensures that no column that is part of the primary key can contain a null value. Note: Because uniqueness is part of the primary key constraint definition, the Oracle server enforces the uniqueness by implicitly creating a unique index on the primary key column or columns. 


Q9. Examine the structure of the employees table: 

There is a parent/child relationship between EMPLOYEE_ID and MANAGER_ID. 

You want to display the name, joining date, and manager for all the employees. Newly hired employees are yet to be assigned a department or a manager. For them, 'No Manager1 should be displayed in the manager column. 

Which SQL query gets the required output? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer:

Reference: http://ivrainbow65.blogspot.com/ 


Q10. Examine the structure of the employees table. 

You want to display the maximum and minimum salaries of employees hired 1 year ago. Which two statements would get the correct output? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer: B,D 

Explanation: 

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z1 0.doc.sqlref%2Fsrc%2Ftpc%2Fdb2z_sql_subselectexamples.htm.