Questions and Answers of Database Management Systems

List some factors that can cause large variations in the number of people trying to access a Web site simultaneously.
What can a company do to handle spikes in traffic to its Web site?
What does ‘‘availability’’ mean?Why is it important in the e-commerce environment?
What factors or events can affect a Web site’s availability?
What does ‘‘scalability’’ mean?Why is it important in the e-commerce environment?
What is different about data security concerns in the Internet environment vs. the non-Internet environment?
What techniques or equipment can be employed for data security in the Internet environment?
Why is data privacy a concern in the e-commerce environment?
What isXMLand why is it useful regarding database in the e-commerce environment?
Define and compare data administration and database administration.
List and describe the advantages of data administration and database administration.
List and describe the responsibilities of data administration and database administration.
Explain the concept of metadata.
List and describe suchmetadata realizations as passive and active data dictionaries, relational DBMS catalogs, and data repositories.
List the major data control issues handled by database management systems.
List and describe the types of data security breaches.
List and describe the types of data security measures.
Describe the concept of backup and recovery.
Explain what an object/relational database is.
Describe the value of developing abstract data types.
Explain the concept and practical use of data modeling.
Relate the idea of data as a corporate resource that can be used to gain a competitive advantage to the development of the database management systems environment.
Describe the evolution of data storage media during the last century.
Describe how data needs have historically driven many information technology developments.
Explain why humankind’s interest in data dates back to ancient times.
List several limitations in the relational database model.
Describe the concept of physical database design.
Model data using such complex relationships as generalization and aggregation, and such concepts as inheritance and polymorphism.
Describe the benefits of encapsulation.
Describe the major backup and recovery techniques.
Explain the problem of disaster recovery.
Describe the concept of concurrency control.
Design a data warehouse.
Build a data warehouse, including the steps of data extraction, data cleaning, data transformation, and data loading.
Describe how to use a data warehouse with online analytic processing and data mining.
List the types of expertise needed to administer a data warehouse.
List the challenges in data warehousing.
List the four differences between the Internet database environment and the standard database environment.
Describe the database connectivity issues in the Internet environment.
Describe the expanded set of data types found in the Internet environment.
Compare the enterprise data warehouse with the data mart.
Describe the data warehouse concept and list its main features.
Compare the data needs of transaction processing systems with those of decision support systems.
Describe such concurrency control issues andmeasures as the lost update problem, locks and deadlock, and versioning.
Describe the concepts and advantages of the client/server database approach.
Describe the concepts and advantages of the distributed database approach.
Explain how data can be distributed and replicated in a distributed database.
Describe the problem of concurrency control in a distributed database.
Describe the distributed join process.
Describe data partitioning in a distributed database.
Describe distributed directory management.
Describe such database control issues as performance, availability, scalability, and security and privacy in the Internet environment.
Describe the object-oriented database concept.
Describe how the referential integrity restrict, cascade, and set-to-null delete rules operate in a relational database.
Explain the concept of referential integrity.
Describe how unary and ternary relationships are implemented in a relational database.
Understand how the join operator facilitates data integration in relational database.
Describe how relational data retrieval is accomplished using the relational algebra select, project, and join operators.
Describe how one-to-one, one-to-many, and many-to-many binary relationships are implemented in a relational database.
Describe the major types of keys including primary, candidate, and foreign.
Define such basic relational database terms as relation and tuple.
Describe the concept of logical database design.
Design relational databases by converting entity-relationship diagrams into relational tables.
Describe the data normalization process.
Describe a variety of physical database design techniques ranging from adding indexes to denormalization.
List and describe the inputs to the physical database design process.
Describe how disk storage devices work.
Describe the principles of file organizations and access methods.
Learn basic SQL commands to manipulate data.
Learn basic SQL commands to build data structures.
Test tables for irregularities using the data normalization process.
Perform the data normalization process.
Explain why the relational database model became practical in about 1980.
Describe the principles of a relational query optimizer.
Describe a strategy for writing SQL SELECT statements.
List the five basic principles of the database concept.
Discuss the problems encountered in a non-database information systems environment.
Compare sequential access of data with direct access of data.
Identify the four basic operations performed on stored data.
Define data-related terms such as entity and attribute and storage-related terms such as field, record, and file.
Model data in business environments by drawing entity-relationship diagrams that involve unary, binary, and ternary relationships.
Recognize and describe intersection data.
Describe one-to-one, one-to-many, and many-to-many unary, binary, and ternary relationships.
Describe how data can be considered to be a manageable resource.
List the three problems created by data redundancy.
Describe the nature of data redundancy among many files.
Write SQL SELECT subqueries.
Write SQL SELECT commands that join relational tables.
Write SQL SELECT commands to retrieve relational data using a variety of operators including GROUP BY, ORDER BY, and the built-in functions AVG, SUM, MAX, MIN, COUNT.
Explain why providing support for data independence is an important feature of the database approach.
Explain why providing support for such control issues as data security, backup and recovery, and concurrency is an important feature of the database approach.
Explain why the ability to store multiple relationships is an important feature of the database approach.
State the primary defining feature of a database management system.
Explain the relationship between data integration and data redundancy in one file.
Recognize which relationships in the business environment are unary, binary, and ternary relationships.
What expectation should there be for a database management system with regard to handling data control issues such as data security, backup and recovery, and concurrency control? Why?
Name the four basic operations on stored data. In what important way is one in particular different from the other three?
What is sequential access? What is direct access?Which of the two is more important in today’s business environment? Why?
Give an example of and describe an application that would require sequential access in:a. The university environment.b. The insurance company environment.c. The furniture store environment.
Give an example of and describe an application that would require direct access in:a. The university environment.b. The insurance company environment.c. The furniture store environment.

Showing 600 - 700 of 779