Exam Code: 1Z0-061 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Oracle Database 12c SQL Fundamentals
Certification Provider: Oracle
Free Today! Guaranteed Training- Pass 1Z0-061 Exam.

2017 Mar 1Z0-061 question

Q11. You need to generate a list of all customer last names with their credit limits from the customers table. 

Those customers who do not have a credit limit should appear last in the list. 

Which two queries would achieve the required result? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer: B,C 

Explanation: 

If the ORDER BY clause is not used, the sort order is undefined, and the Oracle server may not fetch rows in the same order for the same query twice. Use the ORDER BY clause to display the rows in a specific order. Note: Use the keywords NULLS FIRST or NULLS LAST to specify whether returned rows containing null values should appear first or last in the ordering sequence. ANSWER C Sorting The default sort order is ascending: 

. Numeric values are displayed with the lowest values first (for example, 1 to 999). 

. Date values are displayed with the earliest value first (for example, 01-JAN-92 before 01-JAN-95). 

. Character values are displayed in the alphabetical order (for example, “A” first and “Z” last). 

. Null values are displayed last for ascending sequences and first for descending sequences. 

-ANSWER B 

. You can also sort by a column that is not in the SELECT list. 


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


Q13. Which three SQL statements would display the value 1890.55 as $1, 890.55? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

E. Option E 

Answer: A,D,E 


Q14. View the Exhibit for the structure of the student and faculty tables. 

You need to display the faculty name followed by the number of students handled by the faculty at the base location. 

Examine the following two SQL statements: Which statement is true regarding the outcome? 

A. Only statement 1 executes successfully and gives the required result. 

B. Only statement 2 executes successfully and gives the required result. 

C. Both statements 1 and 2 execute successfully and give different results. 

D. Both statements 1 and 2 execute successfully and give the same required result. 

Answer:


Q15. Examine the structure of the sales table: 

Evaluate the following create table statement: 

Which two statements are true about the creation of the SALES1 table? 

A. The SALES1 table is created with no rows but only a structure. 

B. The SALES1 table would have primary key and unique constraints on the specified columns. 

C. The SALES1 table would not be created because of the invalid where clause. 

D. The SALES1 table would have not null and unique constraints on the specified columns. 

E. The SALES1 table would not be created because column-specified names in the select and create table clauses do not match, 

Answer:


Up to the minute 1Z0-061 exam fees:

Q16. Which statement is true regarding the default behavior of the order by clause? 

A. In a character sort, the values are case-sensitive. 

B. NULL values are not considered at all by the sort operation. 

C. Only those columns that are specified in the select list can be used in the order by clause. 

D. Numeric values are displayed from the maximum to the minimum value if they have decimal positions. 

Answer:

Explanation: 

Character Strings and Dates 

Character strings and date values are enclosed with single quotation marks. 

Character values are case-sensitive and date values are format-sensitive. 

The default date display format is DD-MON-RR. 


Q17. Examine the structure of the products table: 

You want to display the names of the products that have the highest total value for UNIT_PRICE * QTY_IN_HAND. 

Which SQL statement gives the required output? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer:


Q18. Examine the data in the PROMO_BEGIN_DATE column of the promotions table: 

You want to display the number of promotions started in 1999 and 2000. Which query gives the correct output? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer:


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


Q20. CORRECT TEXT 

View the Exhibit and examine the structure of the promotions table. 

You need to generate a report of all promos from the promotions table based on the following conditions: 

1. The promo name should not begin with 'T' or 'N'. 

2. The promo should cost more than $20000. 

3. The promo should have ended after 1st January 2001. 

Which where clause would give the required result? 

Answer: WHERE promo_name NOT LIKE ‘T%’ AND promo_name NOT LIKE ‘N%’ AND promo_cost > 20000 AND promo_end_date > ‘1-JAN-01'