Question

True/False- Please answer all
______1. Data warehouses reduce delay in analytical processing by integrating data from heterogeneous sources in advance.

______2. A data warehouse is a special type of database.

______3. Data warehouse is an organized collection of data, specially designed for On-line Transactional Processes (OLTP).

______4. When you install a database client on computer X, (e.g., SQL Server Management Studio), a database engine is created in computer X.

______5. A table column with varchar (10) data type can store string value ‘Александр’

______6. Data warehouses are designed to increase the efficiency of READ (e.g., SELECT) operations.

______7. NULL value can be used to represent missing values in databases.

______8. The database role datawriter has all the priviledges of datareader, but has more privileges than datareader

Answer 1

1. Data warehouses reduce delay in analytical processing by integrating data from heterogeneous sources in advance. TRUE

2. A data warehouse is a special type of database. TRUE

3. Data warehouse is an organized collection of data, specially designed for On-line Transactional Processes (OLTP). TRUE

4. When you install a database client on computer X, (e.g., SQL Server Management Studio), a database engine is created in computer X. TRUE

5. A table column with varchar (10) data type can store string value ‘Александр’. TRUE

6. Data warehouses are designed to increase the efficiency of READ (e.g., SELECT) operations. TRUE

7. NULL value can be used to represent missing values in databases. TRUE

8. The database role datawriter has all the priviledges of datareader, but has more privileges than datareader. TRUE