Oracle 1Z0-071 Online Practice Questions and Exam Preparation

Oracle 1Z0-071 Online Questions & Answers

• Question 241:

  Which three actions can you perform only with system privileges? (Choose three.)

  A. Query any table in a database.
  B. Execute a procedure in another schema.
  C. Log in to a database instance.
  D. Access flat files, which are stored in an operating system directory, via the UTL_FILE package.
  E. Use the WITH GRANT OPTION clause.
  A. Query any table in a database.
  B. Execute a procedure in another schema.
  C. Log in to a database instance.

• Question 242:

  Which two statements are true about * _TABLES views?

  A. You must have ANY TABLE system privileges, or be granted object privilges on the table, to viewa tabl e in DBA TABLES.
  B. USER TABLES displays all tables owned by the current user.
  C. You must have ANY TABLE system privileges, or be granted object privileges on the table, to view a table in USER_TABLES.
  D. ALL TABLES displays all tables owned by the current user.
  E. You must have ANY TABLE system privileges, or be granted object privileges on the table, to view a table in ALL_TABLES.
  F. All users can query DBA_TABLES successfully.
  A. You must have ANY TABLE system privileges, or be granted object privilges on the table, to viewa tabl e in DBA TABLES.
  B. USER TABLES displays all tables owned by the current user.

• Question 243:

  View the Exhibit and examine the structure in the EMPLOYEES tables.

  

  Evaluate the following SQL statement:

  SELECT employee_id, department_id FROM employees WHERE department_id= 50 ORDER BY department_id UNION SELECT employee_id, department_id FROM employees WHERE department_id=90 UNION SELECT employee_id, department_id FROM employees WHERE department_id=10;

  What would be the outcome of the above SQL statement?

  A. The statement would not execute because the positional notation instead of the column name should be used with the ORDER BY clause.
  B. The statement would execute successfully and display all the rows in the ascending order of DEPARTMENT_ID.
  C. The statement would execute successfully but it will ignore the ORDER BY clause and display the rows in random order.
  D. The statement would not execute because the ORDER BY clause should appear only at the end of the SQL statement, that is, in the last SELECT statement.
  D. The statement would not execute because the ORDER BY clause should appear only at the end of the SQL statement, that is, in the last SELECT statement.

• Question 244:

  Viev the Exhibit and examine the structure of the PRODUCT INFORMATION and INVENTORIEStables.

  

  You have a requirement from the supplies department to give a list containing PRODUCT _ID,SUPPLIER ID, and QUANTITY_ON HAND for all the products where in QUANTITY ON HAND is lessthan five.

  Which two SQL statements can accomplish the task? (Choose two)

  A. SELECT product id, quantity on hand, supplier id FROM product information NATURAL JOIN inventories AND quantity .on hand < 5;
  B. SELECT i. product id, i. quantity .on hand, pi. supplier_id FROM product_information pi JOIN inventories i ON (pi. product. id=i. product id) AND quantity on hand < 5;
  C. SELECT i. product_id, i. quantity_on hand, pi. supplier id FROM product information pi JOIN inventories i USING (product id) AND quantity .on hand < 5;
  D. SELECT i.product id, i. quantity on hand, pi. supplier id FROM product information pi JOIN inventories i ON (pi.product id=i. product id)WHERE quantity on hand < 5;
  B. SELECT i. product id, i. quantity .on hand, pi. supplier_id FROM product_information pi JOIN inventories i ON (pi. product. id=i. product id) AND quantity on hand < 5;
  D. SELECT i.product id, i. quantity on hand, pi. supplier id FROM product information pi JOIN inventories i ON (pi.product id=i. product id)WHERE quantity on hand < 5;

• Question 245:

  Which three are true about subqueries? (Choose three.)

  A. A subquery cannot be used in the select list.
  B. < ANY returns true if the argument is less than the highest value returned by the subquery.
  C. < ANY returns true if the argument is less than the lowest value returned by the subquery.
  D. A subquery can be used in a HAVING clause.
  E. A subquery cannot be used in a FROM clause.
  F. A subquery can be used in a WHERE clause.
  G. = ANY can only evaluate the argument against a subquery if it returns two or more values.
  B. < ANY returns true if the argument is less than the highest value returned by the subquery.
  D. A subquery can be used in a HAVING clause.
  F. A subquery can be used in a WHERE clause.

• Question 246:

  Which two statements are true about Entity Relationships? (Choose two.)

  A. A one-to-one relationship is always a self-referencing relationship.
  B. A relationship can be mandatory for both entities.
  C. A many-to-many relationship can be implemented only by using foreign keys.
  D. A one-to-many relationship in one direction is a one-to-one relationship in the other direction.
  E. A table name can be specified just once when selecting data from a table having a self-referencing relationship.
  B. A relationship can be mandatory for both entities.
  D. A one-to-many relationship in one direction is a one-to-one relationship in the other direction.

• Question 247:

  You need to calculate the number of days from 1st January 2019 until today.

  Dates are stored in the default format of DD-MON-RR.

  Which two queries give the required output? (Choose two.)

  A. SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY') - '01-JAN-2019' FROM
  B. SELECT ROUND(SYSDATE - '01-JAN-2019') FROM DUAL;
  C. SELECT ROUND(SYSDATE ?TO_DATE('01/JANUARY/2019')) FROM DUAL;
  D. SELECT TO_DATE(SYSDATE, 'DD/MONTH/YYYY') - '01/JANUARY/2019' FROM DUAL;
  E. SELECT SYSDATE - TO_DATE('01-JANUARY-2019') FROM DUAL;
  C. SELECT ROUND(SYSDATE ?TO_DATE('01/JANUARY/2019')) FROM DUAL;
  E. SELECT SYSDATE - TO_DATE('01-JANUARY-2019') FROM DUAL;

• Question 248:

  Which two are true about the WITH GRANT OPTION clause? (Choose two.)

  A. It can be used for system and object privileges.
  B. The grantee can grant the object privilege to any user in the database, with or without including this option.
  C. The grantee must have the GRANT ANY OBJECT PRIVILEGE system privilege to use this option.
  D. It cannot be used to pass on privileges to PUBLIC by the grantee.
  E. It can be used when granting privileges to roles.
  F. It can be used to pass on privileges to other users by the grantee.
  B. The grantee can grant the object privilege to any user in the database, with or without including this option.
  F. It can be used to pass on privileges to other users by the grantee.

• Question 249:

  Examine this Statement Which returns the name of each employee and their manager,

  

  You want to extend the query to include employees with no manager.

  What must you add before JOIN to do this?

  A. CROSS
  B. FULL OUTER
  C. LEFT OUTER
  D. RIGHT OUTER
  C. LEFT OUTER

• Question 250:

  Examine data in the BRICKS table:

  

  Examine the BOXES table:

  

  Which two queries only return CUBE? (Choose two.)

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  E. Option E
  C. Option C
  D. Option D