Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
What are the problems in interpreting tags such as ... in HTML? What does XML stand for? How does XML differ from HTML? Explain why XML is extensible.
Show a snippet of PHP code for disconnecting from the database. Explain the meaning of the code. With respect to HTTP, what does stateless mean?
How do BI systems differ from transaction processing systems? Name and describe the two main categories of BI systems.
What problems in operational data create the need to clean data before loading the data into a data warehouse?
Explain the difference between a data warehouse and a data mart. What is the enterprise data warehouse (EDW) architecture?
Describe the differences between operational databases and dimensional databases. What is a fact table? What type of data are stored in fact tables?
What is a slowly changing dimension? Why is the time dimension important in a dimensional model? What is a conformed dimension?
What does OLAP stand for? What is the distinguishing characteristic of OLAP reports? Define measure, dimension, and cube.
Explain what must be done when fully replicating a database but allowing only one computer to process updates.
What organizations should consider using a distributed database? Explain the meaning of the term object persistence.
What is an object-relational database? What is Big Data? What is the relationship between 1 MB of storage and 1EB of storage?
What is the NoSQL movement? What were the first two nonrelational data stores to be developed, and who developed them?
Explain MapReduce processing. What is Hadoop, and what is the history of the development of Hadoop to its current state? What are HBase and Pig?
Create a database in your DBMS named MDC, and use the MDC SQL scripts for your DBMS to create and populate the database tables.
What is an associative entity? What is an association relationship? Give an example of an association relationship other than one shown in this text.
Give an example of a supertype-subtype relationship, other than one shown in this text. Illustrate your answer using an IE Crow's Foot E-R diagram.
Describe how you have represented weak entities, if any exist. Describe how you have represented supertype and subtype entities, if any exist.
Describe how you would validate that your design is a good representation of the data model on which it is based.
What is the purpose of database administration? Explain how database administration tasks vary with the size and complexity of the database.
What is the goal of a database security system? Describe what an atomic transaction is and explain why atomicity is important.
Define the terms dirty read, nonrepeatable read, and phantom read. Explain the difference between an explicit lock and an implicit lock.
Explain the difference between an exclusive lock and a shared lock. How does releasing all locks at the end of a transaction relate to two-phase locking?
What is deadlock? How can it be avoided? How can it be resolved when it occurs? Explain the difference between optimistic and pessimistic locking.
Explain the meaning of the expression ACID transaction. Describe statement-level consistency. Describe transaction-level consistency.
Explain what read uncommitted isolation level is. Give an example of its use. Explain what read committed isolation level is.