Oracle Oracle Certifications 1Z0-071 Questions & Answers

• Question 121:

  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.

  Correct Answer: BDF

• Question 122:

  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.

  Correct Answer: BD

• Question 123:

  Which two are true about self joins? (Choose two.)

  A. They can use INNER JOIN and LEFT JOIN.

  B. They require the EXISTS operator in the join condition.

  C. They require the NOT EXISTS operator in the join condition.

  D. They require table aliases.

  E. They have no join condition.

  F. They are always equijoins.

  Correct Answer: AD

• Question 124:

  Which four statements are true about constraints on Oracle tables? (Choose four.)

  A. A PRIMARY KEY constraint can be added after a table has been created and populated.

  B. A FOREIGN KEY column can contain NULLs.

  C. A CHECK constraint can refer to values in other rows.

  D. A NOT NULL constraint can be defined at the table level.

  E. A UNIQUE constraint can use a pre-existing index on the constrained column or columns.

  F. A UNIQUE constraint permits NULLs.

  G. A column can have only one CHECK constraint.

  Correct Answer: ABEF

• Question 125:

  Which three are true about the MERGE statement? (Choose three.)

  A. It can use subqueries to produce source rows.

  B. It can update the same row of the target table multiple times.

  C. It can update, insert, or delete rows conditionally in multiple tables.

  D. It can use views to produce source rows.

  E. It can merge rows only from tables.

  F. It can combine rows from multiple tables conditionally to insert into a single table.

  Correct Answer: ADF

• Question 126:

  Which three statements are true about defining relations between tables in a relational database? (Choose three.)

  A. Primary key columns allow null values.

  B. Every primary or unique key value must refer to a matching foreign key value.

  C. Every foreign key value must refer to a matching primary or unique key value.

  D. Foreign key columns allow null values.

  E. Unique key columns allow null values.

  Correct Answer: CDE

• Question 127:

  Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)

  A. Duplicates are eliminated automatically by the UNION ALL operator.

  B. The output is sorted by the UNION ALL operator.

  C. The names of columns selected in each SELECT statement must be identical.

  D. NULLs are not ignored during duplicate checking.

  E. The number of columns selected in each SELECT statement must be identical.

  Correct Answer: DE

• Question 128:

  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.

  Correct Answer: ABC

• Question 129:

  1.

  MANAGER is an existing role with no privileges or roles.

  2.

  EMP is an existing role containing the CREATE TABLE privilege.

  3.

  EMPLOYEES is an existing table in the HR schema.

  Which two commands execute successfully? (Choose two.)

  A. GRANT CREATE SEQUENCE TO manager, emp;

  B. GRANT CREATE TABLE, emp TO manager;

  C. GRANT CREATE ANY SESSION, CREATE ANY TABLE TO manager;

  D. GRANT SELECT, INSERT ON hr.employees TO manager WITH GRANT OPTION;

  E. GRANT CREATE TABLE, SELECT ON hr.employees TO manager;

  Correct Answer: AD

• Question 130:

  Which two statements will convert the string Hello World to ello world? (Choose two.)

  A. SELECT INITCAP(TRIM(`H' FROM `Hello World')) FROM DUAL;

  B. SELECT SUBSTR(`Hello World', 2) FROM DUAL;

  C. SELECT LOWER(SUBSTR(`Hello World', 2, 1)) FROM DUAL;

  D. SELECT LOWER(TRIM(`H' FROM `Hello World')) FROM DUAL;

  E. SELECT LOWER(SUBSTR(`Hello World', 2)) FROM DUAL;

  Correct Answer: DE