Test 1Z0-061 is called when Oracle is quite trained and favorite assessment connected with Oracle. Test Oracle 1Z0-061 is going to public claim that a individuals who are prosperous throughout check-up get excess standard capabilities and skills thats necessary to preserve and widen a venture product for you to remote sites having point of interest in safe guarding remote correct connected with gain access to and also access and customer arrangement and teleworkers.

2017 Mar 1Z0-061 real exam

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


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


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


Q24. Using the customers table, you need to generate a report that shows 50% of each credit amount in each income level. The report should NOT show any repeated credit amounts in each income level. 

Which query would give the required result? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer:

Explanation: Duplicate Rows Unless you indicate otherwise, SQL displays the results of a query without eliminating the duplicate rows. 

To eliminate duplicate rows in the result, include the DISTINCT keyword in the SELECT clause immediately after the SELECT keyword. 

You can specify multiple columns after the DISTINCT qualifier. The DISTINCT qualifier affects all the selected columns, and the result is every distinct combination of the columns. 


Q25. Which three tasks can be performed using SQL functions built into Oracle Database? 

A. Displaying a date in a nondefault format 

B. Finding the number of characters in an expression 

C. Substituting a character string in a text expression with a specified string 

D. Combining more than two columns or expressions into a single column in the output 

Answer: A,B,C 


Replace 1Z0-061 free exam:

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


Q27. Which statement adds a column called salary to the employees table having 100 rows, which cannot contain null? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer:

Reference: http://www.comp.nus.edu.sg/~ooibc/courses/sql/ddl_table.htm (see changing table structures) 


Q28. View the Exhibit and examine the structure of the product, component, and PDT_COMP tables. 

In product table, PDTNO is the primary key. 

In component table, COMPNO is the primary key. 

In PDT_COMP table, <PDTNO, COMPNO) is the primary key, PDTNO is the foreign key referencing PDTNO in product table and COMPNO is the foreign key referencing the COMPNO in component table. 

You want to generate a report listing the product names and their corresponding component names, if the component names and product names exist. 

Evaluate the following query: 

SQL>SELECT pdtno, pdtname, compno, compname 

FROM product _____________ pdt_comp 

USING (pdtno) ____________ component USING (compno) 

WHERE compname IS NOT NULL; 

Which combination of joins used in the blanks in the above query gives the correct output? 

A. JOIN; JOIN 

B. FULL OUTER JOIN; FULL OUTER JOIN 

C. RIGHT OUTER JOIN; LEFT OUTER JOIN 

D. LEFT OUTER JOIN; RIGHT OUTER JOIN 

Answer:


Q29. Examine the structure and data of the CUST_TRANS table: 

Dates are stored in the default date format dd-mon-rr in the CUST_TRANS table. Which three SQL statements would execute successfully? 

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 


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