Questions from Database Management

Q: Database servers frequently use one of the many parallel processing architectures.

Database servers frequently use one of the many parallel processing architectures. Discuss which elements of a query can be processed in parallel.

Q: What role can a query optimizer play in the selection of an

What role can a query optimizer play in the selection of an optimal set of indexes?

Q: Interview one person from a key business function, such as finance

Interview one person from a key business function, such as finance, human resources, or marketing. Concentrate your questions on the following items: How does he or she retrieve data needed to make bu...

Q: Explain how query writers can improve query processing performance through knowledge of

Explain how query writers can improve query processing performance through knowledge of query optimizers.

Q: What are the different elements of a query that can be processed

What are the different elements of a query that can be processed in parallel?

Q: Contrast the uses of a data dictionary and a repository in data

Contrast the uses of a data dictionary and a repository in data and database management.

Q: Contrast the following terms: a. horizontal partitioning; vertical

Contrast the following terms: a. horizontal partitioning; vertical partitioning b. repository; data dictionary c. physical file; tablespace d. before image; after image e. normalization; denormalizati...

Q: List and discuss five areas where threats to data security may occur

List and discuss five areas where threats to data security may occur.

Q: Explain the components of a repository system architecture. List and explain

Explain the components of a repository system architecture. List and explain the functions supported by a repository engine.

Q: List and briefly explain how integrity controls can be used for database

List and briefly explain how integrity controls can be used for database security.