Could you answer these true-false questions about SQL1.1) DBMS aims to provide data abstraction as much as possibleTrue False 1.2) High level conceptual models bind to a specific commercial databaseTrue False 1.3) Physical storage structure of the database is called as internal schemaTrue False 1.4) A table cannot have a relation to itself since it will cause and indefinitenessTrue False 1.5) An attribute can be atomic, composite, or multivaluedTrue False 1.6) Constraints should be used to force valid data entry / modification to the databaseTrue False 1.7) A primary key can contain only single row with null value since duplicate values are not allowedTrue False 1.8) Comparison with null can be meaningfully done with equals and not equals operatorTrue False 1.9) Order of execution is critical since some operations are only meaningful after some order (i.e. having)True False 1.10) As being a sub language of SQL, DML has select, insert, update, and delete operationsTrue False 1.11) SQL does not support creating or deleting database object and granting or revoking access rightsTrue False 1.12) Common Table Expression (CTE) is only used to develop recursive SQL queriesTrue False 1.13) The implicit goals of the design activity are information preservation and minimum redundancyTrue False 1.14) Update anomalies are known as insertion anomalies, deletion anomalies, and modification anomaliesTrue False 1.15) A well-designed database can handle both OLTP and OLAP operations efficientlyTrue False 1.16) Database engine uses statistics to generate estimated execution plans then picks the best oneTrue False 1.17) If a server has only one CPU core and single hyper-thread, then it does not support concurrent accessTrue False 1.18) A DBMS must have ability to prevent lost update, dirty read, and incorrect summary problemsTrue False 1.19) ACID means Atomicity, Consistency preservation, Isolation, and DurabilityTrue False 1.20) 2PL uses locking mechanism to prevent multiple transactions from accessing the items concurrentlyTrue False  1.1) DBMS aims to provide data abstraction as much as possible1.2) High level conceptual models bind to a specific commercial database1.3) Physical storage structure of the database is called as internal schemaTrue OFalse OTrue OFalse OTrue OFalse O1.4) A table cannot have a relation to itself since it will cause and indefinitenessTrue OFalse OTrue OFalse O1.5) An attribute can be atomic, composite, or multivalued1.6) Constraints should be used to force valid data entry / modification to the databaseFalse OFalse OTrue OTrue O1.7) A primary key can contain only single row with null value since duplicate values are not allowed1.8) Comparison with null can be meaningfully done with equals and not equals operator1.9) Order of execution is critical since some operations are only meaningful after some order (i.e. having)1.10) As being a sub language of SQL, DML has select, insert, update, and delete operations1.11) SQL does not support creating or deleting database object and granting or revoking access rights1.12) Common Table Expression (CTE) is only used to develop recursive SQL queries1.13) The implicit goals of the design activity are information preservation and minimum redundancyTrue OFalse OTrue OFalse OTrue OFalse OTrue OFalse OTrue OFalse OTrue OFalse O1.14) Update anomalies are known as insertion anomalies, deletion anomalies, and modification anomaliesTrue OFalse OTrue O1.15) A well-designed database can handle both OLTP and OLAP operations efficiently1.16) Database engine uses statistics to generate estimated execution plans then picks the best one1.17) If a server has only one CPU core and single hyper-thread, then it does not support concurrent access1.18) A DBMS must have ability to prevent lost update, dirty read, and incorrect summary problems1.19) ACID means Atomicity, Consistency preservation, Isolation, and Durability1.20) 2PL uses locking mechanism to prevent multiple transactions from accessing the items concurrentlyFalse OTrue OFalse OTrue OFalse OTrue OFalse OTrue OFalse OTrue OFalse O

Solution: 1. The answer to the1st question is "True". 2. The answer to the 2nd question is "False"…

Answered: Could you answer these true-false…

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter9: Database Design

Section: Chapter Questions

Problem 5P

See similar textbooks

Related questions

Concept explainers

Question

Could you answer these true-false questions about SQL

1.1) DBMS aims to provide data abstraction as much as possible
True 
False 
1.2) High level conceptual models bind to a specific commercial database
True 
False 
1.3) Physical storage structure of the database is called as internal schema
True 
False 
1.4) A table cannot have a relation to itself since it will cause and indefiniteness
True 
False 
1.5) An attribute can be atomic, composite, or multivalued
True 
False 
1.6) Constraints should be used to force valid data entry / modification to the database
True 
False 
1.7) A primary key can contain only single row with null value since duplicate values are not allowed
True 
False 
1.8) Comparison with null can be meaningfully done with equals and not equals operator
True 
False 
1.9) Order of execution is critical since some operations are only meaningful after some order (i.e. having)
True 
False 
1.10) As being a sub language of SQL, DML has select, insert, update, and delete operations
True 
False 
1.11) SQL does not support creating or deleting database object and granting or revoking access rights
True 
False 
1.12) Common Table Expression (CTE) is only used to develop recursive SQL queries
True 
False 
1.13) The implicit goals of the design activity are information preservation and minimum redundancy
True 
False 
1.14) Update anomalies are known as insertion anomalies, deletion anomalies, and modification anomalies
True 
False 
1.15) A well-designed database can handle both OLTP and OLAP operations efficiently
True 
False 
1.16) Database engine uses statistics to generate estimated execution plans then picks the best one
True 
False 
1.17) If a server has only one CPU core and single hyper-thread, then it does not support concurrent access
True 
False 
1.18) A DBMS must have ability to prevent lost update, dirty read, and incorrect summary problems
True 
False 
1.19) ACID means Atomicity, Consistency preservation, Isolation, and Durability
True 
False 
1.20) 2PL uses locking mechanism to prevent multiple transactions from accessing the items concurrently
True 
False 

1.1) DBMS aims to provide data abstraction as much as possible
1.2) High level conceptual models bind to a specific commercial database
1.3) Physical storage structure of the database is called as internal schema
True O
False O
True O
False O
True O
False O
1.4) A table cannot have a relation to itself since it will cause and indefiniteness
True O
False O
True O
False O
1.5) An attribute can be atomic, composite, or multivalued
1.6) Constraints should be used to force valid data entry / modification to the database
False O
False O
True O
True O
1.7) A primary key can contain only single row with null value since duplicate values are not allowed
1.8) Comparison with null can be meaningfully done with equals and not equals operator
1.9) Order of execution is critical since some operations are only meaningful after some order (i.e. having)
1.10) As being a sub language of SQL, DML has select, insert, update, and delete operations
1.11) SQL does not support creating or deleting database object and granting or revoking access rights
1.12) Common Table Expression (CTE) is only used to develop recursive SQL queries
1.13) The implicit goals of the design activity are information preservation and minimum redundancy
True O
False O
True O
False O
True O
False O
True O
False O
True O
False O
True O
False O
1.14) Update anomalies are known as insertion anomalies, deletion anomalies, and modification anomalies
True O
False O
True O
1.15) A well-designed database can handle both OLTP and OLAP operations efficiently
1.16) Database engine uses statistics to generate estimated execution plans then picks the best one
1.17) If a server has only one CPU core and single hyper-thread, then it does not support concurrent access
1.18) A DBMS must have ability to prevent lost update, dirty read, and incorrect summary problems
1.19) ACID means Atomicity, Consistency preservation, Isolation, and Durability
1.20) 2PL uses locking mechanism to prevent multiple transactions from accessing the items concurrently
False O
True O
False O
True O
False O
True O
False O
True O
False O
True O
False O

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.