Download Oracle Datbase 12c SQL.Pass4sures.1z0-071.2019-10-11.1e.152q.vcex

Download Dump

File Info

Exam Oracle Datbase 12c SQL
Number 1z0-071
File Name Oracle Datbase 12c SQL.Pass4sures.1z0-071.2019-10-11.1e.152q.vcex
Size 12.79 Mb
Posted October 11, 2019
Downloads 5
Download Oracle Datbase 12c SQL.Pass4sures.1z0-071.2019-10-11.1e.152q.vcex

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Purchase

Coupon: MASTEREXAM
With discount: 20%



 
 



Demo Questions

Question 1

View the exhibit and examine the structure of the STORES table. 

  

You must display the NAME of stores along with the ADDRESS, START_DATE, PROPERTY_PRICE, and the projected property price, which is 115% of property price. 
The stores displayed must have START_DATE in the range of 36 months starting from 01-Jan-2000 and above. 
Which SQL statement would get the desired output? 

  • A: SELECT name, concat (address| | ','| |city| |', ', country) AS full_address,
    start_date,
    property_price, property_price*115/100
    FROM stores
    WHERE MONTHS_BETWEEN (start_date, '01-JAN-2000') <=36;
  • B: SELECT name, concat (address| | ','| |city| |', ', country) AS full_address,
    start_date,
    property_price, property_price*115/100
    FROM stores
    WHERE TO_NUMBER(start_date-TO_DATE('01-JAN-2000','DD-MON-RRRR')) <=36;
  • C: SELECT name, address||', '||city||', '||country AS full_address, start_date,
    property_price, property_price*115/100
    FROM stores
    WHERE MONTHS_BETWEEN(start_date,TO_DATE('01-JAN-2000','DD-MON-RRRR')) <=36;
  • D: SELECT name, concat (address||','| |city| |', ', country) AS full_address,
    start_date,
    property_price, property_price*115/100
    FROM stores
    WHERE MONTHS_BETWEEN (start_date, TO_DATE('01-JAN-2000','DD-MON-RRRR')) <=36;

Correct Answer: D




Question 2

The BOOKS_TRANSACTIONS table exists in your database. 
SQL>SELECT * FROM books_transactions ORDER BY 3; 
What is the outcome on execution?

  • A: The execution fails unless the numeral 3 in the ORDER BY clause is replaced by a column name.
  • B: Rows are displayed in the order that they are stored in the table only for the three rows with the lowest values in the key column.
  • C: Rows are displayed in the order that they are stored in the table only for the first three rows.
  • D: Rows are displayed sorted in ascending order of the values in the third column in the table.

Correct Answer: D




Question 3

Examine the command:

  

What does ON DELETE CASCADE imply?

  • A: When the BOOKS table is dropped, the BOOK_TRANSACTIONS table is dropped.
  • B: When the BOOKS table is dropped, all the rows in the BOOK_TRANSACTIONS table are deleted but the table structure is retained.
  • C: When a row in the BOOKS table is deleted, the rows in the BOOK_TRANSACTIONS table whose BOOK_ID matches that of the deleted row in the BOOKS table are also deleted.
  • D: When a value in the BOOKS.BOOK_ID column is deleted, the corresponding value is updated in the BOOKS_TRANSACTIONS.BOOK_ID column.

Correct Answer: C




Question 4

View the exhibit and examine the structure of the EMPLOYEES table. 

  

You want to display all employees and their managers having 100 as the MANAGER_ID. You want the output in two columns: the first column would have the
LAST_NAME of the managers and the second column would have LAST_NAME of the employees. 
Which SQL statement would you execute? 

  • A: SELECT m.last_name "Manager", e.last_name "Employee"
    FROM employees m JOIN employees e
    ON m.employee_id = e.manager_id
    WHERE m.manager_id = 100;
  • B: SELECT m.last_name "Manager", e.last_name "Employee"
    FROM employees m JOIN employees e
    ON m.employee_id = e.manager_id
    WHERE e.manager_id = 100;
  • C: SELECT m.last_name "Manager", e.last_name "Employee"
    FROM employees m JOIN employees e
    ON e.employee_id = m.manager_id
    WHERE m.manager_id = 100;
  • D: SELECT m.last_name "Manager", e.last_name "Employee"
    FROM employees m JOIN employees e
    WHERE m.employee_id = e.manager_id AND e.manager_id = 100

Correct Answer: B




Question 5

Which three statements are true about multiple-row subqueries?

  • A: They can contain a subquery within a subquery.
  • B: They can return multiple columns as well as rows.
  • C: They cannot contain a subquery within a subquery.
  • D: They can return only one column but multiple rows.
  • E: They can contain group functions and GROUP BY and HAVING clauses.
  • F: They can contain group functions and the GROUP BY clause, but not the HAVING clause.

Correct Answer: ABE




Question 6

Evaluate the following SQL statements that are issued in the given order:
CREATE TABLE emp 
(emp_no NUMBER(2) CONSTRAINT emp_emp_no_pk PRIMARY KEY, 
ename VARCHAR2(15), 
salary NUMBER (8,2), 
mgr_no NUMBER(2) CONSTRAINT emp_mgr_fk REFERENCES emp(emp_no)); 
ALTER TABLE emp 
DISABLE CONSTRAINT emp_emp_no_pk CASCADE; 
ALTER TABLE emp 
ENABLE CONSTRAINT emp_emp_no_pk; 
What would be the status of the foreign key EMP_MGR_PK?

  • A: It would remain disabled and can be enabled only by dropping the foreign key constraint and recreating it.
  • B: It would remain disabled and has to be enabled manually using the ALTER TABLE command.
  • C: It would be automatically enabled and immediate.
  • D: It would be automatically enabled and deferred.

Correct Answer: B




Question 7

Which three statements are true regarding the data types? (Choose three.)

  • A: The minimum column width that can be specified for a VARCHAR2 data type column is one.
  • B: Only one LONG column can be used per table.
  • C: A TIMESTAMP data type column stores only time values with fractional seconds.
  • D: The BLOB data type column is used to store binary data in an operating system file.
  • E: The value for a CHAR data type column is blank-padded to the maximum defined column width.

Correct Answer: ABE




Question 8

Which three statements are true regarding subqueries? (Choose three.)

  • A: Multiple columns or expressions can be compared between the main query and subquery.
  • B: Subqueries can contain ORDER BY but not the GROUP BY clause.
  • C: Main query and subquery can get data from different tables.
  • D: Subqueries can contain GROUP BY and ORDER BY clauses.
  • E: Main query and subquery must get data from the same tables.
  • F: Only one column or expression can be compared between the main query and subquery.

Correct Answer: ACD

References:
http://docs.oracle.com/javadb/10.6.2.1/ref/rrefsqlj13658.html




Question 9

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.

Correct Answer: A




Question 10

Which statement is true about an inner join specified in a query’s WHERE clause?

  • A: It only applies for equijoin conditions. 
  • B: It applies for equijoin and nonequijoin conditions.
  • C: It requires column names to be the same in all tables being joined.
  • D: It must have primary-key and foreign-key constraints defined on the join columns.

Correct Answer: B










CONNECT US

Facebook

Twitter

PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount!



HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files