TRUE or 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

1.4) A table cannot have a relation to itself since it will cause and indefiniteness

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

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

1.14) Update anomalies are known as insertion anomalies, deletion anomalies, and modification anomalies

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