Oracle
1Z0-071 · Question #323
Which three statements are true about Structured Query Language (SQL)? (Choose three.)
The correct answer is A. It best supports relational databases. D. It guarantees atomicity, consistency, isolation, and durability (ACID) features. E. It provides independence for logical data structures being manipulated from the underlying. https://docs.microsoft.com/en-us/sql/relational-databases/hierarchical-data-sql-server? view=sql-
Fundamental SQL and Queries
Question
Which three statements are true about Structured Query Language (SQL)? (Choose three.)
Options
- AIt best supports relational databases.
- BIt is used to define encapsulation and polymorphism for a relational table.
- CIt is the only language that can be used for both relational and object-oriented databases.
- DIt guarantees atomicity, consistency, isolation, and durability (ACID) features.
- EIt provides independence for logical data structures being manipulated from the underlying
- FIt requires that data be contained in hierarchical data storage.
How the community answered
(41 responses)- A80% (33)
- B5% (2)
- C2% (1)
- F12% (5)
Explanation
https://docs.microsoft.com/en-us/sql/relational-databases/hierarchical-data-sql-server? view=sql-
Topics
#SQL fundamentals#ACID#relational database#data independence
Community Discussion
No community discussion yet for this question.