Oracle Database SQL — Question 156

Which three statements are true about Structured Query Language (SQL)? (Choose three.)

Answer options

• A. It requires that data be contained in hierarchical data storage.
• B. It best supports relational databases.
• C. It provides independence for logical data structures being manipulated from the underlying physical data storage.
• D. It is the only language that can be used for both relational and object-oriented databases.
• E. It guarantees atomicity, consistency, isolation, and durability (ACID) features.
• F. It is used to define encapsulation and polymorphism for a relational table.

Correct answer: B, C, E

Explanation

Option B is correct because SQL is specifically designed to work with relational databases. Option C is also accurate as SQL abstracts the logical data structures from the underlying physical storage. Option E is true because SQL adheres to ACID properties, ensuring reliable transactions. Options A, D, and F are incorrect as they misrepresent the capabilities and requirements of SQL.