Download Oracle.1z0-071.Pass4Sure.2019-10-11.152q.vcex

Download Exam

File Info

Exam Oracle Datbase 12c SQL
Number 1z0-071
File Name Oracle.1z0-071.Pass4Sure.2019-10-11.152q.vcex
Size 13 MB
Posted Oct 11, 2019
Download Oracle.1z0-071.Pass4Sure.2019-10-11.152q.vcex

How to open VCEX & EXAM Files?

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

Download
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? 


  1. 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;
  2. 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;
  3. 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;
  4. 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?


  1. The execution fails unless the numeral 3 in the ORDER BY clause is replaced by a column name.
  2. 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.
  3. Rows are displayed in the order that they are stored in the table only for the first three rows.
  4. 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?


  1. When the BOOKS table is dropped, the BOOK_TRANSACTIONS table is dropped.
  2. When the BOOKS table is dropped, all the rows in the BOOK_TRANSACTIONS table are deleted but the table structure is retained.
  3. 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.
  4. 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? 


  1. 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;
  2. 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;
  3. 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;
  4. 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?


  1. They can contain a subquery within a subquery.
  2. They can return multiple columns as well as rows.
  3. They cannot contain a subquery within a subquery.
  4. They can return only one column but multiple rows.
  5. They can contain group functions and GROUP BY and HAVING clauses.
  6. 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?


  1. It would remain disabled and can be enabled only by dropping the foreign key constraint and recreating it.
  2. It would remain disabled and has to be enabled manually using the ALTER TABLE command.
  3. It would be automatically enabled and immediate.
  4. It would be automatically enabled and deferred.
Correct answer: B



Question 7

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


  1. The minimum column width that can be specified for a VARCHAR2 data type column is one.
  2. Only one LONG column can be used per table.
  3. A TIMESTAMP data type column stores only time values with fractional seconds.
  4. The BLOB data type column is used to store binary data in an operating system file.
  5. The value for a CHAR data type column is blank-padded to the maximum defined column width.
Correct answer: ABE
Explanation:



Question 8

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


  1. Multiple columns or expressions can be compared between the main query and subquery.
  2. Subqueries can contain ORDER BY but not the GROUP BY clause.
  3. Main query and subquery can get data from different tables.
  4. Subqueries can contain GROUP BY and ORDER BY clauses.
  5. Main query and subquery must get data from the same tables.
  6. Only one column or expression can be compared between the main query and subquery.
Correct answer: ACD
Explanation:
References:http://docs.oracle.com/javadb/10.6.2.1/ref/rrefsqlj13658.html
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?


  1. In a character sort, the values are case-sensitive.
  2. NULL values are not considered at all by the sort operation.
  3. Only those columns that are specified in the SELECT list can be used in the ORDER BY clause.
  4. 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?


  1. It only applies for equijoin conditions. 
  2. It applies for equijoin and nonequijoin conditions.
  3. It requires column names to be the same in all tables being joined.
  4. 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!

Get Now!


HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files