Which two statements are true about Oracle databases and SQL? (Choose two.)
Which two statements are true about Oracle databases and SQL? (Choose two.)
Oracle databases guarantee read consistency at the select level on user-created tables, ensuring that any SQL query sees a consistent view of the data. Additionally, when executing an update statement, the database instance locks each updated row to maintain data integrity and prevent concurrent modifications, which is standard in most relational database management systems.
C and E are the most accurate
Answer should be C and D. C is ACID which Oracle SQL always do https://docs.oracle.com/cd/B13789_01/server.101/b10759/statements_8003.htm CREATE USER my_user IDENTIFIED BY my_password DEFAULT TABLESPACE tbspace1 QUOTA UNLIMITED ON tbspace1; GRANT schema1, schema2 TO my_user;
GRANT schema1, schema2 TO my_user make error , can grant only role or privileges https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/GRANT.html#GUID-20B4E2C0-A7F8-4BC8-A5E8-BE61BDC41AC3
C and E. https://docs.oracle.com/cd/B28359_01/server.111/b28318/schema.htm#CNCPT111 A schema is a collection of logical structures of data, or schema objects. A schema is owned by a database user and has the same name as that user. Each user owns a single schema. Schema objects can be created and manipulated with SQL and include the following types of objects: