Proper study guides for Up to date Oracle Oracle Database 12c SQL Fundamentals certified begins with Oracle 1z0 061 practice test preparation products which designed to deliver the Best Quality oracle 1z0 061 questions by making you pass the oracle 1z0 061 test at your first time. Try the free oracle 1z0 061 demo right now.

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


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


Q13. You want to create a sales table with the following column specifications and data types: 

SALESID: Number STOREID: Number ITEMID: Number QTY: Number, should be set to 1 when no value is specified SLSDATE: Date, should be set to current date when no value is specified PAYMENT: Characters up to 30 characters, should be set to CASH when no value is specified 

Which statement would create the table? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer:


Q14. Examine the structure of the customers table: 

CUSTNO is the primary key in the table. You want to find out if any customers' details have been entered more than once using different CUSTNO, by listing all the duplicate names. 

Which two methods can you use to get the required result? 

A. Self-join 

B. Subquery 

C. Full outer-join with self-join 

D. Left outer-join with self-join 

E. Right outer-join with self-join 

Answer: A,B 


Q15. Examine the data in the CUST_NAME column of the customers table. 

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

Which query gives the required output? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer:


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

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

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

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

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

B. NUMBER 

C. TIMESTAMP 

D. INTERVAL DAY TO SECOND 

E. INTERVAL YEAR TO MONTH 

Answer:


Q17. 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? A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer: C,D 


Q18. View the Exhibit and examine the data in the promotions table. 

PROMO_BEGIN_DATE is stored in the default date format, dd-mon-rr. 

You need to produce a report that provides the name, cost, and start date of all promos in the post category that were launched before January 1, 2000. 

Which SQL statement would you use? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer:


Q19. 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:


Q20. In which three situations does a transaction complete? 

A. When a DELETE statement is executed 

B. When a ROLLBACK command is executed 

C. When a PL/SQL anonymous block is executed 

D. When a data definition language (DDL) statement is executed 

E. When a TRUNCATE statement is executed after the pending transaction 

Answer: B,D,E