Online Access Free 1z0-071 Exam Questions

Examine the structure of the SALES table.

Examine this statement:

Which two statements are true about the SALES1 table? (Choose two.)

• A.It is created with no rows.
• B.It has PRIMARY KEY and UNIQUE constraints on the selected columns which had those constraints in the SALES table.
• C.It will not be created because the column-specified names in the SELECT and CREATE TABLE clauses do not match.
• D.It will have NOT NULL constraints on the selected columns which had those constraints in the SALES table.
• E.It will not be created because of the invalid WHERE clause.

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.
Which method or feature should you use?

• A.Taking a new snapshot and comparing it with a preserved snapshot
• B.AWR Compare Period report
• C.Active Session History (ASH) report
• D.Compare Period ADDM report

Table EMPLOYEEScontains columns including EMPLOYEE_ID, JOB_ID and SALARY.
Only the EMPLOYEE_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:

Which two statements are true? (Choose two.)

• A.Employee 200 will have SALARY set to the same value as the SALARY of employee 100
• B.Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100
• C.Employees 100 and 200 will have the same SALARY as before the update command
• D.Employees 100 and 200 will have the same JOB_ID as before the update command
• E.Employee 100 will have SALARY set to the same value as the SALARY of employee 200
• F.Employees 100 will have JOB_ID set to the same value as the JOB_ID of employee 200

Which two statements are true regarding the DELETE and TRUNCATE commands? (Choose two.)

• A.DELETE can be used to remove rows from multiple tables in one statement.
• B.DELETE and TRUNCATE can be used for tables that are parents for a child table that has a referential integrity constraint having an ON DELETE rule.
• C.DELETE can be used to remove rows only for tables that are parents for a child table that has a referential integrity constraint referring to the parent.
• D.DELETE can be used to remove data from specific columns as well as complete rows.
• E.DELETE can be used to remove rows from only one table in one statement.

Which two are true about savepoints? (Choose two.)

• A.After issuing a savepoint, you cannot roll back the complete transaction.
• B.A ROLLBACK TO SAVEPOINT command issued before the start of a transaction results in an error.
• C.You can commit updates done between two savepoints without committing other updates in the current transaction.
• D.After issuing a savepoints, you can roll back to the savepoint name within the current transaction.
• E.They make uncommitted updates visible to sessions owned by other users.
• F.They make uncommitted updates visible to other sessions owned by the same user.