It is more faster and easier to pass the Oracle 1Z0-061 exam by using 100% Correct Oracle Oracle Database 12c SQL Fundamentals questuins and answers. Immediate access to the Updated 1Z0-061 Exam and find the same core area 1Z0-061 questions with professionally verified answers, then PASS your exam with a high score now.

2016 Nov 1Z0-061 exam question

Q21. You issued the following command: 

SQL> DROP TABLE employees; 

Which three statements are true? 

A. All uncommitted transactions are committed. 

B. All indexes and constraints defined on the table being dropped are also dropped. 

C. Sequences used in the employees table become invalid. 

D. The space used by the employees table is reclaimed immediately. 

E. The employees table can be recovered using the rollback command. 

F. The employees table is moved to the recycle bin. 

Answer: B,C,F 

Reference: http://www.sqlcourse.com/drop.html 


Q22. In the customers table, the CUST_CITY column contains the value 'Paris' for the CUST_FIRST_NAME 'Abigail'. 

Evaluate the following query: 

What would be the outcome? 

A. Abigail PA 

B. Abigail Pa 

C. Abigail IS 

D. An error message 

Answer:


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


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

Evaluate the following SQL statement: 

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

A. It shows COST_REMARK for all the promos in the table. 

B. It produces an error because the SUBQUERY gives an error. 

C. It shows COST_REMARK for all the promos in the promo category 'TV' 

D. It produces an error because SUBQUERIES cannot be used with the case expression. 

Answer:


Q25. View the Exhibits and examine the structures of the products, sales, and customers tables. 

You need to generate a report that gives details of the customer's last name, name of the product, and the quantity sold for a customers in 'Tokyo'. 

Which two queries give the required result? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer: A,C 


Most recent 1Z0-061 exam answers:

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


Q27. You issue the following command to drop the products table: 

SQL> DROP TABLE products; 

Which three statements are true about the implication of this command? 

A. All data along with the table structure is deleted. 

B. A pending transaction in the session is committed. 

C. All indexes on the table remain but they are invalidated. 

D. All views and synonyms remain but they are invalidated. 

E. All data in the table is deleted but the table structure remains. 

Answer: A,B,D 


Q28. View the Exhibits and examine products and sales tables. 

You issue the following query to display product name and the number of times the product has been sold: 

What happens when the above statement is executed? 

A. The statement executes successfully and produces the required output. 

B. The statement produces an error because item_cnt cannot be displayed in the outer query. 

C. The statement produces an error because a subquery in the from clause and outer-joins cannot be used together. 

D. The statement produces an error because the group by clause cannot be used in a subquery in the from clause. 

Answer:


Q29. 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' 


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