Oracle Database SQL — Question 191

Which two statements are true about Oracle databases and SQL? (Choose two.)

Answer options

• A. Updates performed by a database user can be rolled back by another user by using the ROLLBACK command.
• B. A query can access only tables within the same schema.
• C. The database guarantees read consistency at select level on user-created tables.
• D. A user can be the owner of multiple schemas in the same database.
• E. When you execute an update statement, the database instance locks each updated row.

Correct answer: C, E

Explanation

Answer C is correct because Oracle databases ensure read consistency for user-created tables during select operations. Answer E is also correct as the database instance locks the rows that are being updated to maintain data integrity. The other options are incorrect as they either misrepresent the capabilities of SQL queries or the ownership of schemas.