Want to know Actualtests 1z0 061 dumps Exam practice test features? Want to lear more about Oracle Oracle Database 12c SQL Fundamentals certification experience? Study Realistic Oracle 1z0 061 practice test answers to Update oracle database 12c sql fundamentals 1z0 061 pdf free download questions at Actualtests. Gat a success with an absolute guarantee to pass Oracle 1z0 061 practice test (Oracle Database 12c SQL Fundamentals) test on your first attempt.

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


Q22. View the Exhibit and examine the description of SALES and PROMOTIONS tables. 

You want to delete rows from the sales table, where the PROMO_NAME column in the promotions table has either blowout sale of everyday low prices as values. 

Which three delete statements are valid? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer: B,C,D 


Q23. Examine the data in the ORD_ITEMS table: 

Evaluate the following query: 

Which statement is true regarding the outcome of the above query? 

A. It gives an error because the having clause should be specified after the group by clause. 

B. It gives an error because all the aggregate functions used in the having clause must be specified in the select list. 

C. It displays the item nos with their average quantity where the average quantity is more than double the minimum quantity of that item in the table. 

D. It displays the item nos with their average quantity where the average quantity is more than double the overall minimum quantity of all the items in the table. 

Answer:


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


Q25. Evaluate the following query: 

SQL> SELECT TRUNC(ROUND(156.00, -1), -1) 

FROM DUAL; 

What would be the outcome? 

A. 16 

B. 100 

C. 160 

D. 200 

E. 150 

Answer:

Explanation: 

Function Purpose ROUND(column|expression, n) Rounds the column, expression, or value to n decimal places or, if n is omitted, no decimal places (If n is negative, numbers to the left of decimal point are rounded.) TRUNC(column|expression, n) Truncates the column, expression, or value to n decimal places or, if n is omitted, n defaults to zero 


Q26. Which normal form is a table in if it has no multi-valued attributes and no partial dependencies? 

A. First normal form 

B. Second normal form 

C. Third normal form 

D. Fourth normal form 

Answer:


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


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


Q29. The customers table has the following structure: 

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

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

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

3. Customers whose tax amount is null should not be considered. 

Which statement accomplishes all the required tasks? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer:


Q30. View the Exhibit and examine the data in the products table. 

You need to display product names from the products table that belong to the 'software/other' category with minimum prices as either S2000 or S4000 and no unit of measure. 

You issue the following query: 

Which statement is true regarding the above query? 

A. It executes successfully but returns no result. 

B. It executes successfully and returns the required result. 

C. It generates an error because the condition specified for PROD_UNIT_OF_MEASURE is not valid. 

D. It generates an error because the condition specified for the prod category column is not valid. 

Answer: