Oracle 1Z0-071 Online Practice Questions and Exam Preparation

Oracle 1Z0-071 Online Questions & Answers

• Question 321:

  Examine the data in the COLORS table:

  

  Examine the data in the BRICKS table:

  

  Which two queries return all the rows from COLORS?

  

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

• Question 322:

  Examine the description of the PRODUCT_ STATUS table:

  

  The STATUS column contains the values IN STOCK or OUT OF STocK for each row. Which two queries will execute successfully?

  A. SELECT prod_id || q"'s not available" FROM product_status WHERE status = `OUT OF STOCK';
  B. SELECT prod_id || q'(`s not available)' `CURRENT AVAILABILITY' FROM product_status WHERE status = `OUT OF STOCK';
  C. SELECT prod_id q's not available" FROM product_status WHERE status = `OUT OF STOCK';
  D. SELECT prod_id "CURRENT AVAILABILITY" || q'(`s not available)' FROM product_status WHERE status = `OUT OF STOCK';
  E. SELECT prod_id || q'(`s not available)' FROM product_status WHERE status = `OUT OF STOCK';
  F. SELECT prod_id || q'(`s not available)' "CURRENT AVAILABILITY" FROM product status WHERE status = `OUT OF STOCK';
  E. SELECT prod_id || q'(`s not available)' FROM product_status WHERE status = `OUT OF STOCK';
  F. SELECT prod_id || q'(`s not available)' "CURRENT AVAILABILITY" FROM product status WHERE status = `OUT OF STOCK';

• Question 323:

  Examine the data in the COLORS table:

  

  Examine the data in the BRICKS table:

  

  Which three privileges can be restricted to a subset of columns in a taS?

  A. SELECT. FROM bricks b RIGHT JOIN colors c ON b. color _rgb_ hex_ value = c. rgb hex_ value;
  B. SELECT EROM colors C LEFT JOIN bricks USING (rgb _ hex_ value) ;
  C. SELECT FROM bricks b FULL JOIN colors C ON b. color rgb _ hex_ value = c. rgb _hex_ value;
  D. SELECT * EROM bricks | b JOIN colors C ON b. color_ rgb_ hex_ value =c. rgb _hex value;
  E. SELECT EROM colors C LEET JOIN bricks b ON b. color_ rgb_ hex value = c. rgb. hex. value WHERE b. brick_ id > 0;
  A. SELECT. FROM bricks b RIGHT JOIN colors c ON b. color _rgb_ hex_ value = c. rgb hex_ value;
  C. SELECT FROM bricks b FULL JOIN colors C ON b. color rgb _ hex_ value = c. rgb _hex_ value;

• Question 324:

  Which two statements are true regarding the SQL GROUP BY clause?

  A. You can use a column alias in the GROUP BY clause.
  B. Using the WHERE clause after the GROUP BY clause excludes rows after creating groups.
  C. The GROUP BY clause is mandatory if you are using an aggregating function in the SELECT clause.
  D. Using the WHERE clause before the GROUP BY clause excludes rows before creating groups.
  E. If the SELECT clause has an aggregating function, then columns without an aggregating function in the SELECT clause should be included in the GROUP BY clause.
  D. Using the WHERE clause before the GROUP BY clause excludes rows before creating groups.
  E. If the SELECT clause has an aggregating function, then columns without an aggregating function in the SELECT clause should be included in the GROUP BY clause.

• Question 325:

  Which two actions can you perform with object privileges?

  A. Create roles.
  B. Delete rows from tables in any schema except sys.
  C. Set default and temporary tablespaces for a user.
  D. Create FOREIGN KEY constraints that reference tables in other schemas.
  E. Execute a procedure or function in another schema.
  D. Create FOREIGN KEY constraints that reference tables in other schemas.
  E. Execute a procedure or function in another schema.

  ---

  Explanation/Reference:

  Reference: http://www.cruzroja.es/help/wvtdbobp.htm

• Question 326:

  You need to allow user ANDREW to:

  1.

  Modify the TITLE and ADDRESS columns of your CUSTOMERS table.

  2.

  GRANT tha permission to other users.

  Which statement will do this?

  A. GRANT UPDATE (title, address) ON customers TO andrew WITH ADMIN OPTION;
  B. GRANT UPDATE ON customers.title, customers.address TO andrew WITH GRANT OPTION;
  C. GRANT UPDATE ON customers.title, customers.address TO andrew WITH ADMIN OPTION;
  D. GRANT UPDATE (title, address) ON customers TO andrew;
  E. GRANT UPDATE ON customers. title, customers.address TO andrew;
  F. GRANT UPDATE (title, address) ON customers TO andrew WITH GRANT OPTION:
  B. GRANT UPDATE ON customers.title, customers.address TO andrew WITH GRANT OPTION;

• Question 327:

  Which three statements are true regarding single row subqueries?

  A. They must be placed on the left side of the comparison operator or condition.
  B. They must be placed on the right side of the comparison operator or condition.
  C. They must return a row to prevent errors in the SQL statement.
  D. A SQL statement may have multiple single row subquery blocks.
  E. They can be used in the HAVING clause.
  F. They can be used in the WHERE clause.
  D. A SQL statement may have multiple single row subquery blocks.
  E. They can be used in the HAVING clause.
  F. They can be used in the WHERE clause.

• Question 328:

  Examine the description of the PRODUCT_STATUS table:

  

  The STATUS column contains the values 'IN STOCK' or 'OUT OF STOCK' for each row.

  Which two queries will execute successfully?

  A. SELECT prod_id "CURRENT AVAILABILITY" || q'('s not available)' FROM product_status WHERE status = 'OUT OF STOCK';
  B. SELECT prod_id || q's not available'' FROM product_status WHERE status='OUT OF STOCK';
  C. SELECT prod_id || q'('s not available)' "CURRENT AVAILABILITY" FROM product_status WHERE status = 'OUT OF STOCK';
  D. SELECT prod_id || q'('s not available)' FROM product_status WHERE status = 'OUT OF STOCK';
  E. SELECT prod_id || q'('s not available)' 'CURRENT AVAILABILITY' FROM product_status WHERE status = 'OUT OF STOCK';
  F. SELECT prod_id || q"'s not available" FROM product_status WHERE status = 'OUT OF STOCK';
  C. SELECT prod_id || q'('s not available)' "CURRENT AVAILABILITY" FROM product_status WHERE status = 'OUT OF STOCK';
  D. SELECT prod_id || q'('s not available)' FROM product_status WHERE status = 'OUT OF STOCK';

• Question 329:

  Examine this incomplete query:

  SELECT DATA'2019-01-01'+

  FROM DUAL;

  Which three clauses can replaceti add 22 hours to the date?

  A. INTERVAL `12:00'
  B. INTERVAL'0,5'DAY
  C. INTERVAL'12' HOUR
  D. INTERVAL'720'MINUTE
  E. INTERVAL'0 12'DAY TO HOUR
  F. INTERVAL'11:60'HOUR TO MINUTE
  C. INTERVAL'12' HOUR
  D. INTERVAL'720'MINUTE
  E. INTERVAL'0 12'DAY TO HOUR

• Question 330:

  Examine these two queries and their output: SELECT deptno, dname FROM dept;

  

  SELECT ename, job, deptno FROM emp ORDER BY deptno;

  

  Now examine this query:

  SELECT ename, dname

  FROM emp CROSS JOIN dept WHERE job = andapos;MANAGERandapos;

  AND dept.deptno IN (10, 20) ;

  A. 64
  B. 6
  C. 3
  D. 12
  B. 6