Oracle Oracle Certifications 1Z0-071 Questions & Answers

• Question 151:

  Which two statements are true about the DUAL table: (Choose two.)

  A. It can display multiple rows but only a single column.

  B. It can be accessed only by the SYS user.

  C. It can be accessed by any user who has the SELECT privilege in any schema.

  D. It can display multiple rows and columns.

  E. It consists of a single row and single column of VARCHAR2 data type.

  F. It can be used to display only constants or pseudo columns.

  Correct Answer: CE

• Question 152:

  Examine this SQL statement:

  

  Which two are true? (Choose two.)

  A. The DELETE statement executes successfully even if the subquery selects multiple rows.

  B. The subquery is executed before the DELETE statement is executed.

  C. The subquery is not a correlated subquery.

  D. All existing rows in the EMPLOYEES table are deleted.

  E. The subquery is executed for every row in the EMPLOYEES table.

  Correct Answer: AE

• Question 153:

  What is true about non-equijoin statement performance? (Choose two.)

  A. The BETWEEN condition always performs less well than using the >= and <= conditions.

  B. The BETWEEN condition always performs better than using the >= and <= conditions.

  C. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.

  D. Table aliases can improve performance.

  E. The join syntax used makes no difference to performance.

  Correct Answer: DE

• Question 154:

  Which two are true about transactions in the Oracle Database? (Choose two.)

  A. DML statements always start new transactions.

  B. DDL statements automatically commit only data dictionary updates caused by executing the DDL.

  C. A session can see uncommitted updates made by the same user in a different session.

  D. A DDL statement issued by a session with an uncommitted transaction automatically commits that transaction.

  E. An uncommitted transaction is automatically committed when the user exits SQL*Plus.

  Correct Answer: DE

• Question 155:

  Which two are true about granting object privileges on tables, views, and sequences? (Choose two.)

  A. INSERT can be granted only on tables and sequences.

  B. DELETE can be granted on tables, views, and sequences.

  C. SELECT can be granted on tables, views, and sequences.

  D. ALTER can be granted only on tables and sequences.

  E. REFERENCES can be granted only on tables.

  Correct Answer: CD

• Question 156:

  Which three statements about roles are true? (Choose three.)

  A. Roles are assigned to users using the ALTER USER statement.

  B. Privileges are assigned to a role using the GRANT statement.

  C. A role is a named group of related privileges that can only be assigned to a user.

  D. A single user can be assigned multiple roles.

  E. Privileges are assigned to a role using the ALTER ROLE statement.

  F. Roles are assigned to roles using the ALTER ROLE statement.

  G. A single role can be assigned to multiple users.

  Correct Answer: BDG

• Question 157:

  An Oracle Database session has an uncommitted transaction in progress which updated 5000 rows in a table. In which three situations does the transaction complete thereby committing the updates? (Choose three.)

  A. when a CREATE TABLE AS SELECT statement is issued in the same session but fails with a syntax error

  B. when a DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the user then issues a COMMIT

  C. when the session logs out successfully

  D. when a CREATE INDEX statement is executed successfully in the same session

  E. when a DBA issues a successful SHUTDOWN IMMEDIATE statement and the user then issues a COMMIT

  F. when a COMMIT statement is issued by the same user from another session in the same database instance

  Correct Answer: BCD

• Question 158:

  Which two are true about global temporary tables? (Choose two.)

  A. Indexes can be created on them.

  B. Backup and recovery operations are available for these tables.

  C. Their data is always stored in the default temporary tablespace of the user who created them.

  D. If the ON COMMIT clause is transaction-specific, all rows in the table are deleted after each COMMIT OR ROLLBACK.

  E. They can be created only by a user with the DBA role, but can be accessed by all users who can create a session.

  F. If the ON COMMIT clause is session-specific, the table is dropped when the session is terminated.

  Correct Answer: AD

• Question 159:

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

  A. A combination of object and system privileges can be granted to a role.

  B. All types of schema objects have associated object privileges.

  C. Schema owners can grant object privileges on objects in their schema to any other user or role.

  D. Only users with the DBA role can create roles.

  E. Only users with the GRANT ANY PRIVILEGE privilege can grant and revoke system privileges from other users.

  F. Object privileges granted on a table automatically apply to all synonyms for that table.

  Correct Answer: ACF

• Question 160:

  Examine this command:

  TRUNCATE TABLE test;

  Table truncated.

  Which two are true? (Choose two.)

  A. The structure of the TEST table is removed.

  B. All the indexes on the TEST table are dropped.

  C. All the constraints on the TEST table are dropped.

  D. Removed rows can not be recovered using the ROLLBACK command.

  E. All the rows in the TEST table are removed.

  Correct Answer: BE