Discover the essential characteristics of SQL and its vital role in relational database management. Learn about data independence, ACID compliance, and its compatibility with various database systems.
Table of Contents
Question
Which three statements are true about Structured Query Language (SQL)? (Choose three.)
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.
Answer
B. It best supports relational databases.
C. It provides independence for logical data structures being manipulated from the underlying physical data storage.
E. It guarantees atomicity, consistency, isolation, and durability (ACID) features.
Explanation
The correct statements about Structured Query Language (SQL) are:
B. SQL best supports relational databases. It is designed to work seamlessly with the relational model, enabling efficient data management and manipulation within relational database systems.
C. SQL provides independence for logical data structures being manipulated from the underlying physical data storage. This means that users can interact with the data using logical structures without worrying about the physical storage details, allowing for flexibility and portability.
E. SQL guarantees atomicity, consistency, isolation, and durability (ACID) features. These properties ensure data integrity and reliability in transactions, making sure that database operations are handled consistently and accurately.
Oracle Database 12c SQL 1z0-071 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Oracle Database 12c SQL 1z0-071 exam and earn Oracle Database 12c SQL 1z0-071 certification.